Query Time: 1.46 ms Query memory: 0.023 MB Memory before query: 1.034 MB Rows returned: 0
SELECT `data`
FROM `joszo_session`
WHERE `session_id` = X'6461346435633339643266326431633534626536313062366432343837633333'
| 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.31 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.40 ms |
| init | 0.04 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.20 ms |
| executing | 0.07 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.21 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Same as call in the line below. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:854 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:414 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.80 ms After last query: 0.66 ms Query memory: 0.020 MB Memory before query: 1.048 MB Rows returned: 0
SELECT `session_id`
FROM `joszo_session`
WHERE `session_id` = X'6461346435633339643266326431633534626536313062366432343837633333'
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.22 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.06 ms |
| closing tables | 0.05 ms |
| freeing items | 0.20 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:856 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:414 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 4.95 ms After last query: 0.17 ms Query memory: 0.004 MB Memory before query: 1.054 MB
INSERT INTO `joszo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6461346435633339643266326431633534626536313062366432343837633333', 1, 1660280928, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `joszo_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6461346435633339643266326431633534626536313062366432343837633333', 1, 1660280928, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.20 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.08 ms |
| System lock | 0.03 ms |
| update | 0.15 ms |
| end | 0.02 ms |
| query end | 4.12 ms |
| closing tables | 0.04 ms |
| freeing items | 0.13 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:856 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:414 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.80 ms After last query: 1.09 ms Query memory: 0.024 MB Memory before query: 1.085 MB Rows returned: 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.20 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.30 ms |
| init | 0.08 ms |
| System lock | 0.03 ms |
| optimizing | 0.12 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.54 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.23 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.17 ms After last query: 1.14 ms Query memory: 0.021 MB Memory before query: 1.115 MB Rows returned: 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 | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.07 ms |
| Opening tables | 0.37 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.04 ms |
| freeing items | 0.25 ms |
| cleaning up | 0.09 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.38 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 1.127 MB Rows returned: 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.23 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.33 ms |
| init | 0.09 ms |
| System lock | 0.07 ms |
| optimizing | 0.05 ms |
| statistics | 0.10 ms |
| preparing | 0.09 ms |
| executing | 0.02 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.72 ms After last query: 0.25 ms Query memory: 0.030 MB Memory before query: 1.149 MB Rows returned: 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; Using filesort |
| Status | Duration |
|---|
| starting | 0.28 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.06 ms |
| System lock | 0.09 ms |
| optimizing | 0.04 ms |
| statistics | 0.07 ms |
| preparing | 0.05 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.69 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.20 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.37 ms After last query: 5.32 ms Query memory: 0.021 MB Memory before query: 1.582 MB Rows returned: 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 | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.20 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.29 ms |
| init | 0.04 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| preparing | 0.08 ms |
| Sorting result | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.23 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.16 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 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:695 |
| 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 |
Query Time: 0.88 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 1.592 MB Rows returned: 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.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.16 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.18 ms |
| end | 0.03 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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:695 |
| 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 |
Query Time: 0.94 ms After last query: 4.95 ms Query memory: 0.025 MB Memory before query: 1.659 MB Rows returned: 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.18 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.05 ms |
| executing | 0.02 ms |
| Sending data | 0.10 ms |
| end | 0.03 ms |
| query end | 0.05 ms |
| closing tables | 0.06 ms |
| freeing items | 0.16 ms |
| cleaning up | 0.04 ms |
| # | Caller | File and line number |
|---|
| 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}() | Same as call in the line below. |
| 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:696 |
| 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 |
Query Time: 6.38 ms After last query: 0.16 ms Query memory: 0.008 MB Memory before query: 1.653 MB
UPDATE `joszo_extensions`
SET `params` = '{\"mediaversion\":\"1c27e0b83ee5e908f07dd10fa803e5ec\"}'
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.24 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.06 ms |
| updating | 0.32 ms |
| end | 0.10 ms |
| query end | 5.32 ms |
| closing tables | 0.03 ms |
| freeing items | 0.15 ms |
| cleaning up | 0.08 ms |
| # | Caller | File and line number |
|---|
| 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:696 |
| 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 |
Query Time: 5.97 ms After last query: 2.08 ms Query memory: 0.298 MB Memory before query: 1.705 MB Rows returned: 172
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 | 183 | 10.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | agency_jooml45.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.27 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.46 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.09 ms |
| preparing | 0.09 ms |
| Sorting result | 0.03 ms |
| executing | 0.03 ms |
| Sending data | 0.08 ms |
| Creating sort index | 4.24 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.15 ms |
| freeing items | 0.23 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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}() | Same as call in the line below. |
| 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:445 |
| 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:561 |
| 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:696 |
| 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 |
Query Time: 1.78 ms After last query: 7.23 ms Query memory: 0.019 MB Memory before query: 2.596 MB Rows returned: 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.19 ms |
| checking permissions | 0.11 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.35 ms |
| init | 0.06 ms |
| System lock | 0.03 ms |
| optimizing | 0.09 ms |
| statistics | 0.24 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.16 ms |
| end | 0.07 ms |
| query end | 0.04 ms |
| closing tables | 0.03 ms |
| freeing items | 0.17 ms |
| cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.52 ms After last query: 2.93 ms Query memory: 0.028 MB Memory before query: 2.747 MB Rows returned: 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.21 ms |
| checking permissions | 0.07 ms |
| Opening tables | 0.35 ms |
| init | 0.14 ms |
| System lock | 0.08 ms |
| optimizing | 0.04 ms |
| statistics | 0.33 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.85 ms |
| end | 0.06 ms |
| query end | 0.05 ms |
| closing tables | 0.03 ms |
| freeing items | 0.17 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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 |
Query Time: 3.29 ms After last query: 1.32 ms Query memory: 0.024 MB Memory before query: 2.833 MB Rows returned: 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 <= '2022-08-12 05:08:48')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-12 05:08:48')
AND a.language IN ('en-GB','*')
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; Using filesort |
| 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.32 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 1.23 ms |
| init | 0.15 ms |
| System lock | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.22 ms |
| preparing | 0.09 ms |
| Creating tmp table | 0.20 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.29 ms |
| Creating sort index | 0.06 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| removing tmp table | 0.04 ms |
| query end | 0.01 ms |
| closing tables | 0.05 ms |
| freeing items | 0.18 ms |
| cleaning up | 0.05 ms |
| # | Caller | File and line number |
|---|
| 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 |
Query Time: 1.00 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 2.845 MB Rows returned: 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 <= '2022-08-12 05:08:48')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-12 05:08:48')
AND a.language IN ('en-GB','*')
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.17 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.08 ms |
| executing | 0.05 ms |
| Sending data | 0.04 ms |
| end | 0.05 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.06 ms |
| # | Caller | File and line number |
|---|
| 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 |
Query Time: 1.05 ms After last query: 4.74 ms Query memory: 0.021 MB Memory before query: 2.954 MB Rows returned: 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 | 184 | 1.00 | Using where |
| Status | Duration |
|---|
| starting | 0.12 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.46 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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 |
Query Time: 0.98 ms After last query: 0.51 ms Query memory: 0.021 MB Memory before query: 2.966 MB Rows returned: 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 = 194
| 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.12 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.31 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 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 |
Query Time: 4.77 ms After last query: 1.59 ms Query memory: 0.040 MB Memory before query: 3.022 MB Rows returned: 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 <= '2022-08-12 05:08:48')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-12 05:08:48')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 194 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
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 | 247 | 1.09 | Using index condition; Using where; Using filesort |
| 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.15 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.32 ms |
| init | 0.06 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.08 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 3.54 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.03 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 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:589 |
| 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:666 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:728 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:543 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1126 |
| 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
At the Bayreuth Festival he performs Tristan in a new production of Tristan und Isolde directed by Roland Schwab and conducted by Markus Poschner on August 12.
In summer Daniel Kirch gave his debut at Bayreuth Festival:
Stéphanie Müther gave her debut at the Bayreuth Festival in the part of Ortrud in Lohengrin in the version for children. The last performances are taking place on August 4 and 5.
After her huge success at the Salzburg Festival as Judith in Romeo Castellucci's production of Bartok's Duke Bluebeard's Castle conducted by Teodor Currentzis Ausrine Stundyte can still be heard in this part on August 2, 6, 15 and 20 at the Felsenreitschule.
