W. I. N.
F I S
Nav view search
Navigation
Wir nutzen Cookies auf unserer Website. Einige von ihnen sind essenziell für den Betrieb der Seite, während andere uns helfen, diese Website und die Nutzererfahrung zu verbessern (Tracking Cookies). Sie können selbst entscheiden, ob Sie die Cookies zulassen möchten. Bitte beachten Sie, dass bei einer Ablehnung womöglich nicht mehr alle Funktionalitäten der Seite zur Verfügung stehen.
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1603207211,
"last": 1603207211,
"now": 1603207211
},
"client": {
"forwarded": "3.210.201.170"
},
"token": "b1FaO1rrUrtsOAZP6UToZf4zQltW6ruB"
},
"registry": {
"mobilejoomla": {
"cache": "bY\/NUsMwDIRfhfEJLnWSKT8j3whX4BEYETuJqV0HS6Ewnb47Mkm5wEnjb73SLkIDR4IbUNZ9+M4p8wx3oB7fHpYn1NWqR8y7eVKGoAJVRr0tph7nwC9n8RWqotSgssPwD6YuO7c\/eMujMn7BzRmPzg8j\/3K5M\/lPFzKyT4XW628fcXB9yhGZlHkSKpGjj46\/JreAa\/FixqgMSt7jiUDSYrR2LUhs24BEaukv4uIluC2taMfpp+vf4ifZJRlmLGQrqG3vE+tmU11cjswTgdZdijHtu4yHsEl50D2+6yuxfgM=",
"markup": ""
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Zeit
Speicher
Zeit: 36.02 ms / 36.02 ms Speicher: 0.341 MB / 0.71 MB Application: afterLoad
Zeit: 117.46 ms / 153.48 ms Speicher: 1.075 MB / 1.79 MB Application: afterInitialise
Zeit: 87.20 ms / 240.67 ms Speicher: 0.432 MB / 2.22 MB Application: afterRoute
Zeit: 2.52 ms / 243.20 ms Speicher: 0.024 MB / 2.24 MB Application: beforeRenderComponent com_content
Zeit: 42.12 ms / 285.31 ms Speicher: 0.046 MB / 2.29 MB Application: Before Access::preloadComponents (all components)
Zeit: 2.66 ms / 287.97 ms Speicher: 0.044 MB / 2.33 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 287.99 ms Speicher: 0.000 MB / 2.33 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 1.09 ms / 289.08 ms Speicher: 0.115 MB / 2.45 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.02 ms / 289.10 ms Speicher: 0.000 MB / 2.44 MB Application: Before Access::getAssetRules (id:221 name:com_content.article.104)
Zeit: 0.65 ms / 289.76 ms Speicher: 0.007 MB / 2.45 MB Application: After Access::getAssetRules (id:221 name:com_content.article.104)
Zeit: 65.96 ms / 355.71 ms Speicher: 0.213 MB / 2.66 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Zeit: 0.05 ms / 355.76 ms Speicher: 0.005 MB / 2.67 MB Application: After Access::getAssetRules (id:1 name:root.1)
Zeit: 51.56 ms / 407.32 ms Speicher: 0.125 MB / 2.79 MB Application: afterRenderComponent com_content
Zeit: 4.46 ms / 411.78 ms Speicher: 0.022 MB / 2.81 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.05 ms / 411.83 ms Speicher: 0.005 MB / 2.82 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 2.83 ms / 414.66 ms Speicher: 0.010 MB / 2.83 MB Application: afterDispatch
Zeit: 7.48 ms / 422.14 ms Speicher: 0.052 MB / 2.88 MB Application: beforeRenderModule mod_menu (Bottom Menu Deutsch)
Zeit: 3.68 ms / 425.82 ms Speicher: 0.018 MB / 2.90 MB Application: afterRenderModule mod_menu (Bottom Menu Deutsch)
Zeit: 0.04 ms / 425.86 ms Speicher: 0.004 MB / 2.90 MB Application: beforeRenderModule mod_maximenuck (DropDownMenu Deutsch)
Zeit: 8.82 ms / 434.68 ms Speicher: 0.231 MB / 3.13 MB Application: afterRenderModule mod_maximenuck (DropDownMenu Deutsch)
Zeit: 0.06 ms / 434.74 ms Speicher: 0.000 MB / 3.12 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 2.32 ms / 437.06 ms Speicher: 0.009 MB / 3.12 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.04 ms / 437.10 ms Speicher: 0.000 MB / 3.12 MB Application: beforeRenderModule mod_search (Search)
Zeit: 2.33 ms / 439.42 ms Speicher: 0.012 MB / 3.13 MB Application: afterRenderModule mod_search (Search)
Zeit: 0.02 ms / 439.45 ms Speicher: 0.000 MB / 3.13 MB Application: beforeRenderModule mod_languages (Sprechauswahl)
Zeit: 11.05 ms / 450.50 ms Speicher: 0.014 MB / 3.15 MB Application: afterRenderModule mod_languages (Sprechauswahl)
Zeit: 0.06 ms / 450.56 ms Speicher: 0.000 MB / 3.15 MB Application: beforeRenderModule mod_menu (Top Menu Deutsch)
Zeit: 1.06 ms / 451.62 ms Speicher: 0.033 MB / 3.18 MB Application: afterRenderModule mod_menu (Top Menu Deutsch)
Zeit: 0.02 ms / 451.64 ms Speicher: 0.000 MB / 3.18 MB Application: beforeRenderModule mod_menu (Top Menu English)
Zeit: 0.12 ms / 451.77 ms Speicher: 0.003 MB / 3.18 MB Application: afterRenderModule mod_menu (Top Menu English)
Zeit: 0.02 ms / 451.79 ms Speicher: 0.000 MB / 3.18 MB Application: beforeRenderModule mod_menu (Top Menu French)
Zeit: 0.12 ms / 451.90 ms Speicher: 0.003 MB / 3.18 MB Application: afterRenderModule mod_menu (Top Menu French)
Zeit: 4.47 ms / 456.38 ms Speicher: 0.054 MB / 3.23 MB Application: afterRender
Datenbankabfragen gesamt: 46.14 ms
3,50 MB (3.669.944 Bytes)
30 ausgeführte Abfragen 46.14 ms
- Abfragezeit: 0.56 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.969 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jom_session`
WHERE `session_id` = X'3133303436373637323837303335323962666365303264366634656464663438'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_session const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Derselbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.46 ms Nach letzter Abfrage: 1.23 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 0.982 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jom_session`
WHERE `session_id` = X'3133303436373637323837303335323962666365303264366634656464663438'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_session const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.82 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.986 MB
INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3133303436373637323837303335323962666365303264366634656464663438', 1, 1603207211, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3133303436373637323837303335323962666365303264366634656464663438', 1, 1603207211, 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.09 ms Waiting for query cache lock 0.02 ms update 0.01 ms end 0.01 ms query end 1.23 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.02 ms Nach letzter Abfrage: 3.78 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.016 MB Zeilen zurückgegeben: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions ref extension extension 82 const 39 100.00 Using index condition; Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Derselbe Aufruf in der Zeile darunter. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.57 ms Nach letzter Abfrage: 20.00 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.038 MB Zeilen zurückgegeben: 4
SELECT id, rules
FROM `jom_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_viewlevels ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 4 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.58 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.047 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM jom_usergroups AS a
LEFT JOIN jom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 10 20.00 Using where; Using index Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.65 ms Nach letzter Abfrage: 0.78 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 1.068 MB Zeilen zurückgegeben: 97
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jom_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions ref extension extension 82 const 112 100.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.88 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Derselbe Aufruf in der Zeile darunter. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 1.168 MB Zeilen zurückgegeben: 3
SELECT *
FROM jom_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_languages ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 4 100.00 Using where; filesort wurde genutzt Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Language/LanguageHelper.php:67 4 Joomla\CMS\Language\LanguageHelper::detectLanguage() JROOT/libraries/src/Application/SiteApplication.php:653 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.73 ms Nach letzter Abfrage: 17.03 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.452 MB Zeilen zurückgegeben: 22
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jom_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions ref extension extension 82 const 22 100.00 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sending data 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.04 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.70 ms Nach letzter Abfrage: 13.76 ms Abfragespeichernutzung: 0.067 MB Speichernutzung vor Abfrage: 1.618 MB Zeilen zurückgegeben: 40
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 jom_menu AS m
LEFT JOIN jom_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.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 54 100.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 1973365-1.m.component_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.76 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Derselbe Aufruf in der Zeile darunter. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.82 ms Nach letzter Abfrage: 6.51 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.755 MB Zeilen zurückgegeben: 56
SELECT `name`,`value`
FROM jom_mj_settingsid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_mj_settings ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 56 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 12 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_mobilejoomla/legacy/joomlawrapper-3.0.php:63 11 MjJoomlaWrapper30->dbSelectAll() JROOT/administrator/components/com_mobilejoomla/models/settings.php:30 10 MjSettingsModel->__construct() JROOT/administrator/components/com_mobilejoomla/classes/mobilejoomla.php:53 9 MobileJoomla->__construct() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:60 8 plgSystemMobileJoomla->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.79 ms Nach letzter Abfrage: 3.56 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.774 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jom_mj_amdd`
WHERE `ua`='CCBot/2.0 (https://commoncrawl.org/faq/)'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/administrator/components/com_mobilejoomla/ress/vendor/amdd/database/joomla/db.joomla.php:33 15 AmddDatabaseJoomla->getDevice() JROOT/administrator/components/com_mobilejoomla/ress/vendor/amdd/amdd.php:99 14 Amdd::getDevice() JROOT/administrator/components/com_mobilejoomla/ress/vendor/amdd/amdd.php:55 13 Amdd::getCapabilities() JROOT/plugins/mobile/amdd/amdd.php:52 12 plgMobileAmdd->onDeviceDetection() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:96 8 plgSystemMobileJoomla->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.74 ms Nach letzter Abfrage: 95.07 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.202 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:336 8 plgSystemMobileJoomla->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.88 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.193 MB
UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"6fdb9696dcf7d769e560cb5a6bf09f3c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.07 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.05 ms query end 1.20 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:336 8 plgSystemMobileJoomla->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.41 ms Nach letzter Abfrage: 2.24 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.214 MB Zeilen zurückgegeben: 0
SELECT p.folder AS `type`, p.element AS `name`
FROM `jom_mj_plugins` AS mj
LEFT JOIN `jom_extensions` AS p
ON p.extension_id=mj.id
WHERE mj.device='desktop'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.81 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:686 9 plgSystemMobileJoomla->filterExtensions() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:362 8 plgSystemMobileJoomla->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.61 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.218 MB Zeilen zurückgegeben: 0
SELECT m.id, m.position
FROM `jom_mj_modules` AS mj
LEFT JOIN `jom_modules` AS m
ON m.id=mj.id
WHERE mj.device='desktop'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.09 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:705 9 plgSystemMobileJoomla->filterExtensions() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:362 8 plgSystemMobileJoomla->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.234 MB Zeilen zurückgegeben: 10
SELECT id, home, template, s.params
FROM jom_template_styles as s
LEFT JOIN jom_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 = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 13 76.92 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 1973365-1.s.template,const 1 100.00 Using index condition; Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.18 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.46 ms Nach letzter Abfrage: 43.59 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.293 MB Zeilen zurückgegeben: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_fields','com_finder','com_formmaker','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_mobilejoomla','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_assets ALL idx_asset_name ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 240 16.67 Using where Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 1.11 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.01 ms executing 0.01 ms Sending data 0.46 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.051 MB Speichernutzung vor Abfrage: 2.332 MB Zeilen zurückgegeben: 144
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_assets ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 240 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.33 ms Nach letzter Abfrage: 3.88 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 2.513 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `jom_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jom_content`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 1.21 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.04 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.17 ms Nach letzter Abfrage: 3.71 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 2.565 MB
UPDATE jom_content
SET `hits` = (`hits` + 1)
WHERE `id` = '104'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_content range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.04 ms updating 0.08 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 1.44 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 4.04 ms Nach letzter Abfrage: 11.85 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.585 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jom_content AS a
INNER JOIN jom_categories AS c
on c.id = a.catid
LEFT JOIN jom_users AS u
on u.id = a.created_by
LEFT JOIN jom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jom_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 104
AND c.published > 0
AND a.language in ('de-DE','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-20 15:20:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-20 15:20:11')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.93 ms init 0.11 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.03 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.49 ms Nach letzter Abfrage: 10.59 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.616 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jom_contentitem_tag_map` AS m
INNER JOIN `jom_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 104
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 1973365-1.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.66 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.40 ms Nach letzter Abfrage: 35.28 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.751 MB Zeilen zurückgegeben: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jom_categories` AS `s`
INNER JOIN `jom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('de-DE','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 79
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 5 100.00 Using index condition; Using where Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.19 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.04 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 4.14 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.768 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jom_fields AS a
LEFT JOIN `jom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jom_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (79,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 1973365-1.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 1973365-1.a.checked_out 1 100.00 NULL 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 1973365-1.a.access 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 1973365-1.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 1973365-1.a.group_id 1 100.00 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 1973365-1.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.18 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.25 ms init 0.10 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.25 ms preparing 0.06 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.32 ms Creating sort index 0.05 ms end 0.01 ms removing tmp table 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.09 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.99 ms Nach letzter Abfrage: 36.55 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.796 MB Zeilen zurückgegeben: 5
SELECT language,id
FROM `jom_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 55 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sending data 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.61 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.806 MB Zeilen zurückgegeben: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `jom_menu` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 546id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.85 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.11 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.19 ms Nach letzter Abfrage: 1.26 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.819 MB Zeilen zurückgegeben: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jom_content` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 104
AND c2.access IN (1,1)
AND c2.language != 'de-DE'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2020-10-20 15:20:11')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2020-10-20 15:20:11')
AND c2.state = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.15 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.10 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.23 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.24 ms Nach letzter Abfrage: 2.27 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.863 MB Zeilen zurückgegeben: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom_modules AS m
LEFT JOIN jom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom_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 <= '2020-10-20 15:20:11')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 15:20:11')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 546 OR mm.menuid <= 0)
AND m.language IN ('de-DE','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 51 100.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE mm ref PRIMARY PRIMARY 4 1973365-1.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 1973365-1.m.module,const 1 100.00 Using index condition; Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.84 ms init 0.09 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.15 ms preparing 0.06 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.34 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/tourism_and_services/index.php:15 7 require JROOT/templates/tourism_and_services/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.29 ms Nach letzter Abfrage: 11.76 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 3.121 MB Zeilen zurückgegeben: 61
SELECT *
FROM jom_modules
WHERE published=1
ORDER BY id ;id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_modules index published PRIMARY 4 NULL 71 85.92 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.38 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/modules/mod_maximenuck/helper.php:445 13 modMaximenuckHelper::CreateModulesList() JROOT/modules/mod_maximenuck/helper.php:62 12 modMaximenuckHelper::getItems() JROOT/modules/mod_maximenuck/legacy.php:44 11 require JROOT/modules/mod_maximenuck/legacy.php JROOT/modules/mod_maximenuck/mod_maximenuck.php:700 10 include JROOT/modules/mod_maximenuck/mod_maximenuck.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
28 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`1 × SELECT `data`
FROM `jom_session`1 × SELECT id, home, template, s.params
FROM jom_template_styles as s
LEFT JOIN jom_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jom_modules AS m
LEFT JOIN jom_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jom_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jom_content` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jom_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT `c2`.`language`,`c2`.`id`
FROM `jom_menu` AS `c`
INNER JOIN `jom_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jom_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jom_menu` AS `c2`
ON a2.id = c2.`id`1 × SELECT language,id
FROM `jom_menu`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jom_fields AS a
LEFT JOIN `jom_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jom_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jom_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jom_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jom_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jom_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jom_categories` AS `s`
INNER JOIN `jom_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('de-DE','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `jom_contentitem_tag_map` AS m
INNER JOIN `jom_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jom_content AS a
INNER JOIN jom_categories AS c
on c.id = a.catid
LEFT JOIN jom_users AS u
on u.id = a.created_by
LEFT JOIN jom_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jom_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.position
FROM `jom_mj_modules` AS mj
LEFT JOIN `jom_modules` AS m
ON m.id=mj.id1 × SELECT `session_id`
FROM `jom_session`1 × SELECT p.folder AS `type`, p.element AS `name`
FROM `jom_mj_plugins` AS mj
LEFT JOIN `jom_extensions` AS p
ON p.extension_id=mj.id1 × SELECT `data`
FROM `jom_mj_amdd`1 × SELECT `name`,`value`
FROM jom_mj_setting1 × 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 jom_menu AS m
LEFT JOIN jom_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jom_extensions`1 × SELECT *
FROM jom_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jom_extensions1 × SELECT b.id
FROM jom_usergroups AS a
LEFT JOIN jom_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jom_viewlevels1 × SELECT *
FROM jom_modules
Andere Tabellen:
1 × INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3133303436373637323837303335323962666365303264366634656464663438', 1, 1603207211, 0, '', 01 × UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"6fdb9696dcf7d769e560cb5a6bf09f3c\"}'1 × SHOW FULL COLUMNS
FROM `jom_content1 × UPDATE jom_content
SET `hits` = (`hits` + 1)