Abfragezeit: 1.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.035 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `joszo_session`
WHERE `session_id` = X'6333326135323638636233396233396235643733633439373536303861383661'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.30 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| init | 0.06 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.11 ms |
| executing | 0.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.05 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.06 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Derselbe Aufruf in der Zeile darunter. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php: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.66 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.049 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `joszo_session`
WHERE `session_id` = X'6333326135323638636233396233396235643733633439373536303861383661'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.16 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.03 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.77 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.055 MB
INSERT INTO `joszo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6333326135323638636233396233396235643733633439373536303861383661', 1, 1701790768, 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `joszo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6333326135323638636233396233396235643733633439373536303861383661', 1, 1701790768, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| update | 0.31 ms |
| end | 0.02 ms |
| query end | 2.93 ms |
| closing tables | 0.03 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.03 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: 1.08 ms Nach letzter Abfrage: 1.02 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.086 MB Zeilen zurückgegeben: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joszo_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | NULL | ref | extension | extension | 82 | const | 41 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.33 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.03 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.59 ms Nach letzter Abfrage: 1.26 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.117 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `joszo_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_viewlevels | NULL | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.02 ms |
| System lock | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.04 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.07 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.90 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.128 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM joszo_usergroups AS a
LEFT JOIN joszo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.18 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.18 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.05 ms |
| freeing items | 0.14 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: 2.29 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.150 MB Zeilen zurückgegeben: 104
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joszo_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | NULL | ref | extension | extension | 82 | const | 129 | 0.60 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.19 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| executing | 0.03 ms |
| Sending data | 0.03 ms |
| Creating sort index | 1.46 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.23 ms Nach letzter Abfrage: 6.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.583 MB Zeilen zurückgegeben: 2
SELECT *
FROM joszo_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_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.28 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.06 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.20 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 8 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:96 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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.79 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.593 MB Zeilen zurückgegeben: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joszo_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | NULL | ref | extension | extension | 82 | const | 4 | 1.25 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.02 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.15 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
| 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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.06 ms Nach letzter Abfrage: 4.60 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.660 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joszo_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.25 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.04 ms |
| statistics | 0.15 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.08 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 21 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 20 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 19 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 18 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 17 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 16 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 15 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 14 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 13 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 12 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/eorisis_cookiebar/framework/lib/joomla/doc.php:38 |
| 11 | eorisis\cookiebar\joomla\doc->get() | JROOT/plugins/system/eorisis_cookiebar/framework/lib/joomla/doc.php:48 |
| 10 | eorisis\cookiebar\joomla\doc->type() | JROOT/plugins/system/eorisis_cookiebar/framework/lib/joomla/doc.php:78 |
| 9 | eorisis\cookiebar\joomla\doc->is_html() | JROOT/plugins/system/eorisis_cookiebar/eorisis_cookiebar.php:67 |
| 8 | plgSystemEorisis_cookiebar->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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: 4.94 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 1.654 MB
UPDATE `joszo_extensions`
SET `params` = '{\"mediaversion\":\"27434fbbfe7360f13a2c89bf594335bb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | joszo_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.21 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.04 ms |
| System lock | 0.11 ms |
| updating | 0.20 ms |
| end | 0.05 ms |
| query end | 3.90 ms |
| closing tables | 0.05 ms |
| freeing items | 0.18 ms |
| cleaning up | 0.04 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 16 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 15 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 14 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 13 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 12 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/eorisis_cookiebar/framework/lib/joomla/doc.php:38 |
| 11 | eorisis\cookiebar\joomla\doc->get() | JROOT/plugins/system/eorisis_cookiebar/framework/lib/joomla/doc.php:48 |
| 10 | eorisis\cookiebar\joomla\doc->type() | JROOT/plugins/system/eorisis_cookiebar/framework/lib/joomla/doc.php:78 |
| 9 | eorisis\cookiebar\joomla\doc->is_html() | JROOT/plugins/system/eorisis_cookiebar/eorisis_cookiebar.php:67 |
| 8 | plgSystemEorisis_cookiebar->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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: 3.58 ms Nach letzter Abfrage: 3.50 ms Abfragespeichernutzung: 0.278 MB Speichernutzung vor Abfrage: 1.706 MB Zeilen zurückgegeben: 152
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 joszo_menu AS m
LEFT JOIN joszo_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.lft
| id | 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 | 159 | 10.00 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.33 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.12 ms |
| init | 0.09 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.15 ms |
| preparing | 0.05 ms |
| Sorting result | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 2.23 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.07 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.05 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Derselbe Aufruf in der Zeile darunter. |
| 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
| 8 | PlgSystemLanguageFilter->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 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: 3.02 ms Nach letzter Abfrage: 10.58 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.771 MB Zeilen zurückgegeben: 4
SELECT id, home, template, s.params
FROM joszo_template_styles as s
LEFT JOIN joszo_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 = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 6 | 1.00 | Using index condition; Using where |
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | agency_jooml45.e.element | 1 | 66.67 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.45 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.08 ms |
| init | 0.12 ms |
| System lock | 0.03 ms |
| optimizing | 0.11 ms |
| statistics | 0.24 ms |
| preparing | 0.08 ms |
| executing | 0.02 ms |
| Sending data | 0.27 ms |
| end | 0.03 ms |
| query end | 0.04 ms |
| closing tables | 0.03 ms |
| freeing items | 1.31 ms |
| cleaning up | 0.08 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.79 ms Nach letzter Abfrage: 3.69 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.923 MB Zeilen zurückgegeben: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `joszo_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_droptables','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nge','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_simplefilemanager','com_tags','com_templates','com_users','com_wrapper','com_xmap')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 41 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.22 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.09 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.27 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.69 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.12 ms |
| cleaning up | 0.05 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 18 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 16 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 15 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/articles.php:115 |
| 14 | ContentModelArticles->populateState() | JROOT/components/com_content/models/featured.php:45 |
| 13 | ContentModelFeatured->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:55 |
| 10 | ContentViewFeatured->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: 3.90 ms Nach letzter Abfrage: 1.35 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.008 MB Zeilen zurückgegeben: 0
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,fp.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
FROM joszo_content AS a
INNER JOIN joszo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN joszo_categories AS c
ON c.id = a.catid
LEFT JOIN joszo_users AS ua
ON ua.id = a.created_by
LEFT JOIN joszo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN joszo_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 15:39:28')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 15:39:28')
AND a.language IN ('de-DE','*')
AND a.catid IN (13)
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 4
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | a | NULL | ref | PRIMARY,idx_access,idx_state,idx_catid,idx_language | idx_catid | 4 | const | 1 | 13.09 | Using where |
| 1 | SIMPLE | fp | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.id | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.created_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.modified_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.82 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.94 ms |
| init | 0.54 ms |
| System lock | 0.04 ms |
| optimizing | 0.05 ms |
| statistics | 0.24 ms |
| preparing | 0.06 ms |
| Creating tmp table | 0.20 ms |
| Sorting result | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.29 ms |
| Creating sort index | 0.07 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| removing tmp table | 0.06 ms |
| query end | 0.04 ms |
| closing tables | 0.05 ms |
| freeing items | 0.12 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/MVC/Model/BaseDatabaseModel.php:322 |
| 15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 |
| 13 | ContentModelArticles->getItems() | JROOT/components/com_content/models/featured.php:126 |
| 12 | ContentModelFeatured->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:56 |
| 10 | ContentViewFeatured->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.01 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.020 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM joszo_content AS a
INNER JOIN joszo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN joszo_categories AS c
ON c.id = a.catid
LEFT JOIN joszo_users AS ua
ON ua.id = a.created_by
LEFT JOIN joszo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN joszo_categories as parent
ON parent.id = c.parent_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 15:39:28')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 15:39:28')
AND a.language IN ('de-DE','*')
AND a.catid IN (13)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | a | NULL | ref | PRIMARY,idx_access,idx_state,idx_catid,idx_language | idx_catid | 4 | const | 1 | 13.09 | Using where |
| 1 | SIMPLE | fp | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.id | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.created_by | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.modified_by | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.24 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.82 ms |
| init | 0.09 ms |
| System lock | 0.06 ms |
| optimizing | 0.04 ms |
| statistics | 0.18 ms |
| preparing | 0.05 ms |
| executing | 0.02 ms |
| Sending data | 0.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.05 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 |
| 13 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/featured/view.html.php:57 |
| 10 | ContentViewFeatured->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.57 ms Nach letzter Abfrage: 8.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.144 MB Zeilen zurückgegeben: 3
SELECT language,id
FROM `joszo_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | joszo_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 160 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.19 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.82 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.16 ms |
| cleaning up | 0.10 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
| 8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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.53 ms Nach letzter Abfrage: 0.74 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.157 MB Zeilen zurückgegeben: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `joszo_menu` AS `c`
INNER JOIN `joszo_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joszo_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joszo_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 195
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_key | PRIMARY | 206 | const,const | 1 | 100.00 | NULL |
| 1 | SIMPLE | a2 | NULL | ref | idx_key | idx_key | 128 | const | 2 | 100.00 | Using index |
| 1 | SIMPLE | c2 | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a2.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.22 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.15 ms |
| init | 0.05 ms |
| System lock | 0.09 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.34 ms |
| cleaning up | 0.03 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
| 8 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:768 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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: 7.64 ms Nach letzter Abfrage: 2.22 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 3.220 MB Zeilen zurückgegeben: 13
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joszo_modules AS m
LEFT JOIN joszo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joszo_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-12-05 15:39:28')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-05 15:39:28')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 195 OR mm.menuid <= 0)
AND m.language IN ('de-DE','*')
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 222 | 0.99 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | agency_jooml45.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | agency_jooml45.m.id | 1 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.34 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.10 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| optimizing | 0.08 ms |
| statistics | 0.14 ms |
| preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 6.51 ms |
| end | 0.04 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.08 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/wsfactory/index.php:103 |
| 7 | require JROOT/templates/wsfactory/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 |
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `joszo_extensions`
1 × SELECT `data`
FROM `joszo_session`
1 × SELECT `session_id`
FROM `joszo_session`
1 × SELECT id, rules
FROM `joszo_viewlevels
1 × SELECT b.id
FROM joszo_usergroups AS a
LEFT JOIN joszo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM joszo_extensions
1 × SELECT *
FROM joszo_languages
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `joszo_extensions`
1 × 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 joszo_menu AS m
LEFT JOIN joszo_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params
FROM joszo_template_styles as s
LEFT JOIN joszo_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `joszo_assets`
1 × 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,fp.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
FROM joszo_content AS a
INNER JOIN joszo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN joszo_categories AS c
ON c.id = a.catid
LEFT JOIN joszo_users AS ua
ON ua.id = a.created_by
LEFT JOIN joszo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN joszo_categories as parent
ON parent.id = c.parent_id
1 × SELECT COUNT(*)
FROM joszo_content AS a
INNER JOIN joszo_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN joszo_categories AS c
ON c.id = a.catid
LEFT JOIN joszo_users AS ua
ON ua.id = a.created_by
LEFT JOIN joszo_users AS uam
ON uam.id = a.modified_by
LEFT JOIN joszo_categories as parent
ON parent.id = c.parent_id
1 × SELECT language,id
FROM `joszo_menu`
1 × SELECT `c2`.`language`,`c2`.`id`
FROM `joszo_menu` AS `c`
INNER JOIN `joszo_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `joszo_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `joszo_menu` AS `c2`
ON a2.id = c2.`id`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM joszo_modules AS m
LEFT JOIN joszo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN joszo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Stefan Margita ist der Protagonist der Welt-Uraufführung der Oper Don Buoso des Komponisten Jan Kučera am Nationaltheater in Prag. Die Partie wurde extra für Stefan Margita geschrieben. Die verbleibenden Aufführungen am 28. November sowie am 9. und 21. Dezember statt.
