Joomla!-Debug-Konsole
{ "__default": { "session": { "counter": 1, "timer": { "start": 1680377521, "last": 1680377521, "now": 1680377521 }, "token": "au6IAdNu7srrU3UAGpn0GW38ITBqqt5Y" }, "registry": { "com_jfbconnect": { "authentication": { "started": { "azure": false, "instagram": false, "yahoo": false } } } }, "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 }, "com_mailto": { "links": { "5457c559594a526392c22c8b572f5a9ff3dcc66b": { "link": "https://tsv-oberschneiding.de/fussball/senioren/ii-mannschaft", "expiry": 1680377521 } } } } }
Zeit
Speicher
Zeit: 10.79 ms / 10.79 ms Speicher: 1.831 MB / 2.22 MB Application: afterLoad
Zeit: 36.48 ms / 47.26 ms Speicher: 6.206 MB / 8.43 MB Application: afterInitialise
Zeit: 6.76 ms / 54.02 ms Speicher: 1.042 MB / 9.47 MB Application: afterRoute
Zeit: 2.29 ms / 56.32 ms Speicher: 0.237 MB / 9.71 MB Application: beforeRenderComponent com_content
Zeit: 1.24 ms / 57.56 ms Speicher: 0.248 MB / 9.96 MB Application: Before Access::preloadComponents (all components)
Zeit: 0.50 ms / 58.06 ms Speicher: 0.059 MB / 10.01 MB Application: After Access::preloadComponents (all components)
Zeit: 0.01 ms / 58.07 ms Speicher: -0.004 MB / 10.01 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 0.45 ms / 58.53 ms Speicher: 0.171 MB / 10.18 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.01 ms / 58.54 ms Speicher: -0.011 MB / 10.17 MB Application: Before Access::getAssetRules (id:77 name:com_content.article.9)
Zeit: 0.25 ms / 58.79 ms Speicher: 0.027 MB / 10.20 MB Application: After Access::getAssetRules (id:77 name:com_content.article.9)
Zeit: 18.68 ms / 77.48 ms Speicher: 2.893 MB / 13.09 MB Application: afterRenderComponent com_content
Zeit: 0.90 ms / 78.38 ms Speicher: 0.112 MB / 13.20 MB Application: afterDispatch
Zeit: 1.99 ms / 80.37 ms Speicher: 0.162 MB / 13.37 MB Application: Before Access::getAssetRules (id:251 name:com_jfbconnect)
Zeit: 0.02 ms / 80.39 ms Speicher: 0.007 MB / 13.37 MB Application: After Access::getAssetRules (id:251 name:com_jfbconnect)
Zeit: 0.29 ms / 80.68 ms Speicher: 0.024 MB / 13.40 MB Application: beforeRenderModule mod_login (Login Form)
Zeit: 1.54 ms / 82.22 ms Speicher: 0.155 MB / 13.55 MB Application: afterRenderModule mod_login (Login Form)
Zeit: 0.02 ms / 82.24 ms Speicher: 0.002 MB / 13.55 MB Application: beforeRenderModule mod_sclogin (Facebook Login)
Zeit: 3.56 ms / 85.80 ms Speicher: 0.871 MB / 14.43 MB Application: afterRenderModule mod_sclogin (Facebook Login)
Zeit: 0.03 ms / 85.83 ms Speicher: -0.007 MB / 14.42 MB Application: beforeRenderModule mod_menu (DSGVO)
Zeit: 1.04 ms / 86.86 ms Speicher: 0.082 MB / 14.50 MB Application: afterRenderModule mod_menu (DSGVO)
Zeit: 0.03 ms / 86.89 ms Speicher: -0.002 MB / 14.50 MB Application: beforeRenderModule mod_dpcalendar_upcoming (Nächste Termine)
Zeit: 5.41 ms / 92.30 ms Speicher: 1.131 MB / 15.63 MB Application: Before Access::preloadPermissions (com_dpcalendar)
Zeit: 0.37 ms / 92.67 ms Speicher: 0.013 MB / 15.64 MB Application: After Access::preloadPermissions (com_dpcalendar)
Zeit: 0.01 ms / 92.68 ms Speicher: 0.000 MB / 15.64 MB Application: Before Access::getAssetRules (id:102 name:com_dpcalendar.category.22)
Zeit: 0.05 ms / 92.73 ms Speicher: 0.007 MB / 15.65 MB Application: After Access::getAssetRules (id:102 name:com_dpcalendar.category.22)
Zeit: 3.09 ms / 95.82 ms Speicher: 0.273 MB / 15.92 MB Application: Before Access::getAssetRules (id:86 name:com_dpcalendar)
Zeit: 0.02 ms / 95.85 ms Speicher: 0.007 MB / 15.93 MB Application: After Access::getAssetRules (id:86 name:com_dpcalendar)
Zeit: 6.46 ms / 102.31 ms Speicher: 0.323 MB / 16.25 MB Application: afterRenderModule mod_dpcalendar_upcoming (Nächste Termine)
Zeit: 0.03 ms / 102.33 ms Speicher: -0.072 MB / 16.18 MB Application: beforeRenderModule mod_custom (Nächste Spiele)
Zeit: 0.27 ms / 102.60 ms Speicher: 0.006 MB / 16.19 MB Application: afterRenderModule mod_custom (Nächste Spiele)
Zeit: 0.01 ms / 102.62 ms Speicher: 0.005 MB / 16.19 MB Application: beforeRenderModule mod_custom (Partner Sponsoring)
Zeit: 0.10 ms / 102.72 ms Speicher: 0.003 MB / 16.20 MB Application: afterRenderModule mod_custom (Partner Sponsoring)
Zeit: 0.03 ms / 102.75 ms Speicher: 0.000 MB / 16.20 MB Application: beforeRenderModule mod_menu (Mainmenu)
Zeit: 2.46 ms / 105.21 ms Speicher: 0.181 MB / 16.38 MB Application: afterRenderModule mod_menu (Mainmenu)
Zeit: 2.95 ms / 108.16 ms Speicher: 0.385 MB / 16.76 MB Application: afterRender
Datenbankabfragen gesamt: 10.78 ms
17,26 MB (18.094.712 Bytes)
33 ausgeführte Abfragen 10.78 ms
- Abfragezeit: 0.13 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.992 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `zhmfp_session`
WHERE `session_id` = X'3166313464323438363439316264656533373933303365653835613565306262'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.00 ms Reset for next command 0.00 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() Der selbe 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.07 ms Nach letzter Abfrage: 0.76 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.088 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `zhmfp_session`
WHERE `session_id` = X'3166313464323438363439316264656533373933303365653835613565306262'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.00 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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: 0.24 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.093 MB
INSERT INTO `zhmfp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3166313464323438363439316264656533373933303365653835613565306262', 1, 1680377521, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `zhmfp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3166313464323438363439316264656533373933303365653835613565306262', 1, 1680377521, 0, '', 0)Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.01 ms Update 0.03 ms Waiting for query cache lock 0.00 ms Update 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.03 ms Writing to binlog 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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: 0.31 ms Nach letzter Abfrage: 1.30 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 4.281 MB Zeilen zurückgegeben: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zhmfp_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_extensions ref extension extension 82 const 41 Using index condition; Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.11 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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}() Der selbe 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: 0.15 ms Nach letzter Abfrage: 1.23 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.545 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `zhmfp_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_viewlevels ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.00 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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: 0.19 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.557 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM zhmfp_usergroups AS a
LEFT JOIN zhmfp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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: 0.45 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.624 MB Zeilen zurückgegeben: 99
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM zhmfp_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_extensions ALL extension ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 252 Using where; filesort wurde genutzt Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.00 ms Creating sort index 0.25 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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}() Der selbe 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: 0.21 ms Nach letzter Abfrage: 8.84 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 6.570 MB Zeilen zurückgegeben: 155
SELECT setting,value
FROM zhmfp_jfbconnect_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_jfbconnect_config ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 155 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.08 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.00 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jfbconnect/models/config.php:316 14 JFBConnectModelConfig->getSettings() JROOT/administrator/components/com_jfbconnect/models/config.php:354 13 JFBConnectModelConfig->get() JROOT/administrator/components/com_jfbconnect/models/config.php:401 12 JFBConnectModelConfig->getSetting() JROOT/components/com_jfbconnect/libraries/provider.php:36 11 JFBConnectProvider->__construct() JROOT/components/com_jfbconnect/libraries/provider/amazon.php:21 10 JFBConnectProviderAmazon->__construct() JROOT/components/com_jfbconnect/libraries/factory.php:58 9 JFBCFactory::provider() JROOT/components/com_jfbconnect/libraries/factory.php:92 8 JFBCFactory::getAllProviders() JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40 7 plgSystemJFBCSystem->__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: 0.56 ms Nach letzter Abfrage: 13.90 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 8.678 MB Zeilen zurückgegeben: 37
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 zhmfp_menu AS m
LEFT JOIN zhmfp_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 Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language,published,parent_id idx_client_id_parent_id_alias_language 1 const 52 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 d02d7f9b.m.component_id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.22 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.02 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Der selbe 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/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 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: 0.25 ms Nach letzter Abfrage: 4.77 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.453 MB Zeilen zurückgegeben: 1
SELECT id, home, template, s.params
FROM zhmfp_template_styles as s
LEFT JOIN zhmfp_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 Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 1 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 d02d7f9b.s.template,const 1 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/gantry5/gantry5.php:257 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:108 8 plgSystemGantry5->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: 0.20 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.505 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zhmfp_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Der selbe Aufruf in der Zeile darunter. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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: 0.22 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 9.495 MB
UPDATE `zhmfp_extensions`
SET `params` = '{\"mediaversion\":\"6f19a567b092722abe19328b33d87ae1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `zhmfp_extensions` SET `params` = '{\"mediaversion\":\"6f19a567b092722abe19328b33d87ae1\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.03 ms Updating 0.03 ms End of update loop 0.00 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.03 ms Writing to binlog 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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: 0.20 ms Nach letzter Abfrage: 1.04 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 9.677 MB Zeilen zurückgegeben: 2
SELECT *
FROM zhmfp_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_languages ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 Using where; filesort wurde genutzt Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 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: 0.39 ms Nach letzter Abfrage: 1.65 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.960 MB Zeilen zurückgegeben: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `zhmfp_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_jfbconnect','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osgcourts','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 Extra 1 SIMPLE zhmfp_assets range idx_asset_name idx_asset_name 202 NULL 42 Using index condition Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.15 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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: 0.27 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 10.011 MB Zeilen zurückgegeben: 162
SELECT `id`,`name`,`rules`,`parent_id`
FROM `zhmfp_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 Extra 1 SIMPLE zhmfp_assets ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 263 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.12 ms End of update loop 0.00 ms Query end 0.02 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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: 0.40 ms Nach letzter Abfrage: 0.74 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.239 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `zhmfp_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `zhmfp_content`Status Duration Starting 0.01 ms checking permissions 0.00 ms closing tables 0.00 ms Opening tables 0.12 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms Optimizing 0.00 ms Statistics 0.00 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.06 ms closing tables 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.04 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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: 0.27 ms Nach letzter Abfrage: 1.53 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 10.489 MB
UPDATE zhmfp_content
SET `hits` = (`hits` + 1)
WHERE `id` = '9'„EXPLAIN“ unmöglich für Abfrage: UPDATE zhmfp_content SET `hits` = (`hits` + 1) WHERE `id` = '9'Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.04 ms Updating 0.05 ms End of update loop 0.00 ms Waiting for query cache lock 0.00 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.02 ms Writing to binlog 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/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: 0.36 ms Nach letzter Abfrage: 0.90 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.612 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 zhmfp_content AS a
INNER JOIN zhmfp_categories AS c
on c.id = a.catid
LEFT JOIN zhmfp_users AS u
on u.id = a.created_by
LEFT JOIN zhmfp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN zhmfp_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 9
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-04-01 19:32:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-04-01 19:32:01')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid,publish_up PRIMARY 4 const 1 1 SIMPLE c const PRIMARY,published PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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: 0.24 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.794 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `zhmfp_contentitem_tag_map` AS m
INNER JOIN `zhmfp_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 7 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 d02d7f9b.m.tag_id 1 Using where Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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: 0.39 ms Nach letzter Abfrage: 4.08 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.383 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 `zhmfp_categories` AS `s`
INNER JOIN `zhmfp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) 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,5)
AND c.published = 1
AND s.id = 8
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right,published idx_left_right|cat_idx 4|207 NULL 3 (54%) Using index condition; Using where; Using rowid filter Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.07 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 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: 0.53 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.427 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 zhmfp_fields AS a
LEFT JOIN `zhmfp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN zhmfp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN zhmfp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN zhmfp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN zhmfp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `zhmfp_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 (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
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 Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_context 766 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 d02d7f9b.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 d02d7f9b.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.13 ms Creating sort index 0.01 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 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: 0.48 ms Nach letzter Abfrage: 10.28 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 13.416 MB Zeilen zurückgegeben: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zhmfp_modules AS m
LEFT JOIN zhmfp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zhmfp_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 <= '2023-04-01 19:32:01')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-04-01 19:32:01')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 107 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 17 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE mm ref PRIMARY PRIMARY 4 d02d7f9b.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 d02d7f9b.m.module,const 1 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.14 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Der selbe Aufruf in der Zeile darunter. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/hli/lib/config.php:56 8 require_once JROOT/templates/hli/lib/config.php JROOT/templates/hli/index.php:11 7 require JROOT/templates/hli/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: 0.22 ms Nach letzter Abfrage: 3.70 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.416 MB Zeilen zurückgegeben: 1
SELECT *
FROM zhmfp_menu
WHERE id='107'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/modules/mod_sclogin/helper.php:429 11 ModScloginHelper->getLoginRedirect() JROOT/modules/mod_sclogin/mod_sclogin.php:27 10 include JROOT/modules/mod_sclogin/mod_sclogin.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 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 8.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 15.613 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 `zhmfp_categories` AS `s`
INNER JOIN `zhmfp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 22
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right,published idx_left_right 4 NULL 4 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.02 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:65 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:71 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:53 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 15.629 MB Zeilen zurückgegeben: 6
SELECT `id`,`name`,`rules`,`parent_id`
FROM `zhmfp_assets`
WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_assets ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 263 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.09 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 17 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 16 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 15 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 14 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 13 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:77 12 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:71 11 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:53 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 1.25 ms Nach letzter Abfrage: 1.58 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 15.864 MB Zeilen zurückgegeben: 1
SELECT a.*,count(DISTINCT wl.id) as waiting_list_count,ser.min_date AS series_min_start_date, ser.max_date AS series_max_end_date,o.title as original_title, o.rrule as original_rrule,GROUP_CONCAT(DISTINCT v.id SEPARATOR ', ') location_ids,GROUP_CONCAT(DISTINCT uh.id SEPARATOR ',') host_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `zhmfp_dpcalendar_events` AS a
LEFT JOIN zhmfp_categories AS c
ON c.id = a.catid
LEFT JOIN zhmfp_dpcalendar_tickets AS wl
ON (wl.event_id = a.id or wl.event_id = a.original_id)
and wl.state = 8
LEFT JOIN (select original_id, max(end_date) as max_date, min(start_date) as min_date
from zhmfp_dpcalendar_events
group by original_id) ser
on ser.original_id = a.original_id
and a.original_id > 0
LEFT JOIN zhmfp_dpcalendar_events AS o
ON o.id = a.original_id
LEFT JOIN zhmfp_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN zhmfp_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN zhmfp_dpcalendar_events_hosts AS relh
ON a.id = relh.event_id
LEFT JOIN zhmfp_users AS uh
ON relh.user_id = uh.id
LEFT JOIN zhmfp_users AS ua
ON ua.id = a.created_by
LEFT JOIN zhmfp_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.original_id > -1
AND a.catid IN ('22')
AND (c.access IN (1,1,5) or c.access is null)
AND (a.state in (1,3))
AND a.state != -2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-04-01 19:32:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-04-01 19:32:01')
AND (a.start_date >= '2023-04-01 19:30:00')
AND a.language in ('de-DE','*')
GROUP BY a.id
ORDER BY a.start_date asc
LIMIT 5id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY wl system event_id,state,notify ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 0 Const row not found; Using temporary; filesort wurde genutzt 1 PRIMARY a range idx_access,idx_start_date,idx_state,idx_catid,idx_language,idx_original_id idx_start_date 5 NULL 1 Using index condition; Using where; filesort wurde genutzt 1 PRIMARY c eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.catid 1 Using where 1 PRIMARY <derived2> ref key0 key0 5 d02d7f9b.a.original_id 10 Using where 1 PRIMARY o eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.original_id 1 Using where 1 PRIMARY rel ref PRIMARY PRIMARY 4 d02d7f9b.a.id 1 Using where; Using index 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 d02d7f9b.rel.location_id 1 Using where; Using index 1 PRIMARY relh ref PRIMARY PRIMARY 4 d02d7f9b.a.id 1 Using where; Using index 1 PRIMARY uh eq_ref PRIMARY PRIMARY 4 d02d7f9b.relh.user_id 1 Using where; Using index 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.created_by 1 Using where 2 DERIVED zhmfp_dpcalendar_events ALL idx_original_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 535 Using temporary; filesort wurde genutzt Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.04 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.07 ms Optimizing 0.03 ms Optimizing 0.00 ms Statistics 0.01 ms Statistics 0.12 ms Preparing 0.01 ms Creating tmp table 0.01 ms Sorting result 0.00 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting for group 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.03 ms Executing 0.00 ms Sending data 0.31 ms Creating sort index 0.01 ms Removing tmp table 0.00 ms Creating sort index 0.17 ms Creating sort index 0.02 ms Removing tmp table 0.05 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.00 ms Freeing items 0.00 ms Removing tmp table 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 12 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/events.php:116 11 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:106 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 15.933 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 zhmfp_fields AS a
LEFT JOIN `zhmfp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN zhmfp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN zhmfp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN zhmfp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN zhmfp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `zhmfp_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_dpcalendar.event'
AND (fc.category_id IS NULL OR fc.category_id IN (22,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
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 Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_context 766 const 1 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 d02d7f9b.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 d02d7f9b.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 d02d7f9b.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.11 ms Creating sort index 0.01 ms Removing tmp table 0.03 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 11 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:155 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.57 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.028 MB Zeilen zurückgegeben: 1
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `zhmfp_categories` AS `s`
INNER JOIN `zhmfp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 20
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right,published cat_idx|idx_left_right 207|4 NULL 4 (33%) Using index condition; Using where; filesort wurde genutzt; Using rowid filter Status Duration Starting 0.08 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:65 14 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/route.php:447 13 DPCalendarHelperRoute::findItem() JROOT/components/com_dpcalendar/helpers/route.php:52 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:31 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:161 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.038 MB Zeilen zurückgegeben: 1
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `zhmfp_categories` AS `s`
INNER JOIN `zhmfp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 21
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range|filter cat_idx,idx_access,idx_left_right,published cat_idx|idx_left_right 207|4 NULL 4 (50%) Using index condition; Using where; filesort wurde genutzt; Using rowid filter Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Sorting result 0.00 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:65 14 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/route.php:447 13 DPCalendarHelperRoute::findItem() JROOT/components/com_dpcalendar/helpers/route.php:52 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:31 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:161 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 16.048 MB Zeilen zurückgegeben: 0
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 `zhmfp_categories` AS `s`
INNER JOIN `zhmfp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_dpcalendar' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 559
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:65 21 DPCalendar\Helper\DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/helpers/legacyrouter.php:77 20 DPCalendarRouterLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 19 Joomla\CMS\Component\Router\RouterView->build() JROOT/components/com_dpcalendar/router.php:94 18 DPCalendarRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 17 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 16 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/components/com_dpcalendar/helpers/route.php:63 12 DPCalendarHelperRoute::getEventRoute() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:31 11 DPCalendar\Router\Router->getEventRoute() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:161 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 2.54 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 16.288 MB Zeilen zurückgegeben: 17
SHOW FULL COLUMNS
FROM `zhmfp_users`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `zhmfp_users`Status Duration Starting 0.01 ms checking permissions 0.00 ms closing tables 0.00 ms Opening tables 0.09 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms Optimizing 0.00 ms Statistics 0.00 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.04 ms closing tables 0.00 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Removing tmp table 0.03 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 30 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 29 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 28 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 27 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 26 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 25 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:15 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:19 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:16 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:19 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:142 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:231 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 16.322 MB Zeilen zurückgegeben: 1
SELECT *
FROM `zhmfp_users`
WHERE `id` = 687id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zhmfp_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 26 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:15 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:19 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:16 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:19 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:142 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:231 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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 - Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 16.345 MB Zeilen zurückgegeben: 3
SELECT `g`.`id`,`g`.`title`
FROM `zhmfp_usergroups` AS g
INNER JOIN `zhmfp_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 687id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 3 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 d02d7f9b.m.group_id 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Aufrufer Datei und Zeilennummer 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 26 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:15 20 DPCalendar\Helper\UserHelper->getUser() JROOT/components/com_dpcalendar/layouts/schema/performer.php:10 19 include JROOT/components/com_dpcalendar/layouts/schema/performer.php JROOT/libraries/src/Layout/FileLayout.php:125 18 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 17 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:19 16 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/components/com_dpcalendar/layouts/schema/event.php:16 15 include JROOT/components/com_dpcalendar/layouts/schema/event.php JROOT/libraries/src/Layout/FileLayout.php:125 14 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 13 Joomla\CMS\Layout\LayoutHelper::render() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:19 12 DPCalendar\Helper\LayoutHelper->renderLayout() JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:142 11 require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:231 10 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.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
25 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
5 × 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 `zhmfp_categories` AS `s`
INNER JOIN `zhmfp_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)3 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `zhmfp_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zhmfp_extensions`2 × 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 zhmfp_fields AS a
LEFT JOIN `zhmfp_languages` AS l
ON l.lang_code = a.language
LEFT JOIN zhmfp_users AS uc
ON uc.id=a.checked_out
LEFT JOIN zhmfp_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN zhmfp_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN zhmfp_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `zhmfp_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `zhmfp_session`1 × SELECT `session_id`
FROM `zhmfp_session`1 × SELECT id, rules
FROM `zhmfp_viewlevels1 × SELECT b.id
FROM zhmfp_usergroups AS a
LEFT JOIN zhmfp_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM zhmfp_extensions1 × SELECT setting,value
FROM zhmfp_jfbconnect_confi1 × 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 zhmfp_menu AS m
LEFT JOIN zhmfp_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM zhmfp_template_styles as s
LEFT JOIN zhmfp_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM zhmfp_languages1 × 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 zhmfp_content AS a
INNER JOIN zhmfp_categories AS c
on c.id = a.catid
LEFT JOIN zhmfp_users AS u
on u.id = a.created_by
LEFT JOIN zhmfp_categories as parent
ON parent.id = c.parent_id
LEFT JOIN zhmfp_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `zhmfp_contentitem_tag_map` AS m
INNER JOIN `zhmfp_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zhmfp_modules AS m
LEFT JOIN zhmfp_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zhmfp_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM zhmfp_menu1 × SELECT a.*,count(DISTINCT wl.id) as waiting_list_count,ser.min_date AS series_min_start_date, ser.max_date AS series_max_end_date,o.title as original_title, o.rrule as original_rrule,GROUP_CONCAT(DISTINCT v.id SEPARATOR ', ') location_ids,GROUP_CONCAT(DISTINCT uh.id SEPARATOR ',') host_ids,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
FROM `zhmfp_dpcalendar_events` AS a
LEFT JOIN zhmfp_categories AS c
ON c.id = a.catid
LEFT JOIN zhmfp_dpcalendar_tickets AS wl
ON (wl.event_id = a.id or wl.event_id = a.original_id)
and wl.state = 8
LEFT JOIN (select original_id, max(end_date) as max_date, min(start_date) as min_date
from zhmfp_dpcalendar_events
group by original_id) ser
on ser.original_id = a.original_id
and a.original_id > 0
LEFT JOIN zhmfp_dpcalendar_events AS o
ON o.id = a.original_id
LEFT JOIN zhmfp_dpcalendar_events_location AS rel
ON a.id = rel.event_id
LEFT JOIN zhmfp_dpcalendar_locations AS v
ON rel.location_id = v.id
LEFT JOIN zhmfp_dpcalendar_events_hosts AS relh
ON a.id = relh.event_id
LEFT JOIN zhmfp_users AS uh
ON relh.user_id = uh.id
LEFT JOIN zhmfp_users AS ua
ON ua.id = a.created_by
LEFT JOIN zhmfp_users AS uam
ON uam.id = a.modified_by1 × SELECT *
FROM `zhmfp_users`1 × SELECT `g`.`id`,`g`.`title`
FROM `zhmfp_usergroups` AS g
INNER JOIN `zhmfp_user_usergroup_map` AS m
ON m.group_id = g.id
Andere Tabellen:
1 × INSERT INTO `zhmfp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3166313464323438363439316264656533373933303365653835613565306262', 1, 1680377521, 0, '', 01 × UPDATE `zhmfp_extensions`
SET `params` = '{\"mediaversion\":\"6f19a567b092722abe19328b33d87ae1\"}'1 × SHOW FULL COLUMNS
FROM `zhmfp_content1 × UPDATE zhmfp_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `zhmfp_users