Abfragezeit: 0.65 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.035 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `joszo_session`
WHERE `session_id` = X'3838643639326139303834366632353830373437643835656632626438303863'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Executing | 0.02 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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.47 ms Nach letzter Abfrage: 0.50 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'3838643639326139303834366632353830373437643835656632626438303863'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php: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: 2.23 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.054 MB
INSERT INTO `joszo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3838643639326139303834366632353830373437643835656632626438303863', 1, 1714059213, 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `joszo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3838643639326139303834366632353830373437643835656632626438303863', 1, 1714059213, 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.02 ms |
| Update | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| Update | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 1.67 ms |
| Writing to binlog | 0.02 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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.92 ms Nach letzter Abfrage: 0.82 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | ref | extension | extension | 82 | const | 41 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.03 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.18 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 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.68 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.116 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `joszo_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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: 2.36 ms Nach letzter Abfrage: 0.13 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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.02 ms Nach letzter Abfrage: 0.25 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | ALL | extension | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 257 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.41 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 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: 0.79 ms Nach letzter Abfrage: 5.20 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.584 MB Zeilen zurückgegeben: 2
SELECT *
FROM joszo_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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.81 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | ref | extension | extension | 82 | const | 4 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.06 ms |
| Executing | 0.01 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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: 0.56 ms Nach letzter Abfrage: 4.79 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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: 1.94 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 1.654 MB
UPDATE `joszo_extensions`
SET `params` = '{\"mediaversion\":\"75668b67f9525675e0e6c6f029e842e8\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `joszo_extensions`
SET `params` = '{\"mediaversion\":\"75668b67f9525675e0e6c6f029e842e8\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init for update | 0.06 ms |
| Updating | 0.08 ms |
| End of update loop | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 1.36 ms |
| Writing to binlog | 0.02 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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: 2.04 ms Nach letzter Abfrage: 1.84 ms Abfragespeichernutzung: 0.274 MB Speichernutzung vor Abfrage: 1.706 MB Zeilen zurückgegeben: 148
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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 155 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.11 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 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: 0.82 ms Nach letzter Abfrage: 8.61 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.755 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 6 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | agency_jooml45.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.10 ms |
| Preparing | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 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.43 ms Nach letzter Abfrage: 3.85 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.907 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 41 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.18 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.42 ms |
| End of update loop | 0.03 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 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: 2.42 ms Nach letzter Abfrage: 1.67 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.993 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 <= '2024-04-25 15:33:33')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 15:33:33')
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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | fp | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | |
| 1 | SIMPLE | a | eq_ref|filter | PRIMARY,idx_access,idx_state,idx_catid,idx_language | idx_state|idx_catid | 5|4 | const,agency_jooml45.fp.content_id | 1 (9%) | Using index condition; Using where; Using rowid filter |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.created_by | 1 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a.modified_by | 1 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.36 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.15 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.13 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.25 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.07 ms |
| Creating tmp table | 0.18 ms |
| Sorting result | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.50 ms |
| Creating sort index | 0.07 ms |
| Removing tmp table | 0.11 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 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: 0.83 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.004 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 <= '2024-04-25 15:33:33')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 15:33:33')
AND a.language IN ('de-DE','*')
AND a.catid IN (13)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | fp | index | PRIMARY | PRIMARY | 4 | NULL | 1 | Using index |
| 1 | SIMPLE | a | eq_ref|filter | PRIMARY,idx_access,idx_state,idx_catid,idx_language | idx_state|idx_catid | 5|4 | const,agency_jooml45.fp.content_id | 1 (9%) | Using index condition; Using where; Using rowid filter |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.18 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.06 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 1.35 ms |
| Reset for next command | 0.02 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: 0.77 ms Nach letzter Abfrage: 4.81 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.129 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | joszo_menu | ALL | idx_client_id_parent_id_alias_language | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 205 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.24 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 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: 0.63 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.141 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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| 1 | SIMPLE | a | const | PRIMARY,idx_key | PRIMARY | 206 | const,const | 1 | |
| 1 | SIMPLE | a2 | ref | idx_key | idx_key | 128 | const | 2 | Using index |
| 1 | SIMPLE | c2 | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.a2.id | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.02 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: 3.09 ms Nach letzter Abfrage: 1.41 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 3.204 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 <= '2024-04-25 15:33:33')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 15:33:33')
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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 216 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | agency_jooml45.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | agency_jooml45.m.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.12 ms |
| Sorting result | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 2.22 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.11 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 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
Astrid Kessler singt zum ersten Mal die Sopranpartie in Zemlinskis Lyrischer Symphonie - und zwar mit dem Finnish National Opera Orchestra unter Hanny Lintu beim Organ Night and Aria Festival in der Tapiola Hall im Finnischen Espoo am 8. August.
Stefan Margita gibt sein Debüt mit dem Dallas Symphony Orchestra in einer der wichtigsten Partien seiner Karriere: Er singt den Loge in Wagners Das Rheingold unter Fabio Luisi am 1. und 4. Mai im Morton H. Meyerson Symphony Center in Dallas.
Stephanie Müther stellt sich dem Berner Publikum als Brünnhilde in einer Neuproduktion von Wagners Siegfried in der Regie von Ewelina Marciniak und unter der musikalischen Leitung von Nicholas Carter vor.
