Abfragezeit: 0.26 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 0.751 MB Zeilen zurückgegeben: 1
SELECT `data`
FROM `adqlu_session`
WHERE `session_id` = 'l6hch0kc03r6o7qv3kvrioa0rs'
| 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.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.02 ms |
| Closing tables | 0.01 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.02 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: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.20 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.769 MB
DELETE
FROM `adqlu_session`
WHERE `time` < '1788496345'
„EXPLAIN“ unmöglich für Abfrage: DELETE
FROM `adqlu_session`
WHERE `time` < '1788496345'
| 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.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.03 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.16 ms Nach letzter Abfrage: 0.81 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.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.02 ms |
| Sending cached result to clien | 0.02 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.11 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.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 | | 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.13 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.26 ms Nach letzter Abfrage: 5.80 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.02 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.14 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.07 ms Nach letzter Abfrage: 3.71 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.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 | | 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.07 ms Nach letzter Abfrage: 4.34 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: 8.26 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.246 MB
UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"d79615b102f81e54af661d9a9bb26a3f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"d79615b102f81e54af661d9a9bb26a3f\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| 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.04 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.06 ms |
| Query end | 0.00 ms |
| Commit | 7.92 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.02 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.17 ms Nach letzter Abfrage: 0.82 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.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.02 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.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: 0.58 ms Nach letzter Abfrage: 2.74 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 5.503 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.03 ms |
| Checking permissions | 0.00 ms |
| Closing tables | 0.00 ms |
| Opening tables | 0.20 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| Checking permissions | 0.03 ms |
| Closing tables | 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 |
| Removing tmp table | 0.05 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 | | 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 21 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 20 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
| 19 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 18 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:696 |
| 17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.16 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 5.534 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.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.03 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.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 18 | JTable->load() | JROOT/libraries/joomla/access/access.php:697 |
| 17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.11 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.541 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.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 | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.15 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 5.554 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 | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:332 |
| 18 | JAccess::preloadPermissionsParentIdMapping() | JROOT/libraries/joomla/access/access.php:240 |
| 17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.48 ms Abfragespeichernutzung: 0.129 MB Speichernutzung vor Abfrage: 5.796 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 | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1255 |
| 19 | JDatabaseDriver->getIterator() | JROOT/libraries/joomla/access/access.php:373 |
| 18 | JAccess::preloadPermissions() | JROOT/libraries/joomla/access/access.php:243 |
| 17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.26 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 6.174 MB Zeilen zurückgegeben: 8
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,COUNT(i.`id`) AS numitems
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)
LEFT JOIN `adqlu_content` AS i
ON i.`catid` = c.id
AND i.state = 1
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=36
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 | i | ref | idx_state,idx_catid | idx_catid | 4 | staging_otterbein.c.id | 6 | 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.11 ms |
| Checking permissions | 0.00 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.02 ms |
| Init | 0.06 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Statistics | 0.07 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.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.10 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.00 ms |
| Creating sort index | 0.40 ms |
| Creating sort index | 0.04 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.01 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.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 15 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 14 | JCategories->get() | JROOT/components/com_content/models/category.php:354 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:115 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.29 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.235 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.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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.08 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.00 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.01 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 22 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:413 |
| 21 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 20 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 18 | JUser->authorise() | JROOT/components/com_content/models/articles.php:466 |
| 17 | ContentModelArticles->getListQuery() | JROOT/libraries/legacy/model/list.php:129 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.08 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 6.252 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.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 | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 22 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:441 |
| 21 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 20 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 18 | JUser->authorise() | JROOT/components/com_content/models/articles.php:466 |
| 17 | ContentModelArticles->getListQuery() | JROOT/libraries/legacy/model/list.php:129 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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: 2.57 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 6.499 MB Zeilen zurückgegeben: 6
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_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 != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.catid = 36 OR a.catid IN (
SELECT sub.id
FROM adqlu_categories as sub
INNER JOIN adqlu_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 36))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:47:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:47:25')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | range | PRIMARY,idx_access | idx_access | 4 | NULL | 38 | Using index condition; Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | staging_otterbein.c.id | 6 | Using index condition; Using where |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.a.created_by | 1 | Using where |
| 1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.a.modified_by | 1 | Using where |
| 1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.c.parent_id | 1 | Using where |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.a.id | 1 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | staging_otterbein.c.id | 10 | Using where |
| 3 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 3 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 7 | Using where; Using index |
| 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.13 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.06 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 ms |
| Executing | 0.00 ms |
| Sending data | 0.82 ms |
| Executing | 0.01 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.75 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.06 ms |
| Creating sort index | 0.00 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 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.00 ms |
| Removing tmp table | 0.00 ms |
| Freeing items | 0.01 ms |
| Removing tmp table | 0.01 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.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:310 |
| 16 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.69 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.688 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_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 != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.catid = 36 OR a.catid IN (
SELECT sub.id
FROM adqlu_categories as sub
INNER JOIN adqlu_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 36))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:47:25')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:47:25')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY,idx_access | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 38 | Using where |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | staging_otterbein.c.id | 6 | Using index condition; Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | staging_otterbein.c.id | 10 | Using where |
| 3 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 3 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 7 | Using where; Using index |
| 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.11 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.04 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.04 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 |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| Executing | 0.00 ms |
| Sending data | 0.57 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.38 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 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.00 ms |
| Removing tmp table | 0.00 ms |
| Freeing items | 0.01 ms |
| Removing tmp table | 0.01 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.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/legacy/model/legacy.php:337 |
| 16 | JModelLegacy->_getListCount() | JROOT/libraries/legacy/model/list.php:278 |
| 15 | JModelList->getTotal() | JROOT/libraries/legacy/model/list.php:228 |
| 14 | JModelList->getPagination() | JROOT/components/com_content/models/category.php:265 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.47 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 6.698 MB Zeilen zurückgegeben: 0
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.category'
AND `m`.`content_item_id` = 36
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.18 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 | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:435 |
| 12 | JHelperTags->getItemTags() | JROOT/libraries/legacy/view/category.php:217 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->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.57 ms Nach letzter Abfrage: 3.01 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.868 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('Als Restaurator bin ich fast täglich mit den fatalen Folgen falsch verwendeter Baustoffe im Denkmalschutz konfrontiert. Aus diesem Grund setze ich seit Jahren konsequent auf CALCIDUR®/HYDRADUR®, weil ich mir damit sicher sein kann, dass meine Arbeit Bestand hat und der Auftraggeber sich auf Nachhaltigkeit und Investitionssicherheit verlassen kann.\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Als Restaurator bin ich fast täglich mit den fatalen Folgen falsch verwendeter Baustoffe im Denkmalschutz konfrontiert. Aus diesem Grund setze ich seit Jahren konsequent auf CALCIDUR®/HYDRADUR®, weil ich mir damit sicher sein kann, dass meine Arbeit Bestand hat und der Auftraggeber sich auf Nachhaltigkeit und Investitionssicherheit verlassen kann.\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.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.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.22 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.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/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/category/view.html.php:106 |
| 10 | ContentViewCategory->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.48 ms Nach letzter Abfrage: 0.71 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 6.902 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.01 ms |
| Checking permissions | 0.00 ms |
| Closing tables | 0.00 ms |
| Opening tables | 0.13 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| Checking permissions | 0.07 ms |
| Closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.04 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 | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 19 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 18 | JTable->__construct() | JROOT/libraries/legacy/table/content.php:31 |
| 17 | JTableContent->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 16 | JTable::getInstance() | JROOT/plugins/content/myshariff/myshariff.php:128 |
| 15 | plgContentMyShariff->getShariffHTML() | JROOT/plugins/content/myshariff/myshariff.php:200 |
| 14 | plgContentMyShariff->getShariffTag() | JROOT/plugins/content/myshariff/myshariff.php:381 |
| 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/category/view.html.php:106 |
| 10 | ContentViewCategory->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.55 ms Nach letzter Abfrage: 1.49 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.053 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('Ich empfehle Natürlichen Hydraulischen Kalk, weil er mir als Verarbeiter durch die hydraulischen Bestandteile eine sichere Ausführung ermöglicht und meinen Kunden durch die karbonatischen Bindemittelkomponenten eine große Nachhaltigkeit garantiert.\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Ich empfehle Natürlichen Hydraulischen Kalk, weil er mir als Verarbeiter durch die hydraulischen Bestandteile eine sichere Ausführung ermöglicht und meinen Kunden durch die karbonatischen Bindemittelkomponenten eine große Nachhaltigkeit garantiert.\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.04 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.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.20 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.00 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/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/category/view.html.php:106 |
| 10 | ContentViewCategory->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.58 ms Nach letzter Abfrage: 0.57 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.067 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('Wir verwenden die Zemente von den Zement- und Kalkwerken OTTERBEIN zur Herstellung unseres regional bekannten, guten und gleichmäßigen Transportbetons. Die Firma Elo Beton als mittelständisches Unternehmen setzt auf eine starke Region mit innovativen Firmen und angepassten Produkten. Die Firma OTTERBEIN ist mit ihren Produkten innovativ und achtet auf eine nachhaltige ressourcenschonende Rohstoffgewinnung.\n \n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Wir verwenden die Zemente von den Zement- und Kalkwerken OTTERBEIN zur Herstellung unseres regional bekannten, guten und gleichmäßigen Transportbetons. Die Firma Elo Beton als mittelständisches Unternehmen setzt auf eine starke Region mit innovativen Firmen und angepassten Produkten. Die Firma OTTERBEIN ist mit ihren Produkten innovativ und achtet auf eine nachhaltige ressourcenschonende Rohstoffgewinnung.\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.04 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.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.23 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.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/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/category/view.html.php:106 |
| 10 | ContentViewCategory->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.58 ms Nach letzter Abfrage: 0.57 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.081 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('Der Baustoffhandel Leinweber setzt auf eine starke Region mit innovativen Firmen und angepassten Produkten. Aus diesem Grund verwenden wir die Produkte der Firma ZKW OTTERBEIN. Beispielsweise kommen die Zemente von OTTERBEIN bei der Herstellung unseres qualitativ hochwertigen Betons in unserer Betontankstelle zum Einsatz. Zudem möchten wir die Kalkprodukte für den Ökologischen Hausbau der Firma OTTERBEIN lobend hervorheben, da diese einfach zu verarbeiten sind und besonders für Allergiker empfohlen werden können.\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Der Baustoffhandel Leinweber setzt auf eine starke Region mit innovativen Firmen und angepassten Produkten. Aus diesem Grund verwenden wir die Produkte der Firma ZKW OTTERBEIN. Beispielsweise kommen die Zemente von OTTERBEIN bei der Herstellung unseres qualitativ hochwertigen Betons in unserer Betontankstelle zum Einsatz. Zudem möchten wir die Kalkprodukte für den Ökologischen Hausbau der Firma OTTERBEIN lobend hervorheben, da diese einfach zu verarbeiten sind und besonders für Allergiker empfohlen werden können.\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.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.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.24 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.00 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/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/category/view.html.php:106 |
| 10 | ContentViewCategory->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.56 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.095 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('Mit den CALCEA® und CAREMA® Kalkprodukten kann ich baubiologisch einwandfreie Oberflächen schaffen, die auch noch das Raumklima verbessern. Durch die Vielzahl der kreativen Möglichkeiten – von rau bis glatt und von natur bis farbig – bleiben keine Wünsche offen. Meine Kunden lieben die Möglichkeit Ihre Wohnwelt selbst mitzugestalten. Mit dem Mehrwert Allergiker-geeigneter Produkte!\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Mit den CALCEA® und CAREMA® Kalkprodukten kann ich baubiologisch einwandfreie Oberflächen schaffen, die auch noch das Raumklima verbessern. Durch die Vielzahl der kreativen Möglichkeiten – von rau bis glatt und von natur bis farbig – bleiben keine Wünsche offen. Meine Kunden lieben die Möglichkeit Ihre Wohnwelt selbst mitzugestalten. Mit dem Mehrwert Allergiker-geeigneter Produkte!\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.04 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.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.22 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.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/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/category/view.html.php:106 |
| 10 | ContentViewCategory->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.51 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.106 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('Ich setze CALCEA® Kalk­putze ein, weil ich von den ökologischen und bau­biologischen Eigen­schaften überzeugt bin!\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Ich setze CALCEA® Kalk­putze ein, weil ich von den ökologischen und bau­biologischen Eigen­schaften überzeugt bin!\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.04 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.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.17 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.00 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 | | 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/category/view.html.php:106 |
| 10 | ContentViewCategory->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.41 ms Nach letzter Abfrage: 4.68 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 7.168 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:47:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:47:25')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 648 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.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.04 ms |
| Checking permissions | 0.00 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.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 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.01 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.11 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.170 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.94 ms Nach letzter Abfrage: 1.83 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.222 MB Zeilen zurückgegeben: 8
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:47:25')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:47:25')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 648 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.04 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.60 ms |
| End of update loop | 0.01 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.01 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.11 ms Nach letzter Abfrage: 17.67 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 7.515 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.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 | | 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.11 ms Nach letzter Abfrage: 1.87 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 7.581 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.25 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.581 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.26 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 7.609 MB Zeilen zurückgegeben: 0
SELECT *
FROM adqlu_jmap_metainfo
WHERE `linkurl` = 'https://staging.zkw-otterbein.de/kundenmeinungen'
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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 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.00 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.02 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 |
8 × 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 `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 COUNT(*)
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_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
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_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
1 × SELECT a.name, a.rules
FROM adqlu_assets AS a
1 × SELECT element
FROM adqlu_extensions
1 × SELECT a.id, a.name, a.rules
FROM adqlu_assets AS a
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,COUNT(i.`id`) AS numitems
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 a.id, a.parent_id
FROM adqlu_assets AS a
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