Wir melden für die Hamburger Hallenmeisterschaft die unglaubliche Anzahl von 11 Mannschaften.
Da der Anmeldezeitraum abgelaufen ist, werden in kürze auch die Staffeln vom DFB erscheinen.
Wir wünschen den „ kleinen „ des 1. FCQ viel Spass und Erfolg in der Hallenrunde!
.
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713973579,
"last": 1713973579,
"now": 1713973579
}
},
"registry": {
"com_installer": {
"message": "",
"extension_message": ""
}
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Zeit
Speicher
Zeit: 21.97 ms / 21.97 ms Speicher: 0.545 MB / 0.87 MB Application: afterLoad
Zeit: 87.74 ms / 109.71 ms Speicher: 1.145 MB / 2.01 MB Application: afterInitialise
Zeit: 20.49 ms / 130.20 ms Speicher: 0.299 MB / 2.31 MB Application: afterRoute
Zeit: 12.55 ms / 142.76 ms Speicher: 0.087 MB / 2.40 MB Application: beforeRenderComponent com_content
Zeit: 6.16 ms / 148.92 ms Speicher: 0.118 MB / 2.52 MB Application: Before Access::preloadComponents (all components)
Zeit: 1.21 ms / 150.13 ms Speicher: 0.062 MB / 2.58 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 150.14 ms Speicher: -0.004 MB / 2.58 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 1.39 ms / 151.53 ms Speicher: 0.229 MB / 2.81 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.02 ms / 151.55 ms Speicher: -0.011 MB / 2.79 MB Application: Before Access::getAssetRules (id:148 name:com_content.article.48)
Zeit: 0.62 ms / 152.17 ms Speicher: 0.073 MB / 2.87 MB Application: After Access::getAssetRules (id:148 name:com_content.article.48)
Zeit: 51.63 ms / 203.80 ms Speicher: 0.659 MB / 3.53 MB Application: afterRenderComponent com_content
Zeit: 1.50 ms / 205.29 ms Speicher: 0.008 MB / 3.53 MB Application: afterDispatch
Zeit: 4.36 ms / 209.66 ms Speicher: 0.065 MB / 3.60 MB Application: beforeRenderModule mod_menu ()
Zeit: 3.35 ms / 213.00 ms Speicher: 0.119 MB / 3.72 MB Application: afterRenderModule mod_menu ()
Zeit: 632.64 ms / 845.65 ms Speicher: 0.445 MB / 4.16 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Zeit: 0.04 ms / 845.69 ms Speicher: 0.007 MB / 4.17 MB Application: After Access::getAssetRules (id:1 name:root.1)
Zeit: 62.78 ms / 908.47 ms Speicher: 0.101 MB / 4.27 MB Application: afterRender
Datenbankabfragen gesamt: 85.03 ms
4,80 MB (5.035.648 Bytes)
48 ausgeführte Abfragen 85.03 ms
- Abfragezeit: 0.52 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.348 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `hlac5_session`
WHERE `session_id` = X'3138643230363562313932386135633931653462613236353739656135363866'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 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.60 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.425 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `hlac5_session`
WHERE `session_id` = X'3138643230363562313932386135633931653462613236353739656135363866'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 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: 15.22 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.430 MB
INSERT INTO `hlac5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3138643230363562313932386135633931653462613236353739656135363866', 1, 1713973579, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `hlac5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3138643230363562313932386135633931653462613236353739656135363866', 1, 1713973579, 0, '', 0)Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms update 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 14.77 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.08 ms Nach letzter Abfrage: 3.23 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 1.463 MB Zeilen zurückgegeben: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hlac5_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref extension extension 82 const 45 1.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.13 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 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}() Same as call in the line below. 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.56 ms Nach letzter Abfrage: 2.99 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.501 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `hlac5_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 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.74 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.513 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM hlac5_usergroups AS a
LEFT JOIN hlac5_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 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: 1.18 ms Nach letzter Abfrage: 1.31 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.535 MB Zeilen zurückgegeben: 95
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM hlac5_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref extension extension 82 const 147 0.60 Using where; filesort wurde genutzt Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.42 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 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}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.34 ms Nach letzter Abfrage: 34.40 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 2.042 MB Zeilen zurückgegeben: 20
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 hlac5_menu AS m
LEFT JOIN hlac5_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 223 5.61 Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.m.component_id 1 100.00 Using where Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.34 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 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}() Same as call in the line below. 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.74 ms Nach letzter Abfrage: 16.64 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.333 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hlac5_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 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}() Same as call in the line below. 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: 6.34 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.324 MB
UPDATE `hlac5_extensions`
SET `params` = '{\"mediaversion\":\"37664e23120fe6d9c38f4c8a115dac64\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `hlac5_extensions` SET `params` = '{\"mediaversion\":\"37664e23120fe6d9c38f4c8a115dac64\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.04 ms updating 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 5.86 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 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.57 ms Nach letzter Abfrage: 3.02 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.355 MB Zeilen zurückgegeben: 2
SELECT *
FROM hlac5_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_languages NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where; filesort wurde genutzt Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 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.81 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.368 MB Zeilen zurückgegeben: 9
SELECT id, home, template, s.params
FROM hlac5_template_styles as s
LEFT JOIN hlac5_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 11 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 fcquickbor5.e.element 1 81.82 Using index condition; Using where Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.11 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.05 ms Nach letzter Abfrage: 6.59 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.523 MB Zeilen zurückgegeben: 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `hlac5_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_cbjuice2','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_joomsport','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mp','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_assets NULL range idx_asset_name idx_asset_name 202 NULL 45 100.00 Using index condition Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.28 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.13 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.075 MB Speichernutzung vor Abfrage: 2.577 MB Zeilen zurückgegeben: 252
SELECT `id`,`name`,`rules`,`parent_id`
FROM `hlac5_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_assets NULL ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 466 24.21 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.30 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 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: 1.83 ms Nach letzter Abfrage: 1.70 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 2.871 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `hlac5_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `hlac5_content`Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.37 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.05 ms executing 0.17 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.10 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 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: 6.50 ms Nach letzter Abfrage: 3.58 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.921 MB
UPDATE hlac5_content
SET `hits` = (`hits` + 1)
WHERE `id` = '48'„EXPLAIN“ unmöglich für Abfrage: UPDATE hlac5_content SET `hits` = (`hits` + 1) WHERE `id` = '48'Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.06 ms updating 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 5.82 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 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.93 ms Nach letzter Abfrage: 1.84 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.010 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 hlac5_content AS a
INNER JOIN hlac5_categories AS c
on c.id = a.catid
LEFT JOIN hlac5_users AS u
on u.id = a.created_by
LEFT JOIN hlac5_categories as parent
ON parent.id = c.parent_id
LEFT JOIN hlac5_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 48
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-24 15:46:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 15:46:19')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.14 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.03 ms Nach letzter Abfrage: 2.64 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.047 MB Zeilen zurückgegeben: 3
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 `hlac5_categories` AS `s`
INNER JOIN `hlac5_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 = 12
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 25 22.88 Using where Status Duration starting 0.15 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.10 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 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.83 ms Nach letzter Abfrage: 0.90 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.077 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `hlac5_contentitem_tag_map` AS m
INNER JOIN `hlac5_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 48
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 fcquickbor5.m.tag_id 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.30 ms Nach letzter Abfrage: 17.01 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.358 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 hlac5_fields AS a
LEFT JOIN `hlac5_languages` AS l
ON l.lang_code = a.language
LEFT JOIN hlac5_users AS uc
ON uc.id=a.checked_out
LEFT JOIN hlac5_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN hlac5_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN hlac5_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `hlac5_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 (12,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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 fcquickbor5.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 fcquickbor5.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.15 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.05 ms executing 0.23 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 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.96 ms Nach letzter Abfrage: 16.60 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.601 MB Zeilen zurückgegeben: 4
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM hlac5_modules AS m
LEFT JOIN hlac5_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN hlac5_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 <= '2024-04-24 15:46:19')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-24 15:46:19')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 12 1.60 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 fcquickbor5.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 fcquickbor5.m.id 1 40.00 Using where; Using index Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms executing 0.19 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Same as call in the line below. 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:37 10 Joomla\CMS\Helper\ModuleHelper::getModule() JROOT/templates/at_robseco/includes/globals.php:9 9 include JROOT/templates/at_robseco/includes/globals.php JROOT/templates/at_robseco/includes/header.php:8 8 require_once JROOT/templates/at_robseco/includes/header.php JROOT/templates/at_robseco/index.php:29 7 require JROOT/templates/at_robseco/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.66 ms Nach letzter Abfrage: 14.08 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.845 MB
LOCK TABLES `hlac5_extensions` WRITE
„EXPLAIN“ unmöglich für Abfrage: LOCK TABLES `hlac5_extensions` WRITEStatus Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.21 ms System lock 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:551 8 JDatabaseDriverMysqli->lockTable() JROOT/plugins/system/updatenotification/updatenotification.php:78 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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: 3.57 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.850 MB
UPDATE `hlac5_extensions`
SET `params` = '{\"lastrun\":1713973579}'
WHERE `type` = 'plugin'
AND `folder` = 'system'
AND `element` = 'updatenotification'„EXPLAIN“ unmöglich für Abfrage: UPDATE `hlac5_extensions` SET `params` = '{\"lastrun\":1713973579}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.08 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 3.03 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/updatenotification/updatenotification.php:89 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.39 ms Nach letzter Abfrage: 2.03 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.862 MB
UNLOCK TABLES
„EXPLAIN“ unmöglich für Abfrage: UNLOCK TABLESStatus Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms waiting for handler commit 0.03 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:926 8 JDatabaseDriverMysqli->unlockTables() JROOT/plugins/system/updatenotification/updatenotification.php:103 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.89 ms Nach letzter Abfrage: 1.43 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.873 MB Zeilen zurückgegeben: 1
SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `hlac5_update_sites` AS `a`
INNER JOIN hlac5_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id
WHERE a.enabled = 1
AND b.extension_id IN (700)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 27 10.00 Using where; Using temporary 1 SIMPLE b NULL eq_ref PRIMARY PRIMARY 8 fcquickbor5.a.update_site_id,const 1 100.00 Using index; Distinct Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Creating tmp table 0.04 ms executing 0.21 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Updater/Updater.php:248 9 Joomla\CMS\Updater\Updater->getUpdateSites() JROOT/libraries/src/Updater/Updater.php:127 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.66 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.880 MB Zeilen zurückgegeben: 2
SELECT DISTINCT update_site_id
FROM hlac5_updates
WHERE `update_site_id` IN ( SELECT update_site_id
FROM hlac5_update_sites
WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1713951979')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_updates NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 100.00 Using where; Using temporary 1 SIMPLE hlac5_update_sites NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.hlac5_updates.update_site_id 1 40.00 Using where; Distinct Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Updater/Updater.php:426 9 Joomla\CMS\Updater\Updater->getSitesWithUpdates() JROOT/libraries/src/Updater/Updater.php:140 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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: 3.96 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.884 MB
DELETE
FROM `hlac5_updates`
WHERE `update_site_id` = '1'„EXPLAIN“ unmöglich für Abfrage: DELETE FROM `hlac5_updates` WHERE `update_site_id` = '1'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.02 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 3.57 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:165 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.34 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.897 MB Zeilen zurückgegeben: 1
SELECT `name`
FROM `hlac5_update_sites`
WHERE `update_site_id` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_update_sites NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/src/Updater/UpdateAdapter.php:195 12 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName() JROOT/libraries/src/Updater/UpdateAdapter.php:222 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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: 5.55 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 3.903 MB
UPDATE `hlac5_update_sites`
SET `enabled` = '0'
WHERE `update_site_id` = '1'„EXPLAIN“ unmöglich für Abfrage: UPDATE `hlac5_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '1'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.02 ms updating 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 5.16 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 12 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:245 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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: 6.46 ms Nach letzter Abfrage: 569.16 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 3.923 MB
UPDATE `hlac5_update_sites`
SET `enabled` = '1'
WHERE `update_site_id` = '1'„EXPLAIN“ unmöglich für Abfrage: UPDATE `hlac5_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '1'Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.04 ms updating 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 5.82 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 12 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:265 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.56 ms Nach letzter Abfrage: 2.37 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.931 MB Zeilen zurückgegeben: 14
SHOW FULL COLUMNS
FROM `hlac5_updates`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `hlac5_updates`Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.37 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.13 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Update.php:32 14 Joomla\CMS\Table\Update->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126 12 Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement() Same as call in the line below. 11 xml_parse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.64 ms Nach letzter Abfrage: 1.13 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.955 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `hlac5_extensions`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `hlac5_extensions`Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.37 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.13 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 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/Extension.php:32 11 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/Updater/Updater.php:330 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.09 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.991 MB Zeilen zurückgegeben: 0
SELECT `update_id`
FROM `hlac5_updates`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_updates NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Update.php:114 10 Joomla\CMS\Table\Update->find() JROOT/libraries/src/Updater/Updater.php:338 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.40 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.997 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `hlac5_extensions`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref element_clientid,element_folder_clientid,extension extension 887 const,const,const,const 1 100.00 Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/libraries/src/Updater/Updater.php:348 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.40 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.003 MB Zeilen zurückgegeben: 1
SELECT *
FROM hlac5_extensions
WHERE `extension_id` = '700'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 10 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Updater/Updater.php:358 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.34 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.010 MB Zeilen zurückgegeben: 0
SELECT `update_id`
FROM `hlac5_updates`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_updates NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Update.php:114 10 Joomla\CMS\Table\Update->find() JROOT/libraries/src/Updater/Updater.php:338 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.015 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `hlac5_extensions`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref element_clientid,element_folder_clientid,extension extension 887 const,const,const,const 1 100.00 Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/libraries/src/Updater/Updater.php:348 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.40 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.021 MB Zeilen zurückgegeben: 1
SELECT *
FROM hlac5_extensions
WHERE `extension_id` = '700'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 10 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Updater/Updater.php:358 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.31 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.026 MB Zeilen zurückgegeben: 0
SELECT `update_id`
FROM `hlac5_updates`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_updates NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Update.php:114 10 Joomla\CMS\Table\Update->find() JROOT/libraries/src/Updater/Updater.php:338 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.40 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.031 MB Zeilen zurückgegeben: 1
SELECT `extension_id`
FROM `hlac5_extensions`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref element_clientid,element_folder_clientid,extension extension 887 const,const,const,const 1 100.00 Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/libraries/src/Updater/Updater.php:348 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.39 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.038 MB Zeilen zurückgegeben: 1
SELECT *
FROM hlac5_extensions
WHERE `extension_id` = '700'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 10 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Updater/Updater.php:358 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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: 6.15 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.100 MB
INSERT INTO `hlac5_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`)
VALUES ('1','700','Joomla','','joomla','file','','0','4.4.4','','https://update.joomla.org/core/sts/extension_sts.xml','','')„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `hlac5_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) VALUES ('1','700','Joomla','','joomla','file','','0','4.4.4','','https://update.joomla.org/core/sts/extension_sts.xml','','')Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms update 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 5.76 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1421 10 JDatabaseDriver->insertObject() JROOT/libraries/src/Table/Table.php:821 9 Joomla\CMS\Table\Table->store() JROOT/libraries/src/Updater/Updater.php:177 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.32 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.103 MB
UPDATE `hlac5_update_sites`
SET `last_check_timestamp` = '1713973580'
WHERE `update_site_id` = '1'„EXPLAIN“ unmöglich für Abfrage: UPDATE `hlac5_update_sites` SET `last_check_timestamp` = '1713973580' WHERE `update_site_id` = '1'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.02 ms updating 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.96 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:455 9 Joomla\CMS\Updater\Updater->updateLastCheckTimestamp() JROOT/libraries/src/Updater/Updater.php:182 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.47 ms Nach letzter Abfrage: 1.75 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.114 MB Zeilen zurückgegeben: 1
SELECT u.*,`e`.`manifest_cache`
FROM `hlac5_updates` AS `u`
LEFT JOIN `hlac5_extensions` AS `e`
ON `e`.`extension_id` = `u`.`extension_id`
WHERE `u`.`extension_id` != '0'
AND `u`.`extension_id` = '700'
ORDER BY `u`.`name` asc
LIMIT 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE u NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.u.extension_id 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_installer/models/update.php:217 9 InstallerModelUpdate->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 8 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/plugins/system/updatenotification/updatenotification.php:136 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.43 ms Nach letzter Abfrage: 3.66 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.144 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `hlac5_assets`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `hlac5_assets`Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.37 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Asset.php:61 10 Joomla\CMS\Table\Asset->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/updatenotification/updatenotification.php:297 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.45 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.160 MB Zeilen zurückgegeben: 1
SELECT id
FROM hlac5_assets
WHERE parent_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_assets NULL ref idx_parent_id idx_parent_id 4 const 1 100.00 Using index Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Table/Nested.php:1219 9 Joomla\CMS\Table\Nested->getRootId() JROOT/plugins/system/updatenotification/updatenotification.php:297 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.48 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.172 MB Zeilen zurückgegeben: 3
SELECT `user_id`
FROM `hlac5_user_usergroup_map`
WHERE `group_id` IN('8')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_user_usergroup_map NULL index PRIMARY PRIMARY 8 NULL 14 10.00 Using where; Using index Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 9 JDatabaseDriver->loadColumn() JROOT/plugins/system/updatenotification/updatenotification.php:333 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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.41 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.178 MB Zeilen zurückgegeben: 2
SELECT `id`,`username`,`email`
FROM `hlac5_users`
WHERE `id` IN('353','354','382')
AND `block` = 0
AND `sendEmail` = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_users NULL range PRIMARY,idx_block PRIMARY 4 NULL 3 20.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/updatenotification/updatenotification.php:373 8 PlgSystemUpdatenotification->getSuperUsers() JROOT/plugins/system/updatenotification/updatenotification.php:186 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 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
40 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
3 × SELECT `update_id`
FROM `hlac5_updates`3 × SELECT `extension_id`
FROM `hlac5_extensions`3 × SELECT *
FROM hlac5_extensions2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hlac5_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `hlac5_assets`1 × SELECT `data`
FROM `hlac5_session`1 × SELECT `session_id`
FROM `hlac5_session`1 × SELECT id, rules
FROM `hlac5_viewlevels1 × SELECT b.id
FROM hlac5_usergroups AS a
LEFT JOIN hlac5_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 hlac5_extensions1 × 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 hlac5_menu AS m
LEFT JOIN hlac5_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM hlac5_languages1 × SELECT id, home, template, s.params
FROM hlac5_template_styles as s
LEFT JOIN hlac5_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 hlac5_content AS a
INNER JOIN hlac5_categories AS c
on c.id = a.catid
LEFT JOIN hlac5_users AS u
on u.id = a.created_by
LEFT JOIN hlac5_categories as parent
ON parent.id = c.parent_id
LEFT JOIN hlac5_content_rating AS v
ON a.id = v.content_id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `hlac5_categories` AS `s`
INNER JOIN `hlac5_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `hlac5_contentitem_tag_map` AS m
INNER JOIN `hlac5_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM hlac5_fields AS a
LEFT JOIN `hlac5_languages` AS l
ON l.lang_code = a.language
LEFT JOIN hlac5_users AS uc
ON uc.id=a.checked_out
LEFT JOIN hlac5_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN hlac5_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN hlac5_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `hlac5_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM hlac5_modules AS m
LEFT JOIN hlac5_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN hlac5_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `hlac5_update_sites` AS `a`
INNER JOIN hlac5_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id1 × SELECT DISTINCT update_site_id
FROM hlac5_updates1 × SELECT `name`
FROM `hlac5_update_sites`1 × SELECT u.*,`e`.`manifest_cache`
FROM `hlac5_updates` AS `u`
LEFT JOIN `hlac5_extensions` AS `e`
ON `e`.`extension_id` = `u`.`extension_id`1 × SELECT id
FROM hlac5_assets1 × SELECT `user_id`
FROM `hlac5_user_usergroup_map`1 × SELECT `id`,`username`,`email`
FROM `hlac5_users`
Andere Tabellen:
1 × INSERT INTO `hlac5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3138643230363562313932386135633931653462613236353739656135363866', 1, 1713973579, 0, '', 01 × UPDATE `hlac5_extensions`
SET `params` = '{\"mediaversion\":\"37664e23120fe6d9c38f4c8a115dac64\"}'1 × SHOW FULL COLUMNS
FROM `hlac5_content1 × UPDATE hlac5_content
SET `hits` = (`hits` + 1)1 × LOCK TABLES `hlac5_extensions` WRIT
1 × UPDATE `hlac5_extensions`
SET `params` = '{\"lastrun\":1713973579}'1 × UNLOCK TABLE
1 × DELETE
FROM `hlac5_updates`1 × UPDATE `hlac5_update_sites`
SET `enabled` = '0'1 × UPDATE `hlac5_update_sites`
SET `enabled` = '1'1 × SHOW FULL COLUMNS
FROM `hlac5_updates1 × SHOW FULL COLUMNS
FROM `hlac5_extensions1 × INSERT INTO `hlac5_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`)
VALUES ('1','700','Joomla','','joomla','file','','0','4.4.4','','https://update.joomla.org/core/sts/extension_sts.xml','',''1 × UPDATE `hlac5_update_sites`
SET `last_check_timestamp` = '1713973580'1 × SHOW FULL COLUMNS
FROM `hlac5_assets
Joomla!-Debug-Konsole
Sitzung
{ "__default": { "session": { "counter": 1, "timer": { "start": 1713973579, "last": 1713973579, "now": 1713973579 } }, "registry": { "com_installer": { "message": "", "extension_message": "" } }, "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 } } }Profil zum Laufzeitverhalten
Zeit
Speicher
Speichernutzung
Datenbankabfragen
48 ausgeführte Abfragen 85.03 ms
9 Dublikate gefunden!
40 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
Andere Tabellen: