Mit dem Wagen:
Autobahnausfahrt "Frankfurt Ost" und dann Hanauer Landstraße in Richtung "Zentrum" bis zu ihrem Beginn , dann rechts (Friedberger Anlage), wieder rechts (Pfingstweide) und nochmals rechts (Grüne Straße) bis zum Parkhaus "Zoo-Passage". Kurz vor der Einfahrt zum Parkhaus "Zoo-Passage" (1,8 m Zufahrtshöhe) befindet sich auch die Zufahrt zur Backstage des Theaters (3,2 m Zufahrtshöhe). Parkkosten: 2,- € die erste Stunde, danach 1,50 €/Stunde. 5,- € pauschal für die Zeit von 20.00 - 7:00.
Mit dem Zug:
Das Theater kann mit jeder S-Bahn aus dem gesamten Rhein-Main-Gebiet erreicht werden (idR ohne Umsteigen). An der Haltestelle "Ostendstrasse" aussteigen und über den Ausgang "Hanauer Landstrasse", nach den Rolltreppen links. Außen angekommen steht man direkt vor der Zoo-Passage, in der sich das Theater befindet.
Mit dem Flugzeug:
Vom Flughafen mit dem Vorortzug S 8 in Richtung Hanau bis zur Haltestelle "Ostendstrasse", dann Ausgang "Hanauer Landstrasse", nach den Rolltreppen links. Außen angekommen steht man direkt vor der Zoo-Passage, in der sich das Theater befindet.
Joomla!-Debug-Konsole
{ "__default": { "session": { "counter": 1, "timer": { "start": 1660528057, "last": 1660528057, "now": 1660528057 }, "token": "YhkvESFuRofeRvVJBD0Lujp0f6pG2F7N" }, "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
25 ausgeführte Abfragen 39.80 ms
- Abfragezeit: 0.74 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.867 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `td6ge_session`
WHERE `session_id` = X'3364663434386532613965313431643931616265663935646331653564363161'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.24 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.06 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Derselbe Aufruf in der Zeile darunter. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.81 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 3.962 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `td6ge_session`
WHERE `session_id` = X'3364663434386532613965313431643931616265663935646331653564363161'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 3.47 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.967 MB
INSERT INTO `td6ge_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3364663434386532613965313431643931616265663935646331653564363161', 1, 1660528057, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `td6ge_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3364663434386532613965313431643931616265663935646331653564363161', 1, 1660528057, 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.13 ms end 0.01 ms query end 3.01 ms closing tables 0.06 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 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:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.78 ms Nach letzter Abfrage: 1.82 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.248 MB Zeilen zurückgegeben: 38
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `td6ge_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 td6ge_extensions NULL ref extension extension 82 const 38 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.26 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Derselbe Aufruf in der Zeile darunter. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.60 ms Nach letzter Abfrage: 1.53 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.440 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `td6ge_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.452 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM td6ge_usergroups AS a
LEFT JOIN td6ge_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.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php: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.32 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.520 MB Zeilen zurückgegeben: 109
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM td6ge_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 td6ge_extensions NULL ref extension extension 82 const 130 0.60 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.76 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Derselbe Aufruf in der Zeile darunter. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.50 ms Nach letzter Abfrage: 28.70 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 9.418 MB Zeilen zurückgegeben: 44
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 td6ge_menu AS m
LEFT JOIN td6ge_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 range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 83 10.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dbs2981447.m.component_id 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.84 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/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: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:445 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:561 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:1169 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.57 ms Nach letzter Abfrage: 5.43 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.201 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `td6ge_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Derselbe Aufruf in der Zeile darunter. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 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: 3.83 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.192 MB
UPDATE `td6ge_extensions`
SET `params` = '{\"mediaversion\":\"643f421fb1c13866ea14edf04429ae91\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE td6ge_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.09 ms updating 0.11 ms end 0.01 ms query end 3.30 ms closing tables 0.05 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1131 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.46 ms Nach letzter Abfrage: 1.36 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 10.381 MB Zeilen zurückgegeben: 1
SELECT *
FROM td6ge_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/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.46 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 10.393 MB Zeilen zurückgegeben: 3
SELECT id, home, template, s.params
FROM td6ge_template_styles as s
LEFT JOIN td6ge_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 s NULL ALL idx_template,idx_client_id,idx_client_id_home ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 60.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 dbs2981447.s.template,const 1 4.47 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.25 ms Nach letzter Abfrage: 3.06 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.810 MB Zeilen zurückgegeben: 38
SELECT `id`,`name`,`rules`,`parent_id`
FROM `td6ge_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_baforms','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_tags','com_templates','com_users','com_vikevents','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_assets NULL ALL idx_asset_name ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 146 26.71 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.11 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.01 ms executing 0.00 ms Sending data 0.33 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.55 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 10.863 MB Zeilen zurückgegeben: 47
SELECT `id`,`name`,`rules`,`parent_id`
FROM `td6ge_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 td6ge_assets NULL ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 146 26.67 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php: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.36 ms Nach letzter Abfrage: 0.82 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 10.972 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `td6ge_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `td6ge_content`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.34 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.10 ms checking permissions 0.05 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.04 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.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.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.11 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 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:320 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: 4.19 ms Nach letzter Abfrage: 2.07 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 11.206 MB
UPDATE td6ge_content
SET `hits` = (`hits` + 1)
WHERE `id` = '11'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE td6ge_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.06 ms updating 0.14 ms end 0.02 ms query end 3.08 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1256 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: 1.50 ms Nach letzter Abfrage: 1.22 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.339 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 td6ge_content AS a
INNER JOIN td6ge_categories AS c
on c.id = a.catid
LEFT JOIN td6ge_users AS u
on u.id = a.created_by
LEFT JOIN td6ge_categories as parent
ON parent.id = c.parent_id
LEFT JOIN td6ge_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 11
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-15 01:47:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-15 01:47:37')
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.17 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.54 ms init 0.10 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.23 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.08 ms Nach letzter Abfrage: 1.24 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.518 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `td6ge_contentitem_tag_map` AS m
INNER JOIN `td6ge_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 11
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 dbs2981447.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.46 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php: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: 6.97 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 12.380 MB Zeilen zurückgegeben: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `td6ge_categories` AS `s`
INNER JOIN `td6ge_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 = 2
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 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 2 62.50 Using index condition; Using where Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.23 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:135 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:189 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: 2.07 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 12.424 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 td6ge_fields AS a
LEFT JOIN `td6ge_languages` AS l
ON l.lang_code = a.language
LEFT JOIN td6ge_users AS uc
ON uc.id=a.checked_out
LEFT JOIN td6ge_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN td6ge_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN td6ge_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `td6ge_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 (2,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 index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 dbs2981447.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 dbs2981447.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 dbs2981447.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 dbs2981447.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 dbs2981447.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 dbs2981447.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.12 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.37 ms preparing 0.06 ms Creating tmp table 0.08 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.36 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms removing tmp table 0.08 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php: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:189 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: 2.10 ms Nach letzter Abfrage: 3.25 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.828 MB Zeilen zurückgegeben: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM td6ge_modules AS m
LEFT JOIN td6ge_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN td6ge_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-08-15 01:47:37')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-15 01:47:37')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 146 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 21 1.96 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 dbs2981447.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 dbs2981447.m.id 2 40.00 Using where; Using index Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.53 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 17 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 16 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:37 15 Joomla\CMS\Helper\ModuleHelper::getModule() JROOT/plugins/content/loadmodule/loadmodule.php:200 14 PlgContentLoadmodule->_loadmod() JROOT/plugins/content/loadmodule/loadmodule.php:120 13 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.56 ms Nach letzter Abfrage: 55.00 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.997 MB Zeilen zurückgegeben: 1
SELECT manifest_cache
FROM td6ge_extensions
WHERE type='component'
AND element='com_baforms'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_baforms/helpers/baforms.php:675 10 baformsHelper::aboutUs() JROOT/components/com_baforms/helpers/baforms.php:573 9 baformsHelper::prepareHelper() JROOT/plugins/system/baforms/baforms.php:56 8 plgSystemBaforms->setForms() JROOT/plugins/system/baforms/baforms.php:35 7 plgSystemBaforms->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:1146 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: 2.46 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.004 MB Zeilen zurückgegeben: 1
SELECT `key`
FROM td6ge_baforms_api
WHERE service = 'balbooa_activation'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_baforms_api NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 25 10.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/components/com_baforms/helpers/baforms.php:660 10 baformsHelper::checkFormsActivation() JROOT/components/com_baforms/helpers/baforms.php:574 9 baformsHelper::prepareHelper() JROOT/plugins/system/baforms/baforms.php:56 8 plgSystemBaforms->setForms() JROOT/plugins/system/baforms/baforms.php:35 7 plgSystemBaforms->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:1146 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: 4.75 ms Nach letzter Abfrage: 4.04 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 15.552 MB Zeilen zurückgegeben: 144
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLESStatus Duration starting 0.07 ms checking permissions 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.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 1.21 ms Sending data 0.27 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 15 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 14 JDatabaseDriverMysqli->getTableList() JROOT/administrator/components/com_acymailing/compat/joomla.php:724 13 acymailing_getTableList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:18 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:536 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:1080 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:26 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:24 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:148 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:1146 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.26 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 15.578 MB Zeilen zurückgegeben: 189
SELECT *
FROM td6ge_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE td6ge_acymailing_config NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 188 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.03 ms executing 0.00 ms Sending data 0.84 ms end 0.03 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:628 13 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:23 12 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:536 11 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:1080 10 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:26 9 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/plugins/system/regacymailing/regacymailing.php:24 8 plgSystemRegacymailing->initAcy() JROOT/plugins/system/regacymailing/regacymailing.php:148 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:1146 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
23 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `td6ge_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `td6ge_extensions`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 td6ge_content AS a
INNER JOIN td6ge_categories AS c
on c.id = a.catid
LEFT JOIN td6ge_users AS u
on u.id = a.created_by
LEFT JOIN td6ge_categories as parent
ON parent.id = c.parent_id
LEFT JOIN td6ge_content_rating AS v
ON a.id = v.content_id1 × SELECT `key`
FROM td6ge_baforms_api1 × SELECT manifest_cache
FROM td6ge_extensions1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM td6ge_modules AS m
LEFT JOIN td6ge_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN td6ge_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 td6ge_fields AS a
LEFT JOIN `td6ge_languages` AS l
ON l.lang_code = a.language
LEFT JOIN td6ge_users AS uc
ON uc.id=a.checked_out
LEFT JOIN td6ge_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN td6ge_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN td6ge_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `td6ge_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `td6ge_categories` AS `s`
INNER JOIN `td6ge_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 `td6ge_contentitem_tag_map` AS m
INNER JOIN `td6ge_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `data`
FROM `td6ge_session`1 × SELECT `session_id`
FROM `td6ge_session`1 × SELECT id, home, template, s.params
FROM td6ge_template_styles as s
LEFT JOIN td6ge_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM td6ge_languages1 × 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 td6ge_menu AS m
LEFT JOIN td6ge_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM td6ge_extensions1 × SELECT b.id
FROM td6ge_usergroups AS a
LEFT JOIN td6ge_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `td6ge_viewlevels1 × SELECT *
FROM td6ge_acymailing_confi
Andere Tabellen:
1 × INSERT INTO `td6ge_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3364663434386532613965313431643931616265663935646331653564363161', 1, 1660528057, 0, '', 01 × UPDATE `td6ge_extensions`
SET `params` = '{\"mediaversion\":\"643f421fb1c13866ea14edf04429ae91\"}'1 × SHOW FULL COLUMNS
FROM `td6ge_content1 × UPDATE td6ge_content
SET `hits` = (`hits` + 1)1 × SHOW TABLE