Spielberich unserer 1. E-Jugend
1.FC Quickborn 1. E (A1) - SV Lurup 7:3
Tore: 1, FC Quickborn Joel Hamid (3), Ben Dreger (2), Cedric Perret (1), Jesper Klünder (1).
Zuschauer: ausverkauft!
Bei traumhaften Wetterverhältnissen, ausverkaufter Arena und mit leichter Verspätung des Gegners begann die Partie des 1. FC Quickborn gegen den SV Lurup um 13:15 Uhr.
Die Mannschaft des 1. FC Quickborn trat im Vergleich zum Pokalspiel mit leicht veränderter Konstellation an.
Der etatmäßige Abwehrchef, Jesper Klünder war wieder an Bord und kehrte sofort wieder ins Team zurück.
Und als ob er seinen Trainern noch etwas beweisen müsste, dirigierte Jesper Klünder das Spiel seiner Mannschaft aus einer geschlossenen sehr gut organisierten Dreier-Kette von hinten heraus.
So blieb es ihm auch zunächst überlassen, die 1:0 Führung herbeizuführen, womit er seine persönliche Leistung endgültig krönte.
Zuvor scheiterten bereits in der Anfangsphase das eine und andere Mal sowohl Ben Dreger, Joel Hamid und Jesper Klünder nicht etwa an dem gegnerischen Torwart, sondern lediglich an der Präzision ihrer Torschüsse, die mehrfach den Außenpfosten des Tores vom SV Lurup streiften.
Erst nach dem Führungstreffer durch Jesper Klünder kam die notwendige Genauigkeit in das Spiel zurück, so dass folgerichtig die Führung schnell auf 3:0 nach oben korrigiert wurde.
Die unwahrscheinliche Präsenz auf dem Platz, das schnelle Umschalten; das intensive Pressing bereits ab der Mittellinie, lies den SV Lurup kaum Luft zum Atmen.
Die offensive Spielweise und der schön anzusehende Kombinationsfußball über viele Stafetten begeisterte nun auch die immer lautstärker unterstützende Südkurve in der zum Bersten gefüllten Ziegenwegarena.
Die Mannschaft bedankte sich beim treuen Publikum durch Tore von Ben Dreger und Joel Hamid zum 4:1 Pausenstand, die wieder einmal ihre Klasse eindrucksvoll unter Beweis stellten.
Für den Trainer galt es nun, die Spannung der Mannschaft der ersten Hälfte mit in die zweiten 25 Minuten zu transportieren. Die Kabinenansprache hatte sichtbaren Erfolg. Die Mannschaft hielt Ihr Konzept diszipliniert bei, sah sich jedoch nun einem robuster entgegenstehenden Gegner gegenüber.
Unter dem Eindruck, dem 1.FC Quickborn spielerisch nicht mehr das Wasser reichen zu können, wurde das Spiel des SV Lurup mit zunehmendem Spiel härter und leider phasenweise auch unsportlicher in den Zweikämpfen.
Dass sich das Team um Kapitän Hauke Baumann ob der robusteren Gangart des SV Lurup dennoch nicht beeindrucken ließ, zeugt von Klasse und Selbstvertrauen.
Die Abwehr um Sven Klünder, Hauke Baumann, Yannic Häring und Bjarne Voigt luden ihre Gegenspieler weder körperlich noch spielerisch ein, das Spiel wenden zu können. Mehrfach stellten sie sich den vereinzelten Angriffen massiv entgegen und überzeugten durch gutes Stellungsspiel.
Die Anschlusstreffer fielen dann auch lediglich durch Standards und kleine Unaufmerksamkeiten..
Die Südkurve bebte inzwischen und peitschte das Team immer weiter nach vorne.
Dies hatte die notwendige Konsequenz zur Folge, dass weitere Tore nicht lange auf sich warten ließen.
Der gut leitende Schiedsrichter hatte in jeder Phase das Spiel unter Kontrolle.
Selbst in einer Situation, in der ihm keine andere Wahl blieb als einen Spieler des SV Lurup des Feldes auf Zeit zu verweisen, behielt er Ruhe und korrigierte eine falsche Elfmeterentscheidung.
Joel Hamid wurde in diesem Zweikampf, auf den der Feldverweis ausgesprochen wurde, nicht regelkonform an der Toraußenlinie attackiert und musste verletzt das Spiel verlassen.
Zuvor jedoch demonstrierte das Trio um Cedric Perret, Joel Hamid und Ben Dreger in der Offensive faszinierenden Kombinationsfußball, ständig unterstützt von den Flankenläufen des Kapitäns.
Wer nach dem verletzungsbedingten Ausfall von Joel Hamid nun dachte, der Einwechselspieler, Henning Welge, würde die Lücke nicht schließen können, sah sich aus der Sicht des SV Lurup leider getäuscht.
Henning Welge frustrierte ein ums andere Mal die linke Außenseite des SV Lurup durch beherzten Einsatz.
Leider konnte er zum Schluss seine tolle Leistung nicht mehr mit einem Tor krönen, weil im letzten Moment der Torhüter des SV Lurup seinen Schuss parieren konnte.
Bleibt noch zu erwähnen, dass Hannes Schubel wieder einmal ein glänzender Rückhalt war, der seine Vorderleute stets beruhigen konnte. Sein Stellungsspiel war ausnahmslos gut.
Nach dem Abpfiff badete die Mannschaft noch in dem Jubel der aufgeheizten Südkurve und wurde verdientermaßen mit Standig Ovation verabschiedet.
Die unnötige Frage eines Reportes an den Trainer Matthias Bagger, ob er enttäuscht wegen der drei Gegentore sei, wurde folgendermaßen beantwortet.
„ Wir gewinnen lieber 7:3 als 1:0. Außerdem leben und spielen wir offensiven Fußball, der auch zur Folge hat, dass man Tore kassiert….“
Der Rest der Antwort ging im Jubel unter ….fast unter…
„ Den Fußball von gestern muss man respektieren, den Fußball von heute studieren und den Fußball von morgen antizipieren….“
Joomla!-Debug-Konsole
{ "__default": { "session": { "counter": 1, "timer": { "start": 1714002650, "last": 1714002650, "now": 1714002650 } }, "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
22 ausgeführte Abfragen 43.60 ms
- Abfragezeit: 0.57 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.348 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `hlac5_session`
WHERE `session_id` = X'6566316230313331316433303933393832653230356533323264383435313434'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.58 ms Nach letzter Abfrage: 2.53 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.425 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `hlac5_session`
WHERE `session_id` = X'6566316230313331316433303933393832653230356533323264383435313434'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 14.74 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.430 MB
INSERT INTO `hlac5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6566316230313331316433303933393832653230356533323264383435313434', 1, 1714002650, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `hlac5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6566316230313331316433303933393832653230356533323264383435313434', 1, 1714002650, 0, '', 0)Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms update 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 14.35 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 1.00 ms Nach letzter Abfrage: 3.78 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 1.462 MB Zeilen zurückgegeben: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hlac5_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref extension extension 82 const 45 1.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.13 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.60 ms Nach letzter Abfrage: 3.71 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.501 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `hlac5_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 100.00 NULL Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.513 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM hlac5_usergroups AS a
LEFT JOIN hlac5_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.15 ms Nach letzter Abfrage: 1.52 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.534 MB Zeilen zurückgegeben: 95
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM hlac5_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref extension extension 82 const 147 0.60 Using where; filesort wurde genutzt Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.43 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.35 ms Nach letzter Abfrage: 38.75 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 2.042 MB Zeilen zurückgegeben: 20
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM hlac5_menu AS m
LEFT JOIN hlac5_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 223 5.61 Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.m.component_id 1 100.00 Using where Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms executing 0.35 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.67 ms Nach letzter Abfrage: 18.16 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.333 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hlac5_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 6.22 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.323 MB
UPDATE `hlac5_extensions`
SET `params` = '{\"mediaversion\":\"e25fb7c7006d8d171242a73de4094f53\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'„EXPLAIN“ unmöglich für Abfrage: UPDATE `hlac5_extensions` SET `params` = '{\"mediaversion\":\"e25fb7c7006d8d171242a73de4094f53\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.04 ms updating 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 5.78 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.65 ms Nach letzter Abfrage: 3.24 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.355 MB Zeilen zurückgegeben: 2
SELECT *
FROM hlac5_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_languages NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 50.00 Using where; filesort wurde genutzt Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.78 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.367 MB Zeilen zurückgegeben: 9
SELECT id, home, template, s.params
FROM hlac5_template_styles as s
LEFT JOIN hlac5_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 11 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 fcquickbor5.e.element 1 81.82 Using index condition; Using where Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.09 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.02 ms Nach letzter Abfrage: 7.35 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.522 MB Zeilen zurückgegeben: 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `hlac5_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_cbjuice2','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_joomsport','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mp','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_assets NULL range idx_asset_name idx_asset_name 202 NULL 45 100.00 Using index condition Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.28 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.04 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.075 MB Speichernutzung vor Abfrage: 2.577 MB Zeilen zurückgegeben: 252
SELECT `id`,`name`,`rules`,`parent_id`
FROM `hlac5_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE hlac5_assets NULL ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 466 24.21 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.29 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 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.90 ms Nach letzter Abfrage: 2.18 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 2.870 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `hlac5_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `hlac5_content`Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.39 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.18 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.03 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.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.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.09 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.03 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 5.01 ms Nach letzter Abfrage: 5.89 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.920 MB
UPDATE hlac5_content
SET `hits` = (`hits` + 1)
WHERE `id` = '51'„EXPLAIN“ unmöglich für Abfrage: UPDATE hlac5_content SET `hits` = (`hits` + 1) WHERE `id` = '51'Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.06 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 4.40 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.94 ms Nach letzter Abfrage: 3.39 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.009 MB Zeilen zurückgegeben: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM hlac5_content AS a
INNER JOIN hlac5_categories AS c
on c.id = a.catid
LEFT JOIN hlac5_users AS u
on u.id = a.created_by
LEFT JOIN hlac5_categories as parent
ON parent.id = c.parent_id
LEFT JOIN hlac5_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 51
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-24 23:50:50')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 23:50:50')
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.11 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.90 ms Nach letzter Abfrage: 4.99 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.060 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 `hlac5_categories` AS `s`
INNER JOIN `hlac5_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 8
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 8 44.00 Using index condition; Using where Status Duration starting 0.15 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.72 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.086 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `hlac5_contentitem_tag_map` AS m
INNER JOIN `hlac5_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 51
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 fcquickbor5.m.tag_id 1 100.00 Using where Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.19 ms Nach letzter Abfrage: 30.24 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.367 MB Zeilen zurückgegeben: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM hlac5_fields AS a
LEFT JOIN `hlac5_languages` AS l
ON l.lang_code = a.language
LEFT JOIN hlac5_users AS uc
ON uc.id=a.checked_out
LEFT JOIN hlac5_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN hlac5_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN hlac5_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `hlac5_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 fcquickbor5.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 fcquickbor5.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 fcquickbor5.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.15 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.06 ms executing 0.20 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.04 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.93 ms Nach letzter Abfrage: 7.72 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.471 MB Zeilen zurückgegeben: 1
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM hlac5_content AS a
LEFT JOIN hlac5_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 8
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-24 23:50:50')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-24 23:50:50')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 1 16.00 Using intersect(idx_catid,idx_state); Using where; filesort wurde genutzt 1 SIMPLE cc NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.15 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.12 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:161 13 PlgContentPagenavigation->onContentBeforeDisplay() 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:199 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: 21.65 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.649 MB Zeilen zurückgegeben: 3
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM hlac5_modules AS m
LEFT JOIN hlac5_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN hlac5_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-24 23:50:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-24 23:50:50')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 109 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 12 1.60 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 fcquickbor5.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 fcquickbor5.m.id 1 40.00 Using where; Using index Status Duration starting 0.13 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.09 ms preparing 0.04 ms executing 0.19 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:37 10 Joomla\CMS\Helper\ModuleHelper::getModule() JROOT/templates/at_robseco/includes/globals.php:9 9 include JROOT/templates/at_robseco/includes/globals.php JROOT/templates/at_robseco/includes/header.php:8 8 require_once JROOT/templates/at_robseco/includes/header.php JROOT/templates/at_robseco/index.php:29 7 require JROOT/templates/at_robseco/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
20 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hlac5_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `hlac5_assets`1 × SELECT `data`
FROM `hlac5_session`1 × SELECT `session_id`
FROM `hlac5_session`1 × SELECT id, rules
FROM `hlac5_viewlevels1 × SELECT b.id
FROM hlac5_usergroups AS a
LEFT JOIN hlac5_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM hlac5_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM hlac5_menu AS m
LEFT JOIN hlac5_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM hlac5_languages1 × SELECT id, home, template, s.params
FROM hlac5_template_styles as s
LEFT JOIN hlac5_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM hlac5_content AS a
INNER JOIN hlac5_categories AS c
on c.id = a.catid
LEFT JOIN hlac5_users AS u
on u.id = a.created_by
LEFT JOIN hlac5_categories as parent
ON parent.id = c.parent_id
LEFT JOIN hlac5_content_rating AS v
ON a.id = v.content_id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `hlac5_categories` AS `s`
INNER JOIN `hlac5_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `m`.`tag_id`,`t`.*
FROM `hlac5_contentitem_tag_map` AS m
INNER JOIN `hlac5_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM hlac5_fields AS a
LEFT JOIN `hlac5_languages` AS l
ON l.lang_code = a.language
LEFT JOIN hlac5_users AS uc
ON uc.id=a.checked_out
LEFT JOIN hlac5_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN hlac5_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN hlac5_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `hlac5_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM hlac5_content AS a
LEFT JOIN hlac5_categories AS cc
ON cc.id = a.catid1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM hlac5_modules AS m
LEFT JOIN hlac5_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN hlac5_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Andere Tabellen:
1 × INSERT INTO `hlac5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6566316230313331316433303933393832653230356533323264383435313434', 1, 1714002650, 0, '', 01 × UPDATE `hlac5_extensions`
SET `params` = '{\"mediaversion\":\"e25fb7c7006d8d171242a73de4094f53\"}'1 × SHOW FULL COLUMNS
FROM `hlac5_content1 × UPDATE hlac5_content
SET `hits` = (`hits` + 1)
Joomla!-Debug-Konsole
Sitzung
Profil zum Laufzeitverhalten
Zeit
Speicher
Speichernutzung
Datenbankabfragen
22 ausgeführte Abfragen 43.60 ms
20 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
Andere Tabellen: