Query Time: 1.76 ms Query memory: 0.025 MB Memory before query: 1.204 MB Rows returned: 0
SELECT `data`
FROM `cz27f_session`
WHERE `session_id` = '6333e733c821efe93d173fa5ad525b0c'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.80 ms |
| Preparing | 0.03 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 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:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:51 |
Query Time: 0.86 ms After last query: 0.92 ms Query memory: 0.022 MB Memory before query: 1.283 MB Rows returned: 0
SELECT `session_id`
FROM `cz27f_session`
WHERE `session_id` = '6333e733c821efe93d173fa5ad525b0c'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.08 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.03 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.03 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.24 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:51 |
Query Time: 1.90 ms After last query: 0.18 ms Query memory: 0.004 MB Memory before query: 1.288 MB
INSERT INTO `cz27f_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('6333e733c821efe93d173fa5ad525b0c', 1, 1749293110, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `cz27f_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('6333e733c821efe93d173fa5ad525b0c', 1, 1749293110, 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init for update | 0.04 ms |
| Update | 0.78 ms |
| Waiting for query cache lock | 0.03 ms |
| Update | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.49 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 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:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:51 |
Query Time: 3.12 ms After last query: 2.18 ms Query memory: 0.030 MB Memory before query: 1.324 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cz27f_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 | cz27f_extensions | ref | extension | extension | 82 | const | 40 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.32 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 1.72 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.07 ms |
| Waiting for query cache lock | 0.03 ms |
| Updating status | 0.03 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.34 ms After last query: 2.10 ms Query memory: 0.023 MB Memory before query: 1.359 MB Rows returned: 4
SELECT id, rules
FROM `cz27f_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.05 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 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:321 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.39 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 1.370 MB Rows returned: 2
SELECT b.id
FROM cz27f_usergroups AS a
LEFT JOIN cz27f_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.06 ms |
| Waiting for query cache lock | 0.05 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.03 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.04 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 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:321 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.44 ms After last query: 0.47 ms Query memory: 0.039 MB Memory before query: 1.393 MB Rows returned: 109
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM cz27f_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 | cz27f_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 262 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.12 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.03 ms |
| Creating sort index | 1.04 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.10 ms |
| Waiting for query cache lock | 0.05 ms |
| Updating status | 0.03 ms |
| Storing result in query cache | 0.31 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 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:359 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.86 ms After last query: 8.39 ms Query memory: 0.026 MB Memory before query: 1.899 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cz27f_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.10 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.04 ms |
| System lock | 0.05 ms |
| table lock | 0.03 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.07 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.52 ms |
| Preparing | 0.07 ms |
| Executing | 0.03 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 17 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 16 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
| 15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 13 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 12 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 11 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/kunena/kunena.php:70 |
| 7 | plgSystemKunena->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.16 ms After last query: 0.38 ms Query memory: 0.006 MB Memory before query: 1.892 MB
UPDATE `cz27f_extensions`
SET `params` = '{\"mediaversion\":\"2411581189d22ccfb9364925b10d0fff\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `cz27f_extensions`
SET `params` = '{\"mediaversion\":\"2411581189d22ccfb9364925b10d0fff\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.04 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.11 ms |
| Updating | 0.16 ms |
| End of update loop | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| End of update loop | 0.76 ms |
| Query end | 0.03 ms |
| Commit | 0.51 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 12 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 11 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/kunena/kunena.php:70 |
| 7 | plgSystemKunena->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.32 ms After last query: 3.34 ms Query memory: 0.022 MB Memory before query: 2.005 MB Rows returned: 1
SELECT `enabled`
FROM `cz27f_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.04 ms |
| Checking query cache for query | 0.08 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.13 ms |
| Preparing | 0.08 ms |
| Executing | 0.03 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.03 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.47 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:36 |
| 7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.37 ms After last query: 3.99 ms Query memory: 0.027 MB Memory before query: 2.189 MB Rows returned: 3
SELECT *
FROM cz27f_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.03 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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:283 |
| 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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.36 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 2.263 MB Rows returned: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `cz27f_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 | cz27f_extensions | ref | extension | extension | 82 | const | 6 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.10 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.12 ms |
| Preparing | 0.07 ms |
| Executing | 0.03 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.04 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.03 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.74 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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:283 |
| 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:625 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 5.36 ms After last query: 18.86 ms Query memory: 0.196 MB Memory before query: 2.342 MB Rows returned: 244
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 cz27f_menu AS m
LEFT JOIN cz27f_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 | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 313 | Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.17 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| Waiting for query cache lock | 0.06 ms |
| init | 0.08 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.52 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.05 ms |
| Creating sort index | 1.38 ms |
| Waiting for query cache lock | 0.03 ms |
| Creating sort index | 0.20 ms |
| Waiting for query cache lock | 0.03 ms |
| Creating sort index | 0.23 ms |
| Waiting for query cache lock | 0.03 ms |
| Creating sort index | 0.32 ms |
| Waiting for query cache lock | 0.03 ms |
| Creating sort index | 0.50 ms |
| Waiting for query cache lock | 0.03 ms |
| Creating sort index | 0.36 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.03 ms |
| Updating status | 0.06 ms |
| Waiting for query cache lock | 0.03 ms |
| Updating status | 0.04 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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:76 |
| 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:131 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 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:64 |
| 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:491 |
| 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:626 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.41 ms After last query: 14.17 ms Query memory: 0.027 MB Memory before query: 3.340 MB Rows returned: 1
SELECT *
FROM `cz27f_kunena_configuration`
WHERE `id`=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_configuration | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.05 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/config.php:1381 |
| 18 | KunenaConfig->load() | JROOT/libraries/kunena/config.php:1354 |
| 17 | KunenaConfig::getInstance() | JROOT/libraries/kunena/factory.php:237 |
| 16 | KunenaFactory::getConfig() | JROOT/libraries/kunena/route/route.php:965 |
| 15 | KunenaRoute::initialize() | JROOT/libraries/kunena/route/route.php:19 |
| 14 | include_once JROOT/libraries/kunena/route/route.php | JROOT/libraries/loader.php:759 |
| 13 | JLoader::_load() | JROOT/libraries/loader.php:707 |
| 12 | JLoader::_autoload() | Same as call in the line below. |
| 11 | spl_autoload_call() | JROOT/components/com_kunena/router.php:306 |
| 10 | KunenaParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
| 9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.33 ms After last query: 2.04 ms Query memory: 0.024 MB Memory before query: 3.443 MB Rows returned: 1
SELECT *
FROM cz27f_kunena_aliases
WHERE alias LIKE 'user%'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_aliases | range | alias | alias | 767 | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.05 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/route/route.php:932 |
| 11 | KunenaRoute::resolveAlias() | JROOT/components/com_kunena/router.php:321 |
| 10 | KunenaParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
| 9 | Joomla\CMS\Component\Router\RouterLegacy->parse() | JROOT/libraries/src/Router/SiteRouter.php:437 |
| 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
| 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.17 ms After last query: 0.83 ms Query memory: 0.021 MB Memory before query: 3.466 MB Rows returned: 3
SELECT id, home, template, s.params
FROM cz27f_template_styles as s
LEFT JOIN cz27f_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 | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.14 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| Waiting for query cache lock | 0.06 ms |
| init | 0.09 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.20 ms |
| Preparing | 0.11 ms |
| Executing | 0.03 ms |
| Sending data | 0.65 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.03 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.50 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.15 ms After last query: 3.75 ms Query memory: 0.029 MB Memory before query: 3.615 MB Rows returned: 5
SHOW FULL COLUMNS
FROM `cz27f_kunena_sessions`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cz27f_kunena_sessions`
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.03 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.74 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| checking permissions | 0.10 ms |
| closing tables | 0.04 ms |
| checking permissions | 0.03 ms |
| Executing | 0.04 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.18 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.05 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:441 |
| 16 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 15 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 14 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/kunena/tables/kunenasessions.php:73 |
| 13 | TableKunenaSessions->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 12 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/session.php:128 |
| 11 | KunenaSession->getTable() | JROOT/libraries/kunena/session.php:86 |
| 10 | KunenaSession->load() | JROOT/libraries/kunena/session.php:52 |
| 9 | KunenaSession->__construct() | JROOT/libraries/kunena/session.php:144 |
| 8 | KunenaSession::getInstance() | JROOT/libraries/kunena/factory.php:101 |
| 7 | KunenaFactory::getSession() | JROOT/components/com_kunena/kunena.php:63 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.52 ms After last query: 9.61 ms Query memory: 0.040 MB Memory before query: 4.027 MB Rows returned: 55
SHOW FULL COLUMNS
FROM `cz27f_kunena_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cz27f_kunena_users`
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.04 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.68 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Filling schema table | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| checking permissions | 0.27 ms |
| closing tables | 0.03 ms |
| checking permissions | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.15 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.21 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:441 |
| 21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 20 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 19 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/kunena/tables/kunenausers.php:416 |
| 18 | TableKunenaUsers->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 17 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/user/user.php:226 |
| 16 | KunenaUser->getTable() | JROOT/libraries/kunena/user/user.php:185 |
| 15 | KunenaUser->load() | JROOT/libraries/kunena/user/user.php:161 |
| 14 | KunenaUser->__construct() | JROOT/libraries/kunena/user/helper.php:91 |
| 13 | KunenaUserHelper::initialize() | JROOT/libraries/kunena/user/helper.php:13 |
| 12 | include_once JROOT/libraries/kunena/user/helper.php | JROOT/libraries/loader.php:738 |
| 11 | JLoader::_load() | JROOT/libraries/loader.php:707 |
| 10 | JLoader::_autoload() | Same as call in the line below. |
| 9 | spl_autoload_call() | JROOT/libraries/kunena/controller/application/display.php:219 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:75 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.48 ms After last query: 7.45 ms Query memory: 0.031 MB Memory before query: 4.242 MB Rows returned: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `cz27f_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sobipro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 41 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| Waiting for query cache lock | 0.05 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.03 ms |
| checking permissions | 0.04 ms |
| Sending cached result to clien | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 17 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 16 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 15 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/plugins/kunena/joomla/access.php:292 |
| 14 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:259 |
| 13 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:149 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:121 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:235 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:380 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:225 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:75 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.50 ms After last query: 7.01 ms Query memory: 0.026 MB Memory before query: 4.303 MB Rows returned: 5
SELECT DISTINCT(user_id)
FROM cz27f_usergroups AS ug1
INNER JOIN cz27f_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN cz27f_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (8)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | m | index | NULL | PRIMARY | 8 | NULL | 10254 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.06 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.04 ms |
| checking permissions | 0.07 ms |
| Sending cached result to clien | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:380 |
| 15 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:323 |
| 14 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:259 |
| 13 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:149 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:121 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:235 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:380 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:225 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:75 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.24 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 4.312 MB Rows returned: 0
SELECT DISTINCT(user_id)
FROM cz27f_usergroups AS ug1
INNER JOIN cz27f_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN cz27f_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (7)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 6 | Using where; Using index |
| 1 | SIMPLE | m | index | NULL | PRIMARY | 8 | NULL | 10254 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.03 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.05 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:380 |
| 15 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:323 |
| 14 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:259 |
| 13 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:149 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:121 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:235 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:380 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:225 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:75 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.33 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 4.321 MB Rows returned: 0
SELECT `user_id`,`category_id`,`role`
FROM `cz27f_kunena_user_categories`
WHERE `role` IN (1,2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_user_categories | range | role | role | 1 | NULL | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.03 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/access.php:163 |
| 12 | KunenaAccess->clearCache() | JROOT/libraries/kunena/access.php:121 |
| 11 | KunenaAccess->__construct() | JROOT/libraries/kunena/access.php:235 |
| 10 | KunenaAccess::getInstance() | JROOT/libraries/kunena/user/user.php:380 |
| 9 | KunenaUser->isAdmin() | JROOT/libraries/kunena/controller/application/display.php:225 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:75 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 5.31 ms After last query: 1.20 ms Query memory: 0.047 MB Memory before query: 4.410 MB Rows returned: 1
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM cz27f_users AS u
LEFT JOIN cz27f_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 1808
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | ku | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.12 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.07 ms |
| init | 0.11 ms |
| Optimizing | 0.06 ms |
| Statistics | 3.68 ms |
| Preparing | 0.05 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.06 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 22 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/tables/kunenausers.php:461 |
| 21 | TableKunenaUsers->load() | JROOT/libraries/kunena/user/user.php:190 |
| 20 | KunenaUser->load() | JROOT/libraries/kunena/user/user.php:161 |
| 19 | KunenaUser->__construct() | JROOT/libraries/kunena/user/helper.php:186 |
| 18 | KunenaUserHelper::get() | JROOT/components/com_kunena/router.php:249 |
| 17 | KunenaBuildRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:69 |
| 16 | Joomla\CMS\Component\Router\RouterLegacy->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 15 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 14 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 13 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 12 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:102 |
| 11 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:52 |
| 10 | Joomla\CMS\Router\Route::_() | JROOT/libraries/kunena/route/route.php:783 |
| 9 | KunenaRoute::_() | JROOT/libraries/kunena/controller/application/display.php:271 |
| 8 | KunenaControllerApplicationDisplay->before() | JROOT/libraries/kunena/controller/application/display.php:75 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.47 ms After last query: 2.94 ms Query memory: 0.034 MB Memory before query: 4.465 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `cz27f_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cz27f_users`
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.44 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.11 ms |
| closing tables | 0.03 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.11 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:441 |
| 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 22 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 21 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:40 |
| 20 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 19 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
| 18 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:880 |
| 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_kunena/controller/user/item/display.php:87 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.81 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 4.505 MB Rows returned: 1
SELECT *
FROM `cz27f_users`
WHERE `id` = 1808
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.29 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:86 |
| 18 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
| 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_kunena/controller/user/item/display.php:87 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.50 ms After last query: 0.65 ms Query memory: 0.027 MB Memory before query: 4.521 MB Rows returned: 1
SELECT `g`.`id`,`g`.`title`
FROM `cz27f_usergroups` AS g
INNER JOIN `cz27f_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 1808
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.m.group_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.03 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.70 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.04 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 19 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:111 |
| 18 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
| 17 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 16 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 15 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 14 | Joomla\CMS\Factory::getUser() | JROOT/components/com_kunena/controller/user/item/display.php:87 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.32 ms After last query: 0.57 ms Query memory: 0.008 MB Memory before query: 4.548 MB
UPDATE `cz27f_kunena_users`
SET `view`='',`signature`='Ортопедическая подушка - изделие особой «анатомической» формы, которое поддерживает тело в правильном положении, уменьшая нагрузку, расслабляя мышцы. Специальные приспособления обладают оздоровительным эффектом, имеют малый вес, не впитывают запах, гарантируют повышенный комфорт при эксплуатации. Лучшие ортопедические подушки для сна купить. Лучшие магазины Москвы предлагают купить подушки классические, анатомические волнообразные, с выемкой под плечо, валиками, картриджами. Различаются модели по форме, назначению и типу наполнителя. К подбору подушек следует подходить индивидуально.',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='595',`personalText`='',`gender`='1',`birthdate`='2020-04-30',`location`='Москва',`websitename`='Лучшие ортопедические подушки',`websiteurl`='http://ortopedicheskie-podushki.ru/',`rank`='0',`hideEmail`='1',`showOnline`='1',`icq`='238611642',`yim`='wastefuldoctrin',`microsoft`='',`skype`='spotalas',`twitter`='',`facebook`='',`google`='',`myspace`='',`linkedin`='',`delicious`='',`friendfeed`='',`digg`='',`blogspot`='',`flickr`='',`bebo`='',`thankyou`='0',`canSubscribe`='-1',`userListtime`='-2',`status`='0',`status_text`='',`instagram`='',`qq`='',`qzone`='',`weibo`='',`wechat`='',`apple`='',`vk`='',`telegram`='',`socialshare`='0',`youtube`='',`ok`='',`whatsapp`=''
WHERE `userid`='1808'
EXPLAIN not possible on query: UPDATE `cz27f_kunena_users` SET `view`='',`signature`='Ортопедическая подушка - изделие особой «анатомической» формы, которое поддерживает тело в правильном положении, уменьшая нагрузку, расслабляя мышцы. Специальные приспособления обладают оздоровительным эффектом, имеют малый вес, не впитывают запах, гарантируют повышенный комфорт при эксплуатации. Лучшие ортопедические подушки для сна купить. Лучшие магазины Москвы предлагают купить подушки классические, анатомические волнообразные, с выемкой под плечо, валиками, картриджами. Различаются модели по форме, назначению и типу наполнителя. К подбору подушек следует подходить индивидуально.',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='595',`personalText`='',`gender`='1',`birthdate`='2020-04-30',`location`='Москва',`websitename`='Лучшие ортопедические подушки',`websiteurl`='http://ortopedicheskie-podushki.ru/',`rank`='0',`hideEmail`='1',`showOnline`='1',`icq`='238611642',`yim`='wastefuldoctrin',`microsoft`='',`skype`='spotalas',`twitter`='',`facebook`='',`google`='',`myspace`='',`linkedin`='',`delicious`='',`friendfeed`='',`digg`='',`blogspot`='',`flickr`='',`bebo`='',`thankyou`='0',`canSubscribe`='-1',`userListtime`='-2',`status`='0',`status_text`='',`instagram`='',`qq`='',`qzone`='',`weibo`='',`wechat`='',`apple`='',`vk`='',`telegram`='',`socialshare`='0',`youtube`='',`ok`='',`whatsapp`='' WHERE `userid`='1808'
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.15 ms |
| Updating | 1.05 ms |
| End of update loop | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| End of update loop | 0.07 ms |
| Query end | 0.02 ms |
| Commit | 0.52 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/kunena/tables/kunena.php:272 |
| 16 | KunenaTable->updateObject() | JROOT/libraries/kunena/tables/kunena.php:157 |
| 15 | KunenaTable->store() | JROOT/libraries/kunena/user/user.php:886 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:95 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.25 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 4.548 MB Rows returned: 5
SELECT DISTINCT(user_id)
FROM cz27f_usergroups AS ug1
INNER JOIN cz27f_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN cz27f_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (8)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | m | index | NULL | PRIMARY | 8 | NULL | 10254 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 19 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:380 |
| 18 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:323 |
| 17 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:259 |
| 16 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:149 |
| 15 | KunenaAccess->clearCache() | JROOT/libraries/kunena/user/user.php:892 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:95 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 4.558 MB Rows returned: 0
SELECT DISTINCT(user_id)
FROM cz27f_usergroups AS ug1
INNER JOIN cz27f_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN cz27f_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id IN (7)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | Using temporary |
| 1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 6 | Using where; Using index |
| 1 | SIMPLE | m | index | NULL | PRIMARY | 8 | NULL | 10254 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 19 | JDatabaseDriver->loadColumn() | JROOT/plugins/kunena/joomla/access.php:380 |
| 18 | KunenaAccessJoomla->getUsersByGroup() | JROOT/plugins/kunena/joomla/access.php:323 |
| 17 | KunenaAccessJoomla->getAuthorisedUsers() | JROOT/plugins/kunena/joomla/access.php:259 |
| 16 | KunenaAccessJoomla->loadCategoryRoles() | JROOT/libraries/kunena/access.php:149 |
| 15 | KunenaAccess->clearCache() | JROOT/libraries/kunena/user/user.php:892 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:95 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.21 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 4.568 MB Rows returned: 0
SELECT `user_id`,`category_id`,`role`
FROM `cz27f_kunena_user_categories`
WHERE `role` IN (1,2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_user_categories | range | role | role | 1 | NULL | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/access.php:163 |
| 15 | KunenaAccess->clearCache() | JROOT/libraries/kunena/user/user.php:892 |
| 14 | KunenaUser->save() | JROOT/components/com_kunena/controller/user/item/display.php:95 |
| 13 | ComponentKunenaControllerUserItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
| 11 | KunenaLayoutPage->execute() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:13 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.38 ms After last query: 1.69 ms Query memory: 0.034 MB Memory before query: 4.669 MB Rows returned: 13
SHOW FULL COLUMNS
FROM `cz27f_kunena_users_banned`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cz27f_kunena_users_banned`
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.38 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.02 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.08 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.11 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:441 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 23 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 22 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/kunena/tables/kunenauserbans.php:117 |
| 21 | TableKunenaUserBans->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 20 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/user/ban.php:158 |
| 19 | KunenaUserBan->getTable() | JROOT/libraries/kunena/user/ban.php:120 |
| 18 | KunenaUserBan->load() | JROOT/libraries/kunena/user/ban.php:103 |
| 17 | KunenaUserBan->__construct() | JROOT/libraries/kunena/user/ban.php:302 |
| 16 | KunenaUserBan::getInstanceByUserid() | JROOT/components/com_kunena/layout/user/item.php:32 |
| 15 | KunenaLayoutUserItem->getTabs() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:13 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.32 ms After last query: 0.34 ms Query memory: 0.031 MB Memory before query: 4.703 MB Rows returned: 0
SELECT *
FROM cz27f_kunena_users_banned
WHERE userid = '1808'
AND (expiration = '0000-00-00 00:00:00' OR expiration > '2025-06-07 10:45:11')
ORDER BY id DESC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_users_banned | ref | userid,expiration | userid | 5 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.49 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.66 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/tables/kunenauserbans.php:152 |
| 18 | TableKunenaUserBans->loadByUserid() | JROOT/libraries/kunena/user/ban.php:521 |
| 17 | KunenaUserBan->loadByUserid() | JROOT/libraries/kunena/user/ban.php:303 |
| 16 | KunenaUserBan::getInstanceByUserid() | JROOT/components/com_kunena/layout/user/item.php:32 |
| 15 | KunenaLayoutUserItem->getTabs() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:13 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.26 ms After last query: 2.29 ms Query memory: 0.036 MB Memory before query: 4.830 MB Rows returned: 66
SELECT code, location
FROM cz27f_kunena_smileys
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_smileys | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 66 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/bbcode/bbcode.php:1112 |
| 23 | KunenaBbcodeLibrary->__construct() | JROOT/libraries/kunena/bbcode/bbcode.php:54 |
| 22 | KunenaBbcode->__construct() | JROOT/libraries/kunena/bbcode/bbcode.php:89 |
| 21 | KunenaBbcode::getInstance() | JROOT/libraries/kunena/html/parser.php:181 |
| 20 | KunenaHtmlParser::parseBBCode() | JROOT/libraries/kunena/user/user.php:1158 |
| 19 | KunenaUser->getSignature() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/summary/default.php:26 |
| 18 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/summary/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 17 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 16 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 15 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:35 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.23 ms After last query: 1.43 ms Query memory: 0.030 MB Memory before query: 4.868 MB Rows returned: 10
SELECT *
FROM `cz27f_kunena_ranks`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_ranks | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 10 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/user/user.php:1338 |
| 19 | KunenaUser->getRank() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/summary/default.php:34 |
| 18 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/summary/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 17 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 16 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 15 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:35 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.46 ms After last query: 0.98 ms Query memory: 0.031 MB Memory before query: 4.910 MB Rows returned: 0
SELECT userid, MAX(time) AS time
FROM `cz27f_session`
WHERE
(`client_id`=0)
AND
(`userid`>0)
GROUP BY `userid`
ORDER BY time DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_session | range | userid | userid | 5 | NULL | 1 | Using index condition; Using where; Using temporary; Using filesort |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.06 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.42 ms |
| init | 0.06 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.05 ms |
| Sorting for group | 0.02 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/user/helper.php:543 |
| 25 | KunenaUserHelper::getOnlineUsers() | JROOT/libraries/kunena/user/helper.php:581 |
| 24 | KunenaUserHelper::getStatus() | JROOT/libraries/kunena/user/user.php:497 |
| 23 | KunenaUser->getStatus() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/status/default.php:14 |
| 22 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/status/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 21 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 20 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 19 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/summary/default.php:48 |
| 18 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/summary/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 17 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 16 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 15 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:35 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.68 ms After last query: 2.50 ms Query memory: 0.034 MB Memory before query: 4.986 MB Rows returned: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM cz27f_modules AS m
LEFT JOIN cz27f_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN cz27f_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 <= '2025-06-07 10:45:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-07 10:45:10')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 289 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds,idx_language | published | 1 | const | 58 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | biotrade_bio.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | biotrade_bio.m.module,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.09 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.12 ms |
| Preparing | 0.07 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.50 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.04 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 26 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 25 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 24 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
| 23 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 22 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 21 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 20 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/components/com_kunena/layout/widget/module.php:39 |
| 19 | KunenaLayoutWidgetModule->renderPosition() | JROOT/components/com_kunena/template/crypsis/layouts/widget/module/default.php:13 |
| 18 | include JROOT/components/com_kunena/template/crypsis/layouts/widget/module/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 17 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 16 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 15 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:38 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.28 ms After last query: 1.29 ms Query memory: 0.059 MB Memory before query: 5.006 MB Rows returned: 25
SELECT *
FROM cz27f_kunena_categories
ORDER BY ordering, name
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_categories | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 25 | Using filesort |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/forum/category/helper.php:84 |
| 23 | KunenaForumCategoryHelper::loadCategories() | JROOT/libraries/kunena/forum/category/helper.php:57 |
| 22 | KunenaForumCategoryHelper::initialize() | JROOT/libraries/kunena/forum/category/helper.php:1046 |
| 21 | include_once JROOT/libraries/kunena/forum/category/helper.php | JROOT/libraries/loader.php:738 |
| 20 | JLoader::_load() | JROOT/libraries/loader.php:707 |
| 19 | JLoader::_autoload() | Same as call in the line below. |
| 18 | spl_autoload_call() | JROOT/components/com_kunena/controller/message/list/recent/display.php:132 |
| 17 | ComponentKunenaControllerMessageListRecentDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 16 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:74 |
| 15 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:62 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.19 ms After last query: 1.37 ms Query memory: 0.027 MB Memory before query: 5.234 MB Rows returned: 1
SELECT COUNT(*)
FROM cz27f_kunena_messages AS a
WHERE a.userid=1808
AND a.catid IN (10,2,19,1,9,11,6,20,12,21,17,5,13,3,22,14,4,23,15,7,24,16,8,26,25)
AND a.moved=0
AND a.hold IN (0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | userid,hold_time,catid_parent | userid | 4 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.39 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.30 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 19 | JDatabaseDriver->loadResult() | JROOT/libraries/kunena/database/object/finder.php:270 |
| 18 | KunenaDatabaseObjectFinder->count() | JROOT/components/com_kunena/controller/message/list/recent/display.php:135 |
| 17 | ComponentKunenaControllerMessageListRecentDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 16 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:74 |
| 15 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:62 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.23 ms After last query: 1.06 ms Query memory: 0.028 MB Memory before query: 5.252 MB Rows returned: 0
SELECT a.id
FROM cz27f_kunena_messages AS a
WHERE a.userid=1808
AND a.catid IN (10,2,19,1,9,11,6,20,12,21,17,5,13,3,22,14,4,23,15,7,24,16,8,26,25)
AND a.moved=0
AND a.hold IN (0)
ORDER BY a.`time` DESC
LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | userid,hold_time,catid_parent | userid | 4 | const | 1 | Using where; Using filesort |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.04 ms |
| Checking query cache for query | 0.12 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.15 ms |
| Preparing | 0.06 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.04 ms |
| Waiting for query cache lock | 0.04 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 20 | JDatabaseDriver->loadColumn() | JROOT/libraries/kunena/database/object/finder.php:222 |
| 19 | KunenaDatabaseObjectFinder->find() | JROOT/libraries/kunena/forum/message/finder.php:225 |
| 18 | KunenaForumMessageFinder->find() | JROOT/components/com_kunena/controller/message/list/recent/display.php:205 |
| 17 | ComponentKunenaControllerMessageListRecentDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 16 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:74 |
| 15 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php:62 |
| 14 | include JROOT/components/com_kunena/template/crypsis/layouts/user/item/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 11 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php:20 |
| 10 | include JROOT/components/com_kunena/template/crypsis/pages/user/default/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/controller/application/display.php:115 |
| 7 | KunenaControllerApplicationDisplay->execute() | JROOT/components/com_kunena/kunena.php:99 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.36 ms After last query: 8.04 ms Query memory: 0.035 MB Memory before query: 5.292 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cz27f_fields AS a
LEFT JOIN `cz27f_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cz27f_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cz27f_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cz27f_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cz27f_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_kunena.user'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_context | 766 | const | 1 | Using where; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | biotrade_bio.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.group_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 13 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 11 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
| 10 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 9 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 8 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 7 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/components/com_kunena/kunena.php:136 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 1.33 ms After last query: 8.33 ms Query memory: 0.028 MB Memory before query: 5.427 MB Rows returned: 0
SELECT *
FROM cz27f_kunena_announcement
WHERE (published = 1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-06-07 10:45:10')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-06-07 10:45:10')
ORDER BY id DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_kunena_announcement | index | NULL | PRIMARY | 4 | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.03 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.46 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 1.24 ms |
| Reset for next command | 0.03 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 15 | JDatabaseDriver->loadAssocList() | JROOT/libraries/kunena/forum/announcement/helper.php:141 |
| 14 | KunenaForumAnnouncementHelper::getAnnouncements() | JROOT/components/com_kunena/controller/widget/announcement/display.php:50 |
| 13 | ComponentKunenaControllerWidgetAnnouncementDisplay->before() | JROOT/libraries/kunena/controller/display.php:122 |
| 12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/controller/display.php:74 |
| 11 | KunenaControllerDisplay->__toString() | JROOT/components/com_kunena/template/crypsis/layouts/page/default.php:35 |
| 10 | include JROOT/components/com_kunena/template/crypsis/layouts/page/default.php | JROOT/libraries/kunena/layout/base.php:166 |
| 9 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:79 |
| 8 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:117 |
| 7 | KunenaLayoutBase->__toString() | JROOT/components/com_kunena/kunena.php:138 |
| 6 | require_once JROOT/components/com_kunena/kunena.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:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.47 ms After last query: 3.09 ms Query memory: 0.023 MB Memory before query: 5.436 MB Rows returned: 1
SELECT template
FROM cz27f_template_styles
WHERE client_id = 1
AND home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_template_styles | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 9 | JDatabaseDriver->loadResult() | JROOT/templates/theme1946/includes/includes.php:21 |
| 8 | include_once JROOT/templates/theme1946/includes/includes.php | JROOT/templates/theme1946/index.php:4 |
| 7 | require JROOT/templates/theme1946/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.50 ms After last query: 8.20 ms Query memory: 0.049 MB Memory before query: 5.621 MB Rows returned: 199
SELECT `id`,`name`,`rules`,`parent_id`
FROM `cz27f_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_assets | ALL | idx_asset_name,idx_parent_id | NO INDEX KEY COULD BE USED | NULL | NULL | 341 | Using where |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.05 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 17 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 16 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 15 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 14 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 13 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:128 |
| 12 | ContentModelArticle->getItem() | JROOT/modules/mod_articles_single/helper.php:26 |
| 11 | modArticlesSingleHelper::getItem() | JROOT/modules/mod_articles_single/mod_articles_single.php:13 |
| 10 | include JROOT/modules/mod_articles_single/mod_articles_single.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 2.33 ms After last query: 0.71 ms Query memory: 0.036 MB Memory before query: 5.796 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM cz27f_content AS a
INNER JOIN cz27f_categories AS c
on c.id = a.catid
LEFT JOIN cz27f_users AS u
on u.id = a.created_by
LEFT JOIN cz27f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN cz27f_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 83
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-07 10:45:10')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-07 10:45:10')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY,idx_catid | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | v | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.17 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 1.16 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.06 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 12 | ContentModelArticle->getItem() | JROOT/modules/mod_articles_single/helper.php:26 |
| 11 | modArticlesSingleHelper::getItem() | JROOT/modules/mod_articles_single/mod_articles_single.php:13 |
| 10 | include JROOT/modules/mod_articles_single/mod_articles_single.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.35 ms After last query: 0.45 ms Query memory: 0.028 MB Memory before query: 5.817 MB Rows returned: 1
SELECT `alias`
FROM `cz27f_content`
WHERE id = '83'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.12 ms |
| starting | 0.03 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 22 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 21 | ContentRouter->getArticleSegment() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
| 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:102 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:52 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_single/helper.php:30 |
| 11 | modArticlesSingleHelper::getItem() | JROOT/modules/mod_articles_single/mod_articles_single.php:13 |
| 10 | include JROOT/modules/mod_articles_single/mod_articles_single.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.25 ms After last query: 0.54 ms Query memory: 0.040 MB Memory before query: 5.834 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `cz27f_categories` AS `s`
INNER JOIN `cz27f_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 2
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range|filter | cat_idx,idx_access,idx_left_right,idx_language | idx_left_right|cat_idx | 4|207 | NULL | 3 (31%) | Using index condition; Using where; Using rowid filter |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 21 | ContentRouter->getCategorySegment() | Same as call in the line below. |
| 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:672 |
| 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:102 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:52 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_single/helper.php:30 |
| 11 | modArticlesSingleHelper::getItem() | JROOT/modules/mod_articles_single/mod_articles_single.php:13 |
| 10 | include JROOT/modules/mod_articles_single/mod_articles_single.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.23 ms After last query: 0.47 ms Query memory: 0.027 MB Memory before query: 5.855 MB Rows returned: 1
SELECT alias
FROM cz27f_content
WHERE id=83
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 20 | JDatabaseDriver->loadResult() | JROOT/components/com_content/helpers/legacyrouter.php:140 |
| 19 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
| 18 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
| 17 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
| 16 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
| 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:102 |
| 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:52 |
| 12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_single/helper.php:30 |
| 11 | modArticlesSingleHelper::getItem() | JROOT/modules/mod_articles_single/mod_articles_single.php:13 |
| 10 | include JROOT/modules/mod_articles_single/mod_articles_single.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.25 ms After last query: 0.50 ms Query memory: 0.039 MB Memory before query: 5.867 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cz27f_fields AS a
LEFT JOIN `cz27f_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cz27f_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cz27f_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cz27f_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cz27f_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_articles_single.content'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_context | 766 | const | 1 | Using where; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | biotrade_bio.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.group_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:478 |
| 18 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 17 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 16 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 15 | JHtmlContent::prepare() | Same as call in the line below. |
| 14 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 13 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 12 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_articles_single/helper.php:33 |
| 11 | modArticlesSingleHelper::getItem() | JROOT/modules/mod_articles_single/mod_articles_single.php:13 |
| 10 | include JROOT/modules/mod_articles_single/mod_articles_single.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.24 ms After last query: 2.32 ms Query memory: 0.038 MB Memory before query: 5.882 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cz27f_fields AS a
LEFT JOIN `cz27f_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cz27f_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cz27f_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cz27f_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cz27f_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `cz27f_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | idx_state,idx_access,idx_context,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 25 | Using where; Using filesort |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | biotrade_bio.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | biotrade_bio.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:387 |
| 16 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:341 |
| 15 | PlgSystemFields->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
| 14 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 13 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 12 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/modules/mod_articles_single/helper.php:36 |
| 11 | modArticlesSingleHelper::getItem() | JROOT/modules/mod_articles_single/mod_articles_single.php:13 |
| 10 | include JROOT/modules/mod_articles_single/mod_articles_single.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.30 ms After last query: 7.86 ms Query memory: 0.030 MB Memory before query: 6.057 MB Rows returned: 1
SELECT *
FROM cz27f_menu
WHERE id='289'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cz27f_menu | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 12 | JDatabaseDriver->loadObject() | JROOT/modules/mod_sclogin/helper.php:306 |
| 11 | modSCLoginHelper->getLoginRedirect() | JROOT/modules/mod_sclogin/mod_sclogin.php:25 |
| 10 | include JROOT/modules/mod_sclogin/mod_sclogin.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
Query Time: 0.20 ms After last query: 1.57 ms Query memory: 0.024 MB Memory before query: 6.081 MB Rows returned: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `cz27f_menu` AS `c`
INNER JOIN `cz27f_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `cz27f_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `cz27f_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 289
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 13 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
| 12 | MenusHelper::getAssociations() | JROOT/modules/mod_languages/helper.php:58 |
| 11 | ModLanguagesHelper::getList() | JROOT/modules/mod_languages/mod_languages.php:17 |
| 10 | include JROOT/modules/mod_languages/mod_languages.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
| 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:202 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:54 |
4 × SELECT DISTINCT(user_id)
FROM cz27f_usergroups AS ug1
INNER JOIN cz27f_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN cz27f_user_usergroup_map AS m
ON ug2.id=m.group_id
2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cz27f_fields AS a
LEFT JOIN `cz27f_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cz27f_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cz27f_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cz27f_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cz27f_fields_groups AS g
ON g.id = a.group_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cz27f_extensions`
2 × SELECT `user_id`,`category_id`,`role`
FROM `cz27f_kunena_user_categories`
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `cz27f_assets`
1 × SELECT `data`
FROM `cz27f_session`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM cz27f_modules AS m
LEFT JOIN cz27f_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN cz27f_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM cz27f_kunena_categories
1 × SELECT COUNT(*)
FROM cz27f_kunena_messages AS a
1 × SELECT a.id
FROM cz27f_kunena_messages AS a
1 × SELECT *
FROM cz27f_kunena_announcement
1 × SELECT *
FROM `cz27f_kunena_ranks
1 × SELECT template
FROM cz27f_template_styles
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM cz27f_content AS a
INNER JOIN cz27f_categories AS c
on c.id = a.catid
LEFT JOIN cz27f_users AS u
on u.id = a.created_by
LEFT JOIN cz27f_categories as parent
ON parent.id = c.parent_id
LEFT JOIN cz27f_content_rating AS v
ON a.id = v.content_id
1 × SELECT `alias`
FROM `cz27f_content`
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `cz27f_categories` AS `s`
INNER JOIN `cz27f_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
1 × SELECT alias
FROM cz27f_content
1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM cz27f_fields AS a
LEFT JOIN `cz27f_languages` AS l
ON l.lang_code = a.language
LEFT JOIN cz27f_users AS uc
ON uc.id=a.checked_out
LEFT JOIN cz27f_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN cz27f_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN cz27f_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `cz27f_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT *
FROM cz27f_menu
1 × SELECT userid, MAX(time) AS time
FROM `cz27f_session`
1 × SELECT `g`.`id`,`g`.`title`
FROM `cz27f_usergroups` AS g
INNER JOIN `cz27f_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT code, location
FROM cz27f_kunena_smiley
1 × SELECT *
FROM cz27f_kunena_users_banned
1 × SELECT `session_id`
FROM `cz27f_session`
1 × SELECT *
FROM `cz27f_users`
1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM cz27f_users AS u
LEFT JOIN cz27f_kunena_users AS ku
ON u.id = ku.userid
1 × SELECT id, home, template, s.params
FROM cz27f_template_styles as s
LEFT JOIN cz27f_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM cz27f_kunena_aliases
1 × SELECT *
FROM `cz27f_kunena_configuration`
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 cz27f_menu AS m
LEFT JOIN cz27f_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `cz27f_extensions`
1 × SELECT *
FROM cz27f_languages
1 × SELECT `enabled`
FROM `cz27f_extensions`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM cz27f_extensions
1 × SELECT b.id
FROM cz27f_usergroups AS a
LEFT JOIN cz27f_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `cz27f_viewlevels
1 × SELECT `c2`.`language`,`c2`.`id`
FROM `cz27f_menu` AS `c`
INNER JOIN `cz27f_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `cz27f_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `cz27f_menu` AS `c2`
ON a2.id = c2.`id`
