Abfragezeit: 0.21 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 0.751 MB Zeilen zurückgegeben: 1
SELECT `data`
FROM `adqlu_session`
WHERE `session_id` = '303ohiabvdl68vd7pcev5l4vpc'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.04 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:44 |
| 12 | JSessionStorageDatabase->read() | Der selbe Aufruf in der Zeile darunter. |
| 11 | session_start() | JROOT/libraries/joomla/session/handler/native.php:259 |
| 10 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:49 |
| 9 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:81 |
| 8 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:636 |
| 7 | JSession->_start() | JROOT/libraries/joomla/session/session.php:596 |
| 6 | JSession->start() | JROOT/libraries/cms/application/cms.php:773 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.769 MB
DELETE
FROM `adqlu_session`
WHERE `time` < '1788496317'
„EXPLAIN“ unmöglich für Abfrage: DELETE
FROM `adqlu_session`
WHERE `time` < '1788496317'
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init for update | 0.02 ms |
| Updating | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:790 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.061 MB Speichernutzung vor Abfrage: 0.798 MB Zeilen zurückgegeben: 47
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adqlu_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | extension | extension | 82 | const | 47 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:448 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:120 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:589 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 0.872 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM adqlu_usergroups AS a
LEFT JOIN adqlu_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:835 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:904 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.877 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `adqlu_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:921 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 0.886 MB Zeilen zurückgegeben: 76
SELECT folder AS type, element AS name, params
FROM adqlu_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | extension | extension | 82 | const | 114 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:310 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.21 ms Nach letzter Abfrage: 6.03 ms Abfragespeichernutzung: 0.602 MB Speichernutzung vor Abfrage: 1.536 MB Zeilen zurückgegeben: 345
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM adqlu_menu AS m
LEFT JOIN adqlu_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 480 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.10 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
| 18 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 17 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 16 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:145 |
| 15 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:439 |
| 14 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 13 | JApplicationSite->getMenu() | JROOT/libraries/cms/application/site.php:438 |
| 12 | JApplicationSite->getTemplate() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:847 |
| 11 | require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php | JROOT/libraries/zauan/shortcodes/shortcodes.php:290 |
| 10 | include_once JROOT/libraries/zauan/shortcodes/shortcodes.php | JROOT/libraries/loader.php:219 |
| 9 | JLoader::import() | JROOT/libraries/loader.php:682 |
| 8 | jimport() | JROOT/plugins/system/hg_assets/hg_assets.php:16 |
| 7 | require_once JROOT/plugins/system/hg_assets/hg_assets.php | JROOT/libraries/cms/plugin/helper.php:230 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 3.76 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.988 MB Zeilen zurückgegeben: 6
SELECT id, home, template, s.params
FROM adqlu_template_styles as s
LEFT JOIN adqlu_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | staging_otterbein.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:484 |
| 12 | JApplicationSite->getTemplate() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:847 |
| 11 | require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php | JROOT/libraries/zauan/shortcodes/shortcodes.php:290 |
| 10 | include_once JROOT/libraries/zauan/shortcodes/shortcodes.php | JROOT/libraries/loader.php:219 |
| 9 | JLoader::import() | JROOT/libraries/loader.php:682 |
| 8 | jimport() | JROOT/plugins/system/hg_assets/hg_assets.php:16 |
| 7 | require_once JROOT/plugins/system/hg_assets/hg_assets.php | JROOT/libraries/cms/plugin/helper.php:230 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 4.57 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.253 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adqlu_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 16 | JDatabaseDriver->loadObject() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:156 |
| 14 | JLibraryHelper::_load() | JROOT/libraries/cms/library/helper.php:47 |
| 13 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:90 |
| 12 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:274 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/gdpr/gdpr.php:1026 |
| 8 | plgSystemGdpr->onAfterRoute() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1125 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 9.43 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.246 MB
UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"d8746d335c28008925a785359a1e5a41\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"d8746d335c28008925a785359a1e5a41\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init for update | 0.05 ms |
| Updating | 0.04 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.05 ms |
| Query end | 0.00 ms |
| Commit | 8.95 ms |
| Closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:119 |
| 13 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:325 |
| 12 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:284 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/gdpr/gdpr.php:1026 |
| 8 | plgSystemGdpr->onAfterRoute() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1125 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.36 ms Nach letzter Abfrage: 3.65 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.293 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| Checking privileges on cached | 0.02 ms |
| Checking permissions | 0.02 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer | | 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:164 |
| 5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:329 |
| 4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.81 ms Nach letzter Abfrage: 11.68 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 5.382 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `adqlu_assets`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `adqlu_assets`
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Checking permissions | 0.02 ms |
| Closing tables | 0.02 ms |
| Opening tables | 0.72 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.02 ms |
| Init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| Checking permissions | 0.12 ms |
| Closing tables | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Removing tmp table | 0.18 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 18 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 17 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
| 16 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 15 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:696 |
| 14 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.25 ms Nach letzter Abfrage: 1.65 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.474 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_assets
WHERE `id` = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_assets | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 15 | JTable->load() | JROOT/libraries/joomla/access/access.php:697 |
| 14 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.480 MB Zeilen zurückgegeben: 1
SELECT a.rules
FROM adqlu_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_asset_name | PRIMARY,idx_asset_name | 4,202 | NULL | 2 | Using union(PRIMARY,idx_asset_name); Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
| 13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.88 ms Nach letzter Abfrage: 1.20 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.491 MB Zeilen zurückgegeben: 46
SELECT element
FROM adqlu_extensions
WHERE type = 'component'
AND enabled = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | extension | extension | 82 | const | 47 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.06 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| Init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.21 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:413 |
| 15 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 14 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 5.506 MB Zeilen zurückgegeben: 46
SELECT a.name, a.rules
FROM adqlu_assets AS a
WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_customfilters','com_djimageslider','com_finder','com_flippingbook','com_gdpr','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_listmanager','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_seoglossary','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_virtuemart_magicscroll','com_virtuemart_magiczoomplus','com_weblinks','com_wrapper') OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | range | idx_asset_name | idx_asset_name | 202 | NULL | 47 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.02 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.02 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 16 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:441 |
| 15 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 14 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.21 ms Nach letzter Abfrage: 2.00 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.759 MB Zeilen zurückgegeben: 30
SHOW FULL COLUMNS
FROM `adqlu_content`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `adqlu_content`
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Checking permissions | 0.01 ms |
| Closing tables | 0.01 ms |
| Opening tables | 0.35 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| Checking permissions | 0.19 ms |
| Closing tables | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Removing tmp table | 0.10 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 12 | JTable->__construct() | JROOT/libraries/legacy/table/content.php:31 |
| 11 | JTableContent->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 10 | JTable::getInstance() | JROOT/components/com_content/models/article.php:264 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.96 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 5.832 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_content
WHERE `id` = '245'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 10 | JTable->load() | JROOT/components/com_content/models/article.php:265 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 8.22 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.841 MB
UPDATE adqlu_content
SET `hits` = (`hits` + 1)
WHERE `id` = '245'
„EXPLAIN“ unmöglich für Abfrage: UPDATE adqlu_content
SET `hits` = (`hits` + 1)
WHERE `id` = '245'
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init for update | 0.02 ms |
| Updating | 0.03 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 8.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/table/table.php:1228 |
| 10 | JTable->hit() | JROOT/components/com_content/models/article.php:266 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.865 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
on c.id = a.catid
LEFT JOIN adqlu_users AS u
on u.id = a.created_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 245
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:46:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:46:57')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | const | PRIMARY,idx_state | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | v | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 0 | |
| 2 | LATERAL DERIVED | cat | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 2 | LATERAL DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 8 | Using index condition; Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.10 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.05 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:159 |
| 12 | ContentModelArticle->getItem() | JROOT/libraries/legacy/view/legacy.php:408 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.01 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.920 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM adqlu_categories as c
LEFT JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN adqlu_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=27
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 38 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | staging_otterbein.c.id | 10 | Using where |
| 2 | DERIVED | parent | ref | cat_idx,idx_left_right | cat_idx | 202 | const | 9 | Using index condition; Using temporary; filesort wurde genutzt |
| 2 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 38 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.09 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.05 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.00 ms |
| Creating sort index | 0.26 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.04 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 13 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 12 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
| 11 | ContentHelperRoute::getArticleRoute() | JROOT/components/com_content/views/article/view.html.php:71 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.971 MB Zeilen zurückgegeben: 3
SELECT `m`.`tag_id`,`t`.*
FROM `adqlu_contentitem_tag_map` AS m
INNER JOIN `adqlu_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 245
AND `t`.`published` = 1
AND t.access IN (1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 59 | Using where |
| 1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | staging_otterbein.t.id | 4 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.20 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:435 |
| 11 | JHelperTags->getItemTags() | JROOT/components/com_content/views/article/view.html.php:156 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.74 ms Nach letzter Abfrage: 3.58 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.163 MB Zeilen zurückgegeben: 0
SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('Spezial-Zement für den Bau der A7-Autobahnbrücke bei Fulda\nFür die Betonherstellung beim Bau der Brücke an der Autobahn A7 bei Fulda-Künzell war unser Portlandkalksteinzement CEM II/A-LL 42,5 R für die ausführenden Firmen die erste Wahl. Im Rahmen des anspruchsvollen Brückenbau-Projektes wurden ca. 400 m3 Beton verarbeitet, wobei die schnelle Festigkeitsentwicklung des eingesetzten OTTERBEIN-Zements einen raschen Baufortschritt ermöglichte.\nOTTERBEIN Portlandkalksteinzement CEM II/A-LL 42,5 R ist ein Normzement der Festigkeitsklasse 42,5 nach EN 197-1 mit hoher Früh- und Endfestigkeit und damit in Bereichen einsetzbar, wo eine rasche Festigkeitsentwicklung erwünscht wird. Er wird durch gemeinsames Vermahlen von Portlandzementklinker, einem hochwertigen, besonders reinen Kalkstein und Calciumsulfat als Erstarrungsregler hergestellt und ist optimal geeignet für die Herstellung von Betonen für Betonfestigkeitsklassen ≥ C 30/37.\n \nVerwendete OTTERBEIN-Produkte:\n\n\nPortlandkalksteinzement CEM II/A-LL 42,5 R\n\n\n \n{google_map}autobahn a7 künzell|zoom:10|width:5000|height:500|version:classic{/google_map}\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Spezial-Zement für den Bau der A7-Autobahnbrücke bei Fulda\nFür die Betonherstellung beim Bau der Brücke an der Autobahn A7 bei Fulda-Künzell war unser Portlandkalksteinzement CEM II/A-LL 42,5 R für die ausführenden Firmen die erste Wahl. Im Rahmen des anspruchsvollen Brückenbau-Projektes wurden ca. 400 m3 Beton verarbeitet, wobei die schnelle Festigkeitsentwicklung des eingesetzten OTTERBEIN-Zements einen raschen Baufortschritt ermöglichte.\nOTTERBEIN Portlandkalksteinzement CEM II/A-LL 42,5 R ist ein Normzement der Festigkeitsklasse 42,5 nach EN 197-1 mit hoher Früh- und Endfestigkeit und damit in Bereichen einsetzbar, wo eine rasche Festigkeitsentwicklung erwünscht wird. Er wird durch gemeinsames Vermahlen von Portlandzementklinker, einem hochwertigen, besonders reinen Kalkstein und Calciumsulfat als Erstarrungsregler hergestellt und ist optimal geeignet für die Herstellung von Betonen für Betonfestigkeitsklassen ≥ C 30/37.\n \nVerwendete OTTERBEIN-Produkte:\n\n\nPortlandkalksteinzement CEM II/A-LL 42,5 R\n\n\n \n{google_map}autobahn a7 künzell|zoom:10|width:5000|height:500|version:classic{/google_map}\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'de-DE' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | t | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.06 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.36 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:263 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:161 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.68 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 6.274 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
on c.id = a.catid
LEFT JOIN adqlu_users AS u
on u.id = a.created_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 245
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:46:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:46:57')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | const | PRIMARY,idx_state | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | v | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 0 | |
| 2 | LATERAL DERIVED | cat | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 2 | LATERAL DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 8 | Using index condition; Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:159 |
| 15 | ContentModelArticle->getItem() | JROOT/plugins/content/myshariff/myshariff.php:221 |
| 14 | plgContentMyShariff->excludeAREA() | JROOT/plugins/content/myshariff/myshariff.php:368 |
| 13 | plgContentMyShariff->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:161 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.056 MB Speichernutzung vor Abfrage: 6.285 MB Zeilen zurückgegeben: 458
SELECT a.id, a.parent_id
FROM adqlu_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1145 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:332 |
| 17 | JAccess::preloadPermissionsParentIdMapping() | JROOT/libraries/joomla/access/access.php:240 |
| 16 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 15 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 14 | JUser->authorise() | JROOT/plugins/content/pagenavigation/pagenavigation.php:54 |
| 13 | PlgContentPagenavigation->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:167 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.49 ms Abfragespeichernutzung: 0.128 MB Speichernutzung vor Abfrage: 6.544 MB Zeilen zurückgegeben: 458
SELECT a.id, a.name, a.rules
FROM adqlu_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1145 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1255 |
| 18 | JDatabaseDriver->getIterator() | JROOT/libraries/joomla/access/access.php:373 |
| 17 | JAccess::preloadPermissions() | JROOT/libraries/joomla/access/access.php:243 |
| 16 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 15 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 14 | JUser->authorise() | JROOT/plugins/content/pagenavigation/pagenavigation.php:54 |
| 13 | PlgContentPagenavigation->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:167 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.910 MB Zeilen zurückgegeben: 2
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 27
AND a.state = 1
AND a.access IN (1,1)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-04 04:46:57')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-04 04:46:57')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 2 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | cc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.05 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/pagenavigation/pagenavigation.php:152 |
| 13 | PlgContentPagenavigation->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:167 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.50 ms Nach letzter Abfrage: 8.39 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.936 MB Zeilen zurückgegeben: 0
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM adqlu_modules AS m
LEFT JOIN adqlu_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN adqlu_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND module = 'mod_maximenuck'
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-09-04 04:46:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:46:57')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 594 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | newsfeeds | 204 | const,const | 1 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | staging_otterbein.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | staging_otterbein.m.id | 3 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.06 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/maximenuckmobile/maximenuckmobile.php:248 |
| 8 | plgSystemMaximenuckmobile->getMaximenuModules() | JROOT/plugins/system/maximenuckmobile/maximenuckmobile.php:105 |
| 7 | plgSystemMaximenuckmobile->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:69 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.05 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.937 MB Zeilen zurückgegeben: 0
SELECT id,placeholder
FROM `adqlu_gdpr_checkbox`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_gdpr_checkbox | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/gdpr/gdpr.php:1291 |
| 7 | plgSystemGdpr->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:69 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 3.92 ms Nach letzter Abfrage: 2.11 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.055 MB Zeilen zurückgegeben: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM adqlu_modules AS m
LEFT JOIN adqlu_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN adqlu_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-09-04 04:46:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:46:57')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 594 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 403 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | staging_otterbein.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | staging_otterbein.m.id | 3 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.05 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 3.57 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 12 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:425 |
| 11 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:361 |
| 10 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 9 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:514 |
| 8 | JDocumentHtml->countModules() | JROOT/templates/kallyas/index.php:18 |
| 7 | require JROOT/templates/kallyas/index.php | JROOT/libraries/joomla/document/html.php:578 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:640 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:455 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1072 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.14 ms Nach letzter Abfrage: 19.45 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.291 MB Zeilen zurückgegeben: 0
SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('{myshariff}\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '{myshariff}\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'de-DE' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | t | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:263 |
| 16 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:139 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.309 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
on c.id = a.catid
LEFT JOIN adqlu_users AS u
on u.id = a.created_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 245
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:46:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:46:57')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | const | PRIMARY,idx_state | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | v | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 0 | |
| 2 | LATERAL DERIVED | cat | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 2 | LATERAL DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 8 | Using index condition; Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:159 |
| 18 | ContentModelArticle->getItem() | JROOT/plugins/content/myshariff/myshariff.php:221 |
| 17 | plgContentMyShariff->excludeAREA() | JROOT/plugins/content/myshariff/myshariff.php:368 |
| 16 | plgContentMyShariff->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:139 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 1.86 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 7.372 MB Zeilen zurückgegeben: 0
SELECT *
FROM `adqlu_modules`
WHERE `id`='121'
AND `published`='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:60 |
| 28 | hg_module() | JROOT/libraries/zauan/shortcodes/shortcodes.php:98 |
| 27 | do_shortcode_tag() | Der selbe Aufruf in der Zeile darunter. |
| 26 | preg_replace_callback() | JROOT/libraries/zauan/shortcodes/shortcodes.php:44 |
| 25 | do_shortcode() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes_grid.php:34 |
| 24 | hg_grid() | JROOT/libraries/zauan/shortcodes/shortcodes.php:98 |
| 23 | do_shortcode_tag() | Der selbe Aufruf in der Zeile darunter. |
| 22 | preg_replace_callback() | JROOT/libraries/zauan/shortcodes/shortcodes.php:44 |
| 21 | do_shortcode() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes_grid.php:421 |
| 20 | hg_row() | JROOT/libraries/zauan/shortcodes/shortcodes.php:98 |
| 19 | do_shortcode_tag() | Der selbe Aufruf in der Zeile darunter. |
| 18 | preg_replace_callback() | JROOT/libraries/zauan/shortcodes/shortcodes.php:44 |
| 17 | do_shortcode() | JROOT/plugins/system/hg_assets/hg_assets.php:136 |
| 16 | plgSystemHG_Assets->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:105 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.374 MB Zeilen zurückgegeben: 0
SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER(' \nZEMENT- UND KALKWERKE OTTERBEIN GMBH & CO. KG\nHauptstraße 50\n36137 Großenlüder-Müs (Germany)\nTel.: +49 6648 68 - 0\nFax.: +49 6648 68 - 400\ninfo@zkw-otterbein.de\n\n\n\n\nyoutube\nfacebook\n\n\n\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR ' \nZEMENT- UND KALKWERKE OTTERBEIN GMBH & CO. KG\nHauptstraße 50\n36137 Großenlüder-Müs (Germany)\nTel.: +49 6648 68 - 0\nFax.: +49 6648 68 - 400\ninfo@zkw-otterbein.de\n\n\n\n\nyoutube\nfacebook\n\n\n\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'de-DE' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | t | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:263 |
| 16 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:105 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.391 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
on c.id = a.catid
LEFT JOIN adqlu_users AS u
on u.id = a.created_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 245
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:46:57')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:46:57')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | const | PRIMARY,idx_state | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | v | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 0 | |
| 2 | LATERAL DERIVED | cat | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 2 | LATERAL DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 8 | Using index condition; Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 19 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:159 |
| 18 | ContentModelArticle->getItem() | JROOT/plugins/content/myshariff/myshariff.php:221 |
| 17 | plgContentMyShariff->excludeAREA() | JROOT/plugins/content/myshariff/myshariff.php:368 |
| 16 | plgContentMyShariff->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:105 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.32 ms Nach letzter Abfrage: 1.06 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 7.409 MB Zeilen zurückgegeben: 0
SELECT *
FROM adqlu_jmap_metainfo
WHERE `linkurl` = 'https://staging.zkw-otterbein.de/referenzen/autobahnbruecke'
AND `published` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_jmap_metainfo | ref | linkurl,published | linkurl | 767 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.04 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:276 |
| 12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:69 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 9 | JApplicationBase->triggerEvent() | JROOT/libraries/joomla/document/renderer/html/head.php:58 |
| 8 | JDocumentRendererHtmlHead->fetchHead() | JROOT/libraries/joomla/document/renderer/html/head.php:34 |
| 7 | JDocumentRendererHtmlHead->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
4 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
on c.id = a.catid
LEFT JOIN adqlu_users AS u
on u.id = a.created_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
3 × SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adqlu_extensions`
2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM adqlu_modules AS m
LEFT JOIN adqlu_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN adqlu_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `data`
FROM `adqlu_session`
1 × SELECT *
FROM `adqlu_modules`
1 × SELECT id,placeholder
FROM `adqlu_gdpr_checkbox
1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS cc
ON cc.id = a.catid
1 × SELECT a.id, a.name, a.rules
FROM adqlu_assets AS a
1 × SELECT a.id, a.parent_id
FROM adqlu_assets AS a
1 × SELECT `m`.`tag_id`,`t`.*
FROM `adqlu_contentitem_tag_map` AS m
INNER JOIN `adqlu_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM adqlu_categories as c
LEFT JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM adqlu_content
1 × SELECT a.name, a.rules
FROM adqlu_assets AS a
1 × SELECT element
FROM adqlu_extensions
1 × SELECT a.rules
FROM adqlu_assets AS a
1 × SELECT *
FROM adqlu_assets
1 × SELECT *
FROM adqlu_languages
1 × SELECT id, home, template, s.params
FROM adqlu_template_styles as s
LEFT JOIN adqlu_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM adqlu_menu AS m
LEFT JOIN adqlu_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM adqlu_extensions
1 × SELECT id, rules
FROM `adqlu_viewlevels
1 × SELECT b.id
FROM adqlu_usergroups AS a
LEFT JOIN adqlu_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM adqlu_jmap_metainfo
