- Hormayrgasse 39 A - 1170 Wien
- +43 699 123 64 665
- office@pst-umzugsservice.at
Contact Categories
- Startseite
- Joomla!
- Contact Component
- Contact Categories
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1685830146,
"last": 1685830146,
"now": 1685830146
},
"token": "UXOabvqvFMblikkQkOZSwXsO9gvnJsyo"
},
"registry": {},
"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: 15.37 ms / 15.37 ms Speicher: 1.669 MB / 2.01 MB Application: afterLoad
Zeit: 51.12 ms / 66.50 ms Speicher: 4.173 MB / 6.18 MB Application: afterInitialise
Zeit: 26.49 ms / 92.99 ms Speicher: 1.924 MB / 8.10 MB Application: afterRoute
Zeit: 0.86 ms / 93.85 ms Speicher: 0.127 MB / 8.23 MB Application: beforeRenderComponent com_contact
Zeit: 47.47 ms / 141.32 ms Speicher: 1.244 MB / 9.48 MB Application: afterRenderComponent com_contact
Zeit: 1.06 ms / 142.38 ms Speicher: 0.005 MB / 9.48 MB Application: afterDispatch
Zeit: 31.39 ms / 173.77 ms Speicher: 1.110 MB / 10.59 MB Application: beforeRenderModule mod_search (Search)
Zeit: 1.19 ms / 174.96 ms Speicher: 0.039 MB / 10.63 MB Application: afterRenderModule mod_search (Search)
Zeit: 0.03 ms / 174.99 ms Speicher: 0.000 MB / 10.63 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)
Zeit: 15.57 ms / 190.56 ms Speicher: 0.510 MB / 11.14 MB Application: afterRenderModule mod_menu (Off Canvas Menu)
Zeit: 0.09 ms / 190.66 ms Speicher: 0.000 MB / 11.14 MB Application: beforeRenderModule mod_menu (Services)
Zeit: 1.88 ms / 192.54 ms Speicher: 0.042 MB / 11.18 MB Application: afterRenderModule mod_menu (Services)
Zeit: 0.03 ms / 192.57 ms Speicher: 0.000 MB / 11.18 MB Application: beforeRenderModule mod_menu (Impressum)
Zeit: 0.22 ms / 192.79 ms Speicher: 0.004 MB / 11.18 MB Application: afterRenderModule mod_menu (Impressum)
Zeit: 0.04 ms / 192.83 ms Speicher: 0.000 MB / 11.18 MB Application: beforeRenderModule mod_menu (Leistungen)
Zeit: 1.46 ms / 194.30 ms Speicher: 0.033 MB / 11.21 MB Application: afterRenderModule mod_menu (Leistungen)
Zeit: 0.05 ms / 194.35 ms Speicher: 0.000 MB / 11.21 MB Application: beforeRenderModule mod_menu (Menü)
Zeit: 1.33 ms / 195.67 ms Speicher: 0.029 MB / 11.24 MB Application: afterRenderModule mod_menu (Menü)
Zeit: 0.05 ms / 195.72 ms Speicher: 0.000 MB / 11.24 MB Application: beforeRenderModule mod_custom (Über uns)
Zeit: 0.53 ms / 196.25 ms Speicher: 0.021 MB / 11.26 MB Application: afterRenderModule mod_custom (Über uns)
Zeit: 0.05 ms / 196.30 ms Speicher: 0.000 MB / 11.26 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 1.85 ms / 198.14 ms Speicher: 0.111 MB / 11.37 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.06 ms / 198.20 ms Speicher: 0.000 MB / 11.37 MB Application: beforeRenderModule mod_search (Search-top)
Zeit: 0.48 ms / 198.68 ms Speicher: 0.008 MB / 11.37 MB Application: afterRenderModule mod_search (Search-top)
Zeit: 0.06 ms / 198.74 ms Speicher: 0.000 MB / 11.37 MB Application: beforeRenderModule mod_custom (Kostenlose Besichtigung)
Zeit: 0.29 ms / 199.03 ms Speicher: 0.003 MB / 11.38 MB Application: afterRenderModule mod_custom (Kostenlose Besichtigung)
Zeit: 28.80 ms / 227.83 ms Speicher: 0.995 MB / 12.37 MB Application: afterRender
Datenbankabfragen gesamt: 13.78 ms
12,61 MB (13.224.368 Bytes)
17 ausgeführte Abfragen 13.78 ms
- Abfragezeit: 0.70 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.551 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `qnm7x_session`
WHERE `session_id` = '9vq6q0st0675iu7cjto716l2i4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_session const PRIMARY PRIMARY 194 const 1 Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.30 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.07 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Derselbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.23 ms Nach letzter Abfrage: 1.50 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.657 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `qnm7x_session`
WHERE `session_id` = '9vq6q0st0675iu7cjto716l2i4'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 3.664 MB
INSERT INTO `qnm7x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('9vq6q0st0675iu7cjto716l2i4', 1, 1685830146, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `qnm7x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('9vq6q0st0675iu7cjto716l2i4', 1, 1685830146, 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms update 0.08 ms Waiting for query cache lock 0.00 ms update 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.04 ms Nach letzter Abfrage: 3.47 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 3.939 MB Zeilen zurückgegeben: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qnm7x_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_extensions ref extension extension 82 const 52 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.26 ms System lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.14 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Derselbe Aufruf in der Zeile darunter. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.82 ms Nach letzter Abfrage: 2.33 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.161 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `qnm7x_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_viewlevels ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.12 ms System lock 0.00 ms init 0.00 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.176 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM qnm7x_usergroups AS a
LEFT JOIN qnm7x_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms System lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.91 ms Nach letzter Abfrage: 0.58 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 4.243 MB Zeilen zurückgegeben: 107
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qnm7x_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_extensions ref extension extension 82 const 111 Using where; filesort wurde genutzt Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.38 ms Sending data 0.21 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Derselbe Aufruf in der Zeile darunter. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.88 ms Nach letzter Abfrage: 24.00 ms Abfragespeichernutzung: 0.159 MB Speichernutzung vor Abfrage: 6.358 MB Zeilen zurückgegeben: 116
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 qnm7x_menu AS m
LEFT JOIN qnm7x_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 1 Using where; filesort wurde genutzt 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 2123396db37.m.component_id 1 Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.23 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.28 ms Sending data 0.44 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 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:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 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:64 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:491 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:1073 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.30 ms Nach letzter Abfrage: 10.02 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 7.458 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qnm7x_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:388 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 7.454 MB
UPDATE `qnm7x_extensions`
SET `params` = '{\"mediaversion\":\"873e6e84bf16a6ae0ad17d5db1713e48\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `qnm7x_extensions` SET `params` = '{\"mediaversion\":\"873e6e84bf16a6ae0ad17d5db1713e48\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.00 ms init 0.07 ms Updating 0.04 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:388 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 4.08 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.804 MB Zeilen zurückgegeben: 1
SELECT *
FROM qnm7x_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_languages ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 Using where; filesort wurde genutzt Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.17 ms System lock 0.00 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 11 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:243 10 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:53 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:404 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.67 ms Nach letzter Abfrage: 2.71 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 8.052 MB Zeilen zurückgegeben: 4
SELECT id, home, template, s.params
FROM qnm7x_template_styles as s
LEFT JOIN qnm7x_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 2123396db37.s.template,const 1 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.12 ms System lock 0.00 ms init 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 13 JHtmlJquery::framework() Derselbe Aufruf in der Zeile darunter. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:71 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:404 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.34 ms Nach letzter Abfrage: 31.23 ms Abfragespeichernutzung: 0.055 MB Speichernutzung vor Abfrage: 8.724 MB Zeilen zurückgegeben: 30
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,( SELECT COUNT(i.`id`)
FROM `qnm7x_contact_details` AS `i`
WHERE i.`catid` = c.id
AND i.published = 1) AS numitems
FROM `qnm7x_categories` AS `s`
INNER JOIN `qnm7x_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_contact' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 16
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 filesort wurde genutzt 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 55 Using where 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 2123396db37.c.id 2 Using where Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.36 ms System lock 0.01 ms init 0.04 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.05 ms Sending data 0.03 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.01 ms executing 0.00 ms Sending data 0.00 ms end 0.01 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/components/com_contact/models/categories.php:111 12 ContactModelCategories->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoriesView.php:56 10 Joomla\CMS\MVC\View\CategoriesView->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.64 ms Nach letzter Abfrage: 15.70 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 9.353 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 `qnm7x_categories` AS `s`
INNER JOIN `qnm7x_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_contact' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 34
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 9 Using where Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.04 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_contact/router.php:68 25 ContactRouter->getCategorySegment() Derselbe Aufruf in der Zeile darunter. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 16 Joomla\CMS\Router\Route::_() JROOT/components/com_contact/views/categories/tmpl/default_items.php:28 15 include JROOT/components/com_contact/views/categories/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:697 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_contact/views/categories/tmpl/default.php:40 13 include JROOT/components/com_contact/views/categories/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoriesView.php:97 10 Joomla\CMS\MVC\View\CategoriesView->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.063 MB Speichernutzung vor Abfrage: 9.387 MB Zeilen zurückgegeben: 29
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 `qnm7x_categories` AS `s`
INNER JOIN `qnm7x_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_contact' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 35
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 filesort wurde genutzt 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 55 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.00 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.05 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 28 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 27 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 26 Joomla\CMS\Categories\Categories->get() JROOT/components/com_contact/router.php:68 25 ContactRouter->getCategorySegment() Derselbe Aufruf in der Zeile darunter. 24 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 23 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 22 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 21 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672 20 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 19 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 18 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102 17 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52 16 Joomla\CMS\Router\Route::_() JROOT/components/com_contact/views/categories/tmpl/default_items.php:28 15 include JROOT/components/com_contact/views/categories/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:697 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_contact/views/categories/tmpl/default.php:40 13 include JROOT/components/com_contact/views/categories/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:697 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoriesView.php:97 10 Joomla\CMS\MVC\View\CategoriesView->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_contact/controller.php:68 8 ContactController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_contact/contact.php:29 6 require_once JROOT/components/com_contact/contact.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.20 ms Nach letzter Abfrage: 21.81 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 10.548 MB Zeilen zurückgegeben: 18
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qnm7x_modules AS m
LEFT JOIN qnm7x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qnm7x_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-03 22:09:06')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-03 22:09:06')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 251 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 6 Using where; filesort wurde genutzt 1 SIMPLE mm ref PRIMARY PRIMARY 4 2123396db37.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 2123396db37.m.module,const 1 Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.25 ms System lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.15 ms Sending data 0.28 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 14 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 13 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 12 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 11 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/helix3/core/helix3.php:512 10 Helix3::countModules() JROOT/plugins/system/helix3/core/helix3.php:459 9 Helix3::rowColumns() JROOT/plugins/system/helix3/core/helix3.php:268 8 Helix3::generatelayout() JROOT/templates/shaper_aspasia/index.php:158 7 require JROOT/templates/shaper_aspasia/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.04 ms Nach letzter Abfrage: 61.28 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 12.102 MB Zeilen zurückgegeben: 86
SELECT *
FROM qnm7x_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qnm7x_acymailing_config ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 86 Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.22 ms System lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:481 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:438 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:822 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:22 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:22 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:146 7 plgSystemRegacymailing->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:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
15 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `qnm7x_categories` AS `s`
INNER JOIN `qnm7x_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qnm7x_extensions`1 × SELECT `data`
FROM `qnm7x_session`1 × SELECT `session_id`
FROM `qnm7x_session`1 × SELECT id, rules
FROM `qnm7x_viewlevels1 × SELECT b.id
FROM qnm7x_usergroups AS a
LEFT JOIN qnm7x_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 qnm7x_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 qnm7x_menu AS m
LEFT JOIN qnm7x_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM qnm7x_languages1 × SELECT id, home, template, s.params
FROM qnm7x_template_styles as s
LEFT JOIN qnm7x_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_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,( SELECT COUNT(i.`id`)
FROM `qnm7x_contact_details` AS `i`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qnm7x_modules AS m
LEFT JOIN qnm7x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qnm7x_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM qnm7x_acymailing_confi
Andere Tabellen:
1 × INSERT INTO `qnm7x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('9vq6q0st0675iu7cjto716l2i4', 1, 1685830146, 0, '', 01 × UPDATE `qnm7x_extensions`
SET `params` = '{\"mediaversion\":\"873e6e84bf16a6ae0ad17d5db1713e48\"}'