W. I. N.
F I S
Nav view search
Navigation
Search |
||
|
|
||
| © TOURISM AND SERVICES 2022 |
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": 1653128145,
"last": 1653128145,
"now": 1653128145
},
"client": {
"forwarded": "3.236.234.223"
},
"token": "DcINux9Pwy7D4seddGrdJWv67hW18ykZ"
},
"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: 50.81 ms / 50.81 ms Speicher: 1.700 MB / 2.05 MB Application: afterLoad
Zeit: 103.94 ms / 154.74 ms Speicher: 4.447 MB / 6.50 MB Application: afterInitialise
Zeit: 29.09 ms / 183.83 ms Speicher: 1.269 MB / 7.77 MB Application: afterRoute
Zeit: 3.12 ms / 186.95 ms Speicher: 0.032 MB / 7.80 MB Application: beforeRenderComponent com_content
Zeit: 7.57 ms / 194.51 ms Speicher: 0.429 MB / 8.23 MB Application: Before Access::preloadComponents (all components)
Zeit: 4.06 ms / 198.57 ms Speicher: 0.056 MB / 8.29 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 198.59 ms Speicher: -0.003 MB / 8.28 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 1.85 ms / 200.44 ms Speicher: 0.152 MB / 8.43 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.02 ms / 200.46 ms Speicher: -0.011 MB / 8.42 MB Application: Before Access::getAssetRules (id:221 name:com_content.article.104)
Zeit: 0.70 ms / 201.16 ms Speicher: 0.025 MB / 8.45 MB Application: After Access::getAssetRules (id:221 name:com_content.article.104)
Zeit: 62.92 ms / 264.08 ms Speicher: 3.530 MB / 11.98 MB Application: afterRenderComponent com_content
Zeit: 4.55 ms / 268.64 ms Speicher: 0.090 MB / 12.07 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.04 ms / 268.68 ms Speicher: 0.007 MB / 12.08 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 3.38 ms / 272.06 ms Speicher: 0.157 MB / 12.23 MB Application: afterDispatch
Zeit: 7.90 ms / 279.96 ms Speicher: 0.163 MB / 12.40 MB Application: beforeRenderModule mod_menu (Bottom Menu Deutsch)
Zeit: 3.75 ms / 283.71 ms Speicher: 0.082 MB / 12.48 MB Application: afterRenderModule mod_menu (Bottom Menu Deutsch)
Zeit: 0.06 ms / 283.77 ms Speicher: 0.008 MB / 12.49 MB Application: beforeRenderModule mod_maximenuck (DropDownMenu Deutsch)
Zeit: 16.21 ms / 299.98 ms Speicher: 1.335 MB / 13.82 MB Application: afterRenderModule mod_maximenuck (DropDownMenu Deutsch)
Zeit: 0.08 ms / 300.05 ms Speicher: -0.029 MB / 13.79 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 3.12 ms / 303.17 ms Speicher: 0.022 MB / 13.81 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.04 ms / 303.21 ms Speicher: -0.003 MB / 13.81 MB Application: beforeRenderModule mod_search (Search)
Zeit: 2.09 ms / 305.30 ms Speicher: 0.015 MB / 13.83 MB Application: afterRenderModule mod_search (Search)
Zeit: 0.02 ms / 305.32 ms Speicher: -0.003 MB / 13.82 MB Application: beforeRenderModule mod_languages (Sprechauswahl)
Zeit: 3.77 ms / 309.09 ms Speicher: 0.031 MB / 13.85 MB Application: afterRenderModule mod_languages (Sprechauswahl)
Zeit: 0.04 ms / 309.14 ms Speicher: -0.000 MB / 13.85 MB Application: beforeRenderModule mod_menu (Top Menu Deutsch)
Zeit: 1.27 ms / 310.41 ms Speicher: 0.037 MB / 13.89 MB Application: afterRenderModule mod_menu (Top Menu Deutsch)
Zeit: 0.02 ms / 310.43 ms Speicher: -0.004 MB / 13.89 MB Application: beforeRenderModule mod_menu (Top Menu English)
Zeit: 0.15 ms / 310.58 ms Speicher: 0.004 MB / 13.89 MB Application: afterRenderModule mod_menu (Top Menu English)
Zeit: 0.02 ms / 310.60 ms Speicher: -0.002 MB / 13.89 MB Application: beforeRenderModule mod_menu (Top Menu French)
Zeit: 0.14 ms / 310.74 ms Speicher: 0.004 MB / 13.89 MB Application: afterRenderModule mod_menu (Top Menu French)
Zeit: 3.59 ms / 314.33 ms Speicher: 0.091 MB / 13.98 MB Application: afterRender
Datenbankabfragen gesamt: 54.37 ms
14,39 MB (15.084.880 Bytes)
30 ausgeführte Abfragen 54.37 ms
- Abfragezeit: 1.11 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.560 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jom_session`
WHERE `session_id` = X'3234323930363065376130363230353135313233316530663562323333356534'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.07 ms checking permissions 0.01 ms Opening tables 0.40 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.67 ms Nach letzter Abfrage: 1.65 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 3.649 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jom_session`
WHERE `session_id` = X'3234323930363065376130363230353135313233316530663562323333356534'
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.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 2.33 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.654 MB
INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3234323930363065376130363230353135313233316530663562323333356534', 1, 1653128145, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3234323930363065376130363230353135313233316530663562323333356534', 1, 1653128145, 0, '', 0)Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.13 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 1.56 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.03 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.66 ms Nach letzter Abfrage: 3.53 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.826 MB Zeilen zurückgegeben: 40
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 40 100.00 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.42 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms executing 0.01 ms Sending data 0.39 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.13 ms cleaning up 0.03 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.09 ms Nach letzter Abfrage: 3.28 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.064 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.05 ms checking permissions 0.01 ms Opening tables 0.34 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 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.08 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.29 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.076 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.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 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.01 ms freeing items 0.09 ms cleaning up 0.03 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.29 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.141 MB Zeilen zurückgegeben: 103
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 120 100.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.31 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.17 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/Plugin/PluginHelper.php:351 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:356 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.53 ms Nach letzter Abfrage: 1.06 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.255 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.07 ms checking permissions 0.02 ms Opening tables 0.38 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.17 ms Nach letzter Abfrage: 19.96 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.899 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.08 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 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.26 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.03 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:280 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:667 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.05 ms Nach letzter Abfrage: 14.21 ms Abfragespeichernutzung: 0.069 MB Speichernutzung vor Abfrage: 5.644 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 56 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.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.47 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 1.45 ms end 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.04 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:78 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:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 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:533 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:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.01 ms Nach letzter Abfrage: 7.17 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.168 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.06 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 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:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.98 ms Nach letzter Abfrage: 3.44 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.402 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.07 ms checking permissions 0.02 ms Opening tables 0.24 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.10 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:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.07 ms Nach letzter Abfrage: 22.06 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 7.416 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.12 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.03 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.08 ms cleaning up 0.03 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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.53 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 7.409 MB
UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"92e948f05f87f32177a2d28d90f40b9f\"}'
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.08 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.12 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 1.70 ms closing tables 0.04 ms freeing items 0.07 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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.02 ms Nach letzter Abfrage: 3.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.762 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.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.06 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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.42 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.767 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.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.68 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.04 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 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:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.82 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 7.789 MB Zeilen zurückgegeben: 11
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 15 80.00 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.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.45 ms init 0.07 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.20 ms preparing 0.05 ms executing 0.01 ms Sending data 0.30 ms end 0.01 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 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.92 ms Nach letzter Abfrage: 8.74 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 8.233 MB Zeilen zurückgegeben: 40
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_jce','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 243 16.87 Using where Status Duration starting 0.18 ms checking permissions 0.02 ms Opening tables 0.45 ms init 0.23 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.50 ms preparing 0.04 ms executing 0.01 ms Sending data 1.84 ms end 0.02 ms query end 0.04 ms closing tables 0.02 ms freeing items 0.08 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:457 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.68 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.054 MB Speichernutzung vor Abfrage: 8.283 MB Zeilen zurückgegeben: 146
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 243 100.00 Using where Status Duration starting 0.08 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.02 ms executing 0.01 ms Sending data 0.73 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.08 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: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:457 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.68 ms Nach letzter Abfrage: 1.68 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 8.487 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.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.60 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.11 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.02 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:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 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:328 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.95 ms Nach letzter Abfrage: 4.30 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.705 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.06 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.07 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 2.11 ms closing tables 0.04 ms freeing items 0.09 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 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:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.32 ms Nach letzter Abfrage: 2.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.827 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 <= '2022-05-21 10:15:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-21 10:15:45')
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.27 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 0.93 ms init 0.16 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.20 ms preparing 0.03 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.63 ms Nach letzter Abfrage: 2.65 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.001 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.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.63 ms init 0.07 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.04 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.88 ms Nach letzter Abfrage: 23.64 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 11.240 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.32 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.16 ms System lock 0.02 ms optimizing 0.06 ms statistics 0.26 ms preparing 0.06 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.05 ms Creating sort index 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.03 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:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.22 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.282 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)
AND a.language in ('*','de-DE')
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_language,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.24 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 Opening tables 1.01 ms init 0.14 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.28 ms preparing 0.09 ms Creating tmp table 0.11 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.47 ms Creating sort index 0.06 ms end 0.01 ms removing tmp table 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.11 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:322 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:194 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.04 ms Nach letzter Abfrage: 14.71 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.984 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 57 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 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.29 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 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.30 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.046 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.11 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.52 ms init 0.05 ms System lock 0.01 ms optimizing 0.04 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.09 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.40 ms Nach letzter Abfrage: 1.22 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.078 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 <= '2022-05-21 10:15:45')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2022-05-21 10:15:45')
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.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 0.18 ms init 0.14 ms System lock 0.02 ms optimizing 0.08 ms statistics 0.30 ms executing 0.02 ms end 0.01 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 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.18 ms Nach letzter Abfrage: 3.17 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.368 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 <= '2022-05-21 10:15:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-21 10:15:45')
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.16 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.31 ms init 0.10 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.26 ms preparing 0.08 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.64 ms end 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.11 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:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 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:601 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:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.14 ms Nach letzter Abfrage: 17.20 ms Abfragespeichernutzung: 0.059 MB Speichernutzung vor Abfrage: 13.420 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.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.38 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 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:746 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 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'3234323930363065376130363230353135313233316530663562323333356534', 1, 1653128145, 0, '', 01 × UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"92e948f05f87f32177a2d28d90f40b9f\"}'1 × SHOW FULL COLUMNS
FROM `jom_content1 × UPDATE jom_content
SET `hits` = (`hits` + 1)