W. I. N.
F I S
Nav view search
Navigation
Cookies erleichtern die Bereitstellung unserer Dienste. Mit der Nutzung unserer Dienste erklären Sie sich damit einverstanden, dass wir Cookies verwenden.
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1566367156,
"last": 1566367156,
"now": 1566367156
},
"client": {
"forwarded": "34.236.38.146"
},
"token": "QOpyu2Vmny5aNde9Okwaq59LR07OUuLX"
},
"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: 32.49 ms / 32.49 ms Speicher: 0.341 MB / 0.71 MB Application: afterLoad
Zeit: 101.28 ms / 133.76 ms Speicher: 1.077 MB / 1.79 MB Application: afterInitialise
Zeit: 31.44 ms / 165.20 ms Speicher: 0.429 MB / 2.22 MB Application: afterRoute
Zeit: 6.48 ms / 171.68 ms Speicher: 0.024 MB / 2.24 MB Application: beforeRenderComponent com_content
Zeit: 6.45 ms / 178.13 ms Speicher: 0.046 MB / 2.29 MB Application: Before Access::preloadComponents (all components)
Zeit: 2.97 ms / 181.10 ms Speicher: 0.043 MB / 2.33 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 181.12 ms Speicher: 0.000 MB / 2.33 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 1.86 ms / 182.99 ms Speicher: 0.115 MB / 2.45 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.02 ms / 183.01 ms Speicher: 0.000 MB / 2.44 MB Application: Before Access::getAssetRules (id:221 name:com_content.article.104)
Zeit: 0.73 ms / 183.74 ms Speicher: 0.007 MB / 2.45 MB Application: After Access::getAssetRules (id:221 name:com_content.article.104)
Zeit: 27.16 ms / 210.90 ms Speicher: 0.219 MB / 2.67 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Zeit: 0.04 ms / 210.94 ms Speicher: 0.005 MB / 2.67 MB Application: After Access::getAssetRules (id:1 name:root.1)
Zeit: 19.03 ms / 229.98 ms Speicher: 0.125 MB / 2.79 MB Application: afterRenderComponent com_content
Zeit: 4.34 ms / 234.31 ms Speicher: 0.024 MB / 2.82 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.04 ms / 234.36 ms Speicher: 0.005 MB / 2.82 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 2.99 ms / 237.35 ms Speicher: 0.009 MB / 2.83 MB Application: afterDispatch
Zeit: 7.65 ms / 244.99 ms Speicher: 0.052 MB / 2.89 MB Application: beforeRenderModule mod_menu (Bottom Menu Deutsch)
Zeit: 3.68 ms / 248.68 ms Speicher: 0.018 MB / 2.90 MB Application: afterRenderModule mod_menu (Bottom Menu Deutsch)
Zeit: 0.04 ms / 248.72 ms Speicher: 0.004 MB / 2.91 MB Application: beforeRenderModule mod_maximenuck (DropDownMenu Deutsch)
Zeit: 6.62 ms / 255.34 ms Speicher: 0.217 MB / 3.13 MB Application: afterRenderModule mod_maximenuck (DropDownMenu Deutsch)
Zeit: 0.06 ms / 255.40 ms Speicher: 0.000 MB / 3.11 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 2.49 ms / 257.89 ms Speicher: 0.009 MB / 3.12 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.04 ms / 257.93 ms Speicher: 0.000 MB / 3.12 MB Application: beforeRenderModule mod_search (Search)
Zeit: 2.35 ms / 260.28 ms Speicher: 0.012 MB / 3.13 MB Application: afterRenderModule mod_search (Search)
Zeit: 0.02 ms / 260.31 ms Speicher: 0.000 MB / 3.12 MB Application: beforeRenderModule mod_languages (Sprechauswahl)
Zeit: 3.73 ms / 264.03 ms Speicher: 0.014 MB / 3.14 MB Application: afterRenderModule mod_languages (Sprechauswahl)
Zeit: 0.04 ms / 264.08 ms Speicher: 0.000 MB / 3.14 MB Application: beforeRenderModule mod_menu (Top Menu Deutsch)
Zeit: 1.05 ms / 265.13 ms Speicher: 0.033 MB / 3.17 MB Application: afterRenderModule mod_menu (Top Menu Deutsch)
Zeit: 0.02 ms / 265.15 ms Speicher: 0.000 MB / 3.17 MB Application: beforeRenderModule mod_menu (Top Menu English)
Zeit: 0.12 ms / 265.28 ms Speicher: 0.003 MB / 3.17 MB Application: afterRenderModule mod_menu (Top Menu English)
Zeit: 0.02 ms / 265.30 ms Speicher: 0.000 MB / 3.17 MB Application: beforeRenderModule mod_menu (Top Menu French)
Zeit: 0.12 ms / 265.42 ms Speicher: 0.003 MB / 3.17 MB Application: afterRenderModule mod_menu (Top Menu French)
Zeit: 4.49 ms / 269.91 ms Speicher: 0.056 MB / 3.23 MB Application: afterRender
Datenbankabfragen gesamt: 53.03 ms
3,50 MB (3.666.000 Bytes)
31 ausgeführte Abfragen 53.03 ms
- Abfragezeit: 1.19 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.969 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jom_session`
WHERE `session_id` = '43efff933c53c86c0d6d7eeb055f31e2'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.10 ms checking permissions 0.02 ms Opening tables 0.49 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 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.01 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.77 ms Nach letzter Abfrage: 1.31 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 0.982 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jom_session`
WHERE `session_id` = '43efff933c53c86c0d6d7eeb055f31e2'
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.09 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 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.01 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: 2.48 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.986 MB
INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('43efff933c53c86c0d6d7eeb055f31e2', 1, 1566367156, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('43efff933c53c86c0d6d7eeb055f31e2', 1, 1566367156, 0, '', 0)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 update 0.15 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 1.76 ms closing tables 0.03 ms freeing items 0.07 ms cleaning up 0.01 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.82 ms Nach letzter Abfrage: 3.62 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.015 MB Zeilen zurückgegeben: 38
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 38 100.00 Using index condition; Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.45 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.04 ms executing 0.01 ms Sending data 0.49 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.12 ms cleaning up 0.01 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: 1.11 ms Nach letzter Abfrage: 2.87 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.037 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.06 ms checking permissions 0.01 ms Opening tables 0.47 ms init 0.03 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.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.01 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: 1.10 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.046 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.35 ms init 0.04 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.02 ms freeing items 0.09 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.77 ms Nach letzter Abfrage: 0.82 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 1.067 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 110 100.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 1.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 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.92 ms Nach letzter Abfrage: 0.86 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.27 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.03 ms Creating sort index 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 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: 1.23 ms Nach letzter Abfrage: 17.22 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.448 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.11 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.05 ms System lock 0.02 ms optimizing 0.08 ms statistics 0.13 ms preparing 0.04 ms executing 0.04 ms Sending data 0.27 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.01 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: 3.02 ms Nach letzter Abfrage: 14.13 ms Abfragespeichernutzung: 0.071 MB Speichernutzung vor Abfrage: 1.614 MB Zeilen zurückgegeben: 42
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.18 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.57 ms init 0.11 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.04 ms Creating sort index 1.15 ms end 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 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:64 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: 1.03 ms Nach letzter Abfrage: 6.64 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.757 MB Zeilen zurückgegeben: 55
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 55 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.30 ms init 0.03 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.10 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.01 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: 1.07 ms Nach letzter Abfrage: 3.51 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.776 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.08 ms checking permissions 0.02 ms Opening tables 0.27 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 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.01 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.86 ms Nach letzter Abfrage: 32.53 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.201 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.10 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.03 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.07 ms cleaning up 0.01 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:324 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: 2.41 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.192 MB
UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"b7b4e8c84d9f8fe39e6c89f42ec58739\"}'
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.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.27 ms updating 0.17 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 1.46 ms closing tables 0.05 ms freeing items 0.11 ms cleaning up 0.01 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:324 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.23 ms Nach letzter Abfrage: 2.32 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.13 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.40 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.05 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.12 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:669 9 plgSystemMobileJoomla->filterExtensions() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:350 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.49 ms Nach letzter Abfrage: 0.04 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.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.78 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.05 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.10 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:688 9 plgSystemMobileJoomla->filterExtensions() JROOT/plugins/system/mobilejoomla/mobilejoomla.php:350 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.58 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.233 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.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.36 ms init 0.05 ms System lock 0.02 ms optimizing 0.07 ms statistics 0.16 ms preparing 0.05 ms executing 0.01 ms Sending data 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.01 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.81 ms Nach letzter Abfrage: 11.24 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.292 MB Zeilen zurückgegeben: 38
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_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 239 16.32 Using where Status Duration starting 0.15 ms checking permissions 0.02 ms Opening tables 0.47 ms init 0.15 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.30 ms preparing 0.02 ms executing 0.01 ms Sending data 1.17 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.09 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: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: 1.63 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.051 MB Speichernutzung vor Abfrage: 2.331 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 239 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.72 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 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.53 ms Nach letzter Abfrage: 1.66 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 2.511 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.06 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.35 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.46 ms checking permissions 0.05 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.05 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.02 ms checking permissions 0.02 ms checking permissions 0.05 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.03 ms Sending data 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.10 ms closing tables 0.01 ms freeing items 0.10 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: 0.89 ms Nach letzter Abfrage: 3.89 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.564 MB Zeilen zurückgegeben: 1
SELECT *
FROM jom_content
WHERE `id` = '104'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jom_content const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 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.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() 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: 2.38 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 2.570 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.02 ms init 0.03 ms System lock 0.07 ms updating 0.11 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 1.68 ms closing tables 0.03 ms freeing items 0.16 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:255 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.57 ms Nach letzter Abfrage: 1.67 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.590 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 <= '2019-08-21 05:59:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-21 05:59:16')
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.28 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.98 ms init 0.16 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.25 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.07 ms freeing items 0.12 ms cleaning up 0.01 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: 1.79 ms Nach letzter Abfrage: 2.20 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.621 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.66 ms init 0.08 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.16 ms preparing 0.04 ms executing 0.01 ms Sending data 0.07 ms end 0.05 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.11 ms cleaning up 0.01 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.67 ms Nach letzter Abfrage: 12.55 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.756 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.26 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.13 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.28 ms preparing 0.06 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.05 ms Creating sort index 0.26 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.12 ms cleaning up 0.01 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:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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: 3.25 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.773 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.23 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.07 ms init 0.13 ms System lock 0.02 ms optimizing 0.06 ms statistics 0.27 ms preparing 0.08 ms Creating tmp table 0.12 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.49 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.02 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:135 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:488 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: 1.17 ms Nach letzter Abfrage: 10.07 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.802 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.12 ms checking permissions 0.02 ms Opening tables 0.04 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.04 ms executing 0.01 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.12 ms cleaning up 0.01 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.34 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.813 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.12 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.53 ms init 0.05 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.12 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.01 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.28 ms Nach letzter Abfrage: 1.21 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.826 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 <= '2019-08-21 05:59:16')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2019-08-21 05:59:16')
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.14 ms init 0.10 ms System lock 0.01 ms optimizing 0.07 ms statistics 0.29 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.01 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.07 ms Nach letzter Abfrage: 2.42 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.870 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 <= '2019-08-21 05:59:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-21 05:59:16')
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.33 ms init 0.11 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.19 ms preparing 0.10 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.50 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.12 ms cleaning up 0.01 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:581 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:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 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.55 ms Nach letzter Abfrage: 9.54 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 3.053 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.09 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.06 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.66 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_maximenuck/helper.php:453 12 modMaximenuckHelper::CreateModulesList() JROOT/modules/mod_maximenuck/helper.php:62 11 modMaximenuckHelper::getItems() JROOT/modules/mod_maximenuck/mod_maximenuck.php:44 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:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 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
29 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jom_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jom_extensions`1 × SELECT `data`
FROM `jom_session`1 × 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 *
FROM jom_content1 × SELECT m.id, m.position
FROM `jom_mj_modules` AS mj
LEFT JOIN `jom_modules` AS m
ON m.id=mj.id1 × 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 `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 ('43efff933c53c86c0d6d7eeb055f31e2', 1, 1566367156, 0, '', 01 × UPDATE `jom_extensions`
SET `params` = '{\"mediaversion\":\"b7b4e8c84d9f8fe39e6c89f42ec58739\"}'1 × SHOW FULL COLUMNS
FROM `jom_content1 × UPDATE jom_content
SET `hits` = (`hits` + 1)