Full Force bestätigt Bury Tomorrow
- Details
- Veröffentlicht: Mittwoch, 04. Mai 2022 11:07
Das Full Force holt die Briten von Bury Tomorrow an Bord. Wie wir finden eine tolle Ergänzung zum Line-up.
Außerdem wollen wir euch den Festival-Teaser ans Herz legen. Der wärmt euch schon mal vor. Und in unserem Vorbericht erzählen wir euch was ihr sonst noch wissen müsst.
Full Force - Keine Einschränkungen und 4 neue Bands!
- Details
- Veröffentlicht: Mittwoch, 27. April 2022 23:04
Die Veranstalter des Force haben sich mal wieder zu Wort gemeldet und den Elefanten im Raum angesprochen, der hört leider immer noch auf den Namen Corona. Aber dieses Jahr wird es KEINERLEI Einschränkungen auf dem Full Force geben. Alles wird also wie vor der Pandemie ablaufen. Wir drücken die Daumen, dass das alles so klappt.
Außerdem gab es 4 neue Ankündigungen: BLACKOUT PROBLEMS, GHØSTKID, INFECTED RAIN, PALEFACE
FF: Amon Amarth als finaler Headliner bestätigt
- Details
- Veröffentlicht: Sonntag, 15. Dezember 2019 15:26
Ein vorzeitiges Weihnachtsgeschenk hat das Full Force allen Fans des Viking Metal beschert: Als dritter Headliner wurden nun Amon Amarth angekündigt. Damit ist das Trio vollständig und wir dürfen uns auf The Ghost Inside, Heaven Shall Burn und Amon Amarth freuen.
Full Force - Die Party steigt 2022 und Neuzugänge!
- Details
- Veröffentlicht: Dienstag, 15. März 2022 20:23
Neues vom Full Force Festival. Nach langer Coronapause versichern die Veranstalter: die Party steigt dieses Jahr!
Außerdem gibt es einige Neuzugänge, darunter Comeback Kid, Suicide Silence und Rolo Tomassi. Leider haben auch ein paar Kracher abgesagt, unter anderem Killswitch Engage und Of Mice & Men. Lest weiter für alle Zu- und Abgänge.
Full Force: 15 neue Ankündigungen - Killswitch Engage, Meshuggah, Boysetsfire
- Details
- Veröffentlicht: Sonntag, 01. Dezember 2019 16:30
Das Full Force hat die nächste große Bandwelle rausgehauen, 15 neue Ankündigungen mit einigen richtigen Highlights. Hier ist die gesamte Liste:
August Burns Red, Being As An Ocean, Boysetsfire, Counterparts, Emil Bulls, Gatecreeper, Killswitch Engage, Kvelertak, Meshuggah, Nasty, Neck Deep, Obituary, Of Mice & Men, Thy Art Is Murder, ZSK
Joomla!-Debug-Konsole
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1679893862,
"last": 1679893862,
"now": 1679893862
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Zeit
Speicher
Zeit: 12.89 ms / 12.89 ms Speicher: 2.022 MB / 2.39 MB Application: afterLoad
Zeit: 353.64 ms / 366.53 ms Speicher: 3.995 MB / 6.38 MB Application: afterInitialise
Zeit: 12.32 ms / 378.84 ms Speicher: 0.964 MB / 7.35 MB Application: afterRoute
Zeit: 7.36 ms / 386.21 ms Speicher: 0.247 MB / 7.60 MB Application: beforeRenderComponent com_content
Zeit: 5.69 ms / 391.90 ms Speicher: 0.684 MB / 8.28 MB Application: Before Access::preloadComponents (all components)
Zeit: 1.46 ms / 393.36 ms Speicher: 0.057 MB / 8.34 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 393.38 ms Speicher: -0.004 MB / 8.33 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 2.98 ms / 396.36 ms Speicher: 0.735 MB / 9.07 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.04 ms / 396.40 ms Speicher: -0.034 MB / 9.03 MB Application: Before Access::getAssetRules (id:952 name:com_content.category.73)
Zeit: 0.35 ms / 396.75 ms Speicher: 0.027 MB / 9.06 MB Application: After Access::getAssetRules (id:952 name:com_content.category.73)
Zeit: 5.18 ms / 401.94 ms Speicher: 0.283 MB / 9.34 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.04 ms / 401.98 ms Speicher: 0.007 MB / 9.35 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 59.91 ms / 461.89 ms Speicher: 2.012 MB / 11.36 MB Application: afterRenderComponent com_content
Zeit: 0.24 ms / 462.14 ms Speicher: 0.005 MB / 11.37 MB Application: afterDispatch
Zeit: 4.11 ms / 466.24 ms Speicher: 0.171 MB / 11.54 MB Application: beforeRenderModule mod_footer (Copyright)
Zeit: 0.63 ms / 466.87 ms Speicher: 0.039 MB / 11.58 MB Application: afterRenderModule mod_footer (Copyright)
Zeit: 0.05 ms / 466.92 ms Speicher: -0.000 MB / 11.58 MB Application: beforeRenderModule mod_search (Suche)
Zeit: 0.62 ms / 467.54 ms Speicher: 0.020 MB / 11.60 MB Application: afterRenderModule mod_search (Suche)
Zeit: 0.02 ms / 467.57 ms Speicher: -0.005 MB / 11.59 MB Application: beforeRenderModule mod_menu (Über uns)
Zeit: 1.44 ms / 469.01 ms Speicher: 0.079 MB / 11.67 MB Application: afterRenderModule mod_menu (Über uns)
Zeit: 0.03 ms / 469.04 ms Speicher: 0.000 MB / 11.67 MB Application: beforeRenderModule mod_banners (Links)
Zeit: 7.50 ms / 476.53 ms Speicher: 0.131 MB / 11.80 MB Application: afterRenderModule mod_banners (Links)
Zeit: 0.07 ms / 476.60 ms Speicher: -0.013 MB / 11.79 MB Application: beforeRenderModule mod_menu (Main Menu)
Zeit: 4.51 ms / 481.11 ms Speicher: 0.257 MB / 12.05 MB Application: afterRenderModule mod_menu (Main Menu)
Zeit: 0.07 ms / 481.18 ms Speicher: -0.005 MB / 12.04 MB Application: beforeRenderModule mod_custom (Logo)
Zeit: 3.03 ms / 484.21 ms Speicher: 0.021 MB / 12.06 MB Application: afterRenderModule mod_custom (Logo)
Zeit: 1.35 ms / 485.55 ms Speicher: 0.109 MB / 12.17 MB Application: afterRender
Datenbankabfragen gesamt: 63.75 ms
12,60 MB (13.214.440 Bytes)
36 ausgeführte Abfragen 63.75 ms
- Abfragezeit: 0.76 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.163 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = X'3661353031646233666461356364616131343264383233353663303332643434'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.03 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: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.43 ms Nach letzter Abfrage: 2.28 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.259 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = X'3661353031646233666461356364616131343264383233353663303332643434'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.06 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.03 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 3.02 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.264 MB
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3661353031646233666461356364616131343264383233353663303332643434', 1, 1679893862, 0, '', 0)„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3661353031646233666461356364616131343264383233353663303332643434', 1, 1679893862, 0, '', 0)Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.17 ms end 0.01 ms query end 2.47 ms closing tables 0.03 ms freeing items 0.03 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:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.81 ms Nach letzter Abfrage: 2.14 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.514 MB Zeilen zurückgegeben: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_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 jos_extensions NULL ref extension extension 82 const 39 1.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.20 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: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.49 ms Nach letzter Abfrage: 1.96 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.703 MB Zeilen zurückgegeben: 3
SELECT id, rules
FROM `jos_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 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.55 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.714 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 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.10 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.03 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.04 ms Nach letzter Abfrage: 0.58 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.783 MB Zeilen zurückgegeben: 81
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions NULL ref extension extension 82 const 108 0.43 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.10 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.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.52 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 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.90 ms Nach letzter Abfrage: 315.38 ms Abfragespeichernutzung: 0.088 MB Speichernutzung vor Abfrage: 6.633 MB Zeilen zurückgegeben: 41
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 jos_menu AS m
LEFT JOIN jos_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 72 10.00 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 db560257200.m.component_id 1 100.00 Using where Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.75 ms end 0.05 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.03 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: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.73 ms Nach letzter Abfrage: 8.35 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 7.384 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.12 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 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: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: 2.93 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.375 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"496bb2fa54f0fcb624fbcbb72bdb9d58\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos_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.06 ms updating 0.09 ms end 0.01 ms query end 2.44 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.55 ms Nach letzter Abfrage: 1.63 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 7.557 MB Zeilen zurückgegeben: 2
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_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.10 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 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 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.60 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.575 MB Zeilen zurückgegeben: 1
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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 ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 1 100.00 NULL 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 db560257200.s.template,const 1 4.50 Using index condition; Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 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.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.29 ms Nach letzter Abfrage: 5.96 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 8.284 MB Zeilen zurückgegeben: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocafavicon','com_plugins','com_podcastmanager','com_podcastmedia','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 jos_assets NULL range idx_asset_name idx_asset_name 202 NULL 40 100.00 Using index condition Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.10 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.48 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.80 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.166 MB Speichernutzung vor Abfrage: 8.334 MB Zeilen zurückgegeben: 969
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_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 jos_assets NULL ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1030 21.11 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.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 1.42 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.68 ms Nach letzter Abfrage: 2.33 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.106 MB Zeilen zurückgegeben: 4
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 `jos_categories` AS `s`
INNER JOIN `jos_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.published = 1
AND s.id = 73
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 79 67.68 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 1.71 ms end 0.04 ms query end 0.02 ms closing tables 0.05 ms freeing items 0.07 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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: 18.37 ms Nach letzter Abfrage: 1.80 ms Abfragespeichernutzung: 0.064 MB Speichernutzung vor Abfrage: 9.347 MB Zeilen zurückgegeben: 9
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 73 OR a.catid IN ( SELECT sub.id
FROM jos_categories as sub
INNER JOIN jos_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 73))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 05:11:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 05:11:02')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c NULL ALL PRIMARY,idx_access ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 79 10.00 Using where; Using temporary; filesort wurde genutzt 1 PRIMARY a NULL ref idx_access,idx_state,idx_catid idx_catid 4 db560257200.c.id 17 16.00 Using index condition; Using where 1 PRIMARY ua NULL ALL PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 4 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.modified_by 1 100.00 Using where 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 db560257200.c.parent_id 1 100.00 Using where 1 PRIMARY v NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.id 1 100.00 Using where 2 SUBQUERY this NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 2 SUBQUERY sub NULL range PRIMARY,idx_left_right idx_left_right 4 NULL 15 33.33 Using where; Using index Status Duration starting 1.17 ms checking permissions 0.03 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 Opening tables 0.49 ms init 0.25 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.24 ms preparing 3.31 ms Creating tmp table 0.30 ms Sorting result 0.03 ms optimizing 0.03 ms statistics 0.25 ms preparing 0.06 ms executing 0.01 ms Sending data 0.39 ms executing 0.02 ms Sending data 10.09 ms Creating sort index 0.54 ms end 0.04 ms query end 0.07 ms removing tmp table 0.25 ms query end 0.03 ms closing tables 0.07 ms freeing items 0.05 ms removing tmp table 0.01 ms freeing items 0.09 ms cleaning up 0.05 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.45 ms Nach letzter Abfrage: 1.79 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.561 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 897
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.23 ms init 0.09 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.09 ms executing 0.01 ms Sending data 0.12 ms end 0.01 ms query end 0.02 ms closing tables 0.04 ms freeing items 0.07 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.579 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 891
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.06 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.94 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.597 MB Zeilen zurückgegeben: 3
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 887
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.20 ms end 0.01 ms query end 0.04 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.81 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.621 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 873
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.04 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.54 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.638 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 877
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.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.02 ms init 0.05 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.05 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.52 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.656 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 874
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 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.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.51 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.673 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 876
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 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.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.47 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.691 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 875
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 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.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.46 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.708 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 859
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 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.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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: 5.58 ms Nach letzter Abfrage: 1.10 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.799 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 73 OR a.catid IN ( SELECT sub.id
FROM jos_categories as sub
INNER JOIN jos_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 73))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 05:11:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 05:11:02')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c NULL ALL PRIMARY,idx_access ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 79 10.00 Using where 1 PRIMARY a NULL ref idx_access,idx_state,idx_catid idx_catid 4 db560257200.c.id 17 16.00 Using index condition; Using where 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.created_by 1 100.00 Using where; Using index 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.modified_by 1 100.00 Using where; Using index 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 db560257200.c.parent_id 1 100.00 Using where; Using index 1 PRIMARY v NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.id 1 100.00 Using where; Using index 2 SUBQUERY this NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 2 SUBQUERY sub NULL range PRIMARY,idx_left_right idx_left_right 4 NULL 15 33.33 Using where; Using index Status Duration starting 0.11 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 Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.05 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.26 ms executing 0.01 ms Sending data 4.35 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.02 ms removing tmp table 0.01 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.44 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.800 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 73
AND `t`.`published` = 1
AND t.access IN (1,1)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 10 10.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 db560257200.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->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.69 ms Nach letzter Abfrage: 5.39 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.212 MB Zeilen zurückgegeben: 4
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 `jos_categories` AS `s`
INNER JOIN `jos_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)
AND c.published = 1
AND s.id = 73
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 79 67.68 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->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.17 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 10.238 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_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 (73,0,32,9))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 db560257200.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 db560257200.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.09 ms checking permissions 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 Opening tables 0.17 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.23 ms Creating sort index 0.03 ms end 0.01 ms query end 0.03 ms removing tmp table 0.06 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/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/category/view.html.php:113 10 ContentViewCategory->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.15 ms Nach letzter Abfrage: 9.09 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 11.134 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 db560257200.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.group_id 1 100.00 Using where Status Duration starting 0.12 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 checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.03 ms executing 0.01 ms Sending data 0.23 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 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 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->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.02 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 11.148 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (73,0,32,9))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 db560257200.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 db560257200.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.12 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 Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.19 ms Creating sort index 0.02 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->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.46 ms Nach letzter Abfrage: 7.43 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.611 MB Zeilen zurückgegeben: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-27 05:11:02')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-27 05:11:02')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 219 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 6 NULL 7 2.86 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 db560257200.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 db560257200.m.id 2 40.00 Using where; Using index Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.07 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Derselbe Aufruf in der Zeile darunter. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/joomspirit_99/index.php:223 7 require JROOT/templates/joomspirit_99/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 0.77 ms Nach letzter Abfrage: 4.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.726 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos_banners
WHERE '2023-03-27 05:11:02' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.12 ms init 0.07 ms System lock 0.02 ms optimizing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 1.18 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.789 MB Zeilen zurückgegeben: 6
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 05:11:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 05:11:02')
AND (a.imptotal = 0 OR a.impmade < a.imptotal)
AND a.catid IN (3)
ORDER BY a.sticky DESC,a.ordering
LIMIT 6id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_banner_catid idx_state 1 const 6 8.33 Using index condition; Using where; filesort wurde genutzt 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.cid 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.31 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.03 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_banners/models/banners.php:222 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:48 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 3.48 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 11.811 MB
UPDATE jos_banners
SET impmade = (impmade + 1)
WHERE id IN (1,2,4,3,9,10)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos_banners NULL index PRIMARY PRIMARY 4 NULL 12 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.07 ms updating 0.37 ms end 0.03 ms query end 2.60 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.02 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:268 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:54 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Abfragezeit: 2.31 ms Nach letzter Abfrage: 5.85 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 12.074 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 db560257200.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 db560257200.a.group_id 1 100.00 Using where Status Duration starting 0.24 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 Opening tables 0.05 ms init 0.11 ms System lock 0.02 ms optimizing 0.04 ms statistics 0.28 ms preparing 0.07 ms Creating tmp table 0.09 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.49 ms Creating sort index 0.05 ms end 0.01 ms query end 0.02 ms removing tmp table 0.18 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.08 ms cleaning up 0.04 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() Derselbe Aufruf in der Zeile darunter. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
22 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
10 × SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`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 `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id2 × 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 jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id1 × SELECT `data`
FROM `jos_session`1 × SELECT `session_id`
FROM `jos_session`1 × SELECT id, rules
FROM `jos_viewlevels1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_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 jos_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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM jos_languages1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id1 × SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM jos_banners1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
Andere Tabellen:
1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3661353031646233666461356364616131343264383233353663303332643434', 1, 1679893862, 0, '', 01 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"496bb2fa54f0fcb624fbcbb72bdb9d58\"}'1 × UPDATE jos_banners
SET impmade = (impmade + 1)