Време на заявката: 1.46 ms Памет за заявки: 0.025 MB Памет преди заявката: 1.204 MB Върнати редове: 0
SELECT `data`
FROM `cz27f_session`
WHERE `session_id` = '610ae4f351290acf584e929738500181'
| 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.07 ms |
| Waiting for query cache lock | 0.04 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.05 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.03 ms |
| Statistics | 0.61 ms |
| Preparing | 0.03 ms |
| Executing | 0.03 ms |
| End of update loop | 0.02 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.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.04 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.44 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.70 ms След последната заявка: 0.53 ms Памет за заявки: 0.022 MB Памет преди заявката: 1.283 MB Върнати редове: 0
SELECT `session_id`
FROM `cz27f_session`
WHERE `session_id` = '610ae4f351290acf584e929738500181'
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.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.04 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.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 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.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.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.57 ms След последната заявка: 0.10 ms Памет за заявки: 0.004 MB Памет преди заявката: 1.288 MB
INSERT INTO `cz27f_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('610ae4f351290acf584e929738500181', 1, 1749456552, 0, '', 0)
Не е възможно обяснение за заявката: INSERT INTO `cz27f_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('610ae4f351290acf584e929738500181', 1, 1749456552, 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.06 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 |
| init for update | 0.03 ms |
| Update | 0.10 ms |
| Waiting for query cache lock | 0.03 ms |
| Update | 0.32 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.64 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 2.54 ms След последната заявка: 1.10 ms Памет за заявки: 0.030 MB Памет преди заявката: 1.324 MB Върнати редове: 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.05 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.12 ms |
| Preparing | 0.07 ms |
| Executing | 0.03 ms |
| Sending data | 1.58 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.02 ms |
| Updating status | 0.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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}() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.30 ms След последната заявка: 1.29 ms Памет за заявки: 0.023 MB Памет преди заявката: 1.359 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 4 | |
| 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.23 ms След последната заявка: 0.11 ms Памет за заявки: 0.022 MB Памет преди заявката: 1.370 MB Върнати редове: 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 2.51 ms След последната заявка: 0.22 ms Памет за заявки: 0.039 MB Памет преди заявката: 1.393 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 262 | 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.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.04 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.59 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.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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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}() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.89 ms След последната заявка: 4.09 ms Памет за заявки: 0.026 MB Памет преди заявката: 1.899 MB Върнати редове: 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.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.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.12 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.03 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.02 ms |
| Storing result in query cache | 0.43 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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}() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 1.86 ms След последната заявка: 0.19 ms Памет за заявки: 0.006 MB Памет преди заявката: 1.892 MB
UPDATE `cz27f_extensions`
SET `params` = '{\"mediaversion\":\"c7d33335ddcee35a4cfc1f22e268be3f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Не е възможно обяснение за заявката: UPDATE `cz27f_extensions`
SET `params` = '{\"mediaversion\":\"c7d33335ddcee35a4cfc1f22e268be3f\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.04 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.07 ms |
| Updating | 0.12 ms |
| End of update loop | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| End of update loop | 0.42 ms |
| Query end | 0.02 ms |
| Commit | 0.52 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.80 ms След последната заявка: 1.48 ms Памет за заявки: 0.022 MB Памет преди заявката: 2.005 MB Върнати редове: 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.03 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.04 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.04 ms |
| init | 0.03 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.04 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.02 ms |
| Storing result in query cache | 0.17 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.24 ms След последната заявка: 1.94 ms Памет за заявки: 0.027 MB Памет преди заявката: 2.189 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 3 | 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.78 ms След последната заявка: 0.16 ms Памет за заявки: 0.023 MB Памет преди заявката: 2.263 MB Върнати редове: 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.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.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.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 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.02 ms |
| Storing result in query cache | 0.09 ms |
| Reset for next command | 0.03 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 4.82 ms След последната заявка: 9.19 ms Памет за заявки: 0.196 MB Памет преди заявката: 2.342 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 313 | Using where; Използване на файлове сортиране |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | biotrade_bio.m.component_id | 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.10 ms |
| checking permissions | 0.03 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.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.08 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 2.43 ms |
| Waiting for query cache lock | 0.03 ms |
| Creating sort index | 0.12 ms |
| Waiting for query cache lock | 0.02 ms |
| Creating sort index | 0.14 ms |
| Waiting for query cache lock | 0.02 ms |
| Creating sort index | 0.17 ms |
| Waiting for query cache lock | 0.02 ms |
| Creating sort index | 0.32 ms |
| Waiting for query cache lock | 0.02 ms |
| Creating sort index | 0.21 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.38 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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}() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.30 ms След последната заявка: 11.02 ms Памет за заявки: 0.027 MB Памет преди заявката: 3.822 MB Върнати редове: 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.07 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.22 ms След последната заявка: 1.23 ms Памет за заявки: 0.024 MB Памет преди заявката: 3.925 MB Върнати редове: 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.37 ms След последната заявка: 0.40 ms Памет за заявки: 0.021 MB Памет преди заявката: 3.949 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 7 | Using where; 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.10 ms |
| checking permissions | 0.03 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.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.11 ms |
| Preparing | 0.07 ms |
| Executing | 0.02 ms |
| Sending data | 0.40 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.03 ms |
| closing tables | 0.03 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.02 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.31 ms След последната заявка: 1.93 ms Памет за заявки: 0.029 MB Памет преди заявката: 4.055 MB Върнати редове: 5
SHOW FULL COLUMNS
FROM `cz27f_kunena_sessions`
Не е възможно обяснение за заявката: SHOW FULL COLUMNS FROM `cz27f_kunena_sessions`
| Status | Duration |
|---|
| Starting | 0.05 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.03 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.06 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.03 ms |
| Executing | 0.03 ms |
| Sending data | 0.05 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.32 ms След последната заявка: 3.39 ms Памет за заявки: 0.040 MB Памет преди заявката: 4.209 MB Върнати редове: 55
SHOW FULL COLUMNS
FROM `cz27f_kunena_users`
Не е възможно обяснение за заявката: SHOW FULL COLUMNS FROM `cz27f_kunena_users`
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.30 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.14 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.10 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.04 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.23 ms След последната заявка: 3.00 ms Памет за заявки: 0.031 MB Памет преди заявката: 4.425 MB Върнати редове: 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.03 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.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.21 ms След последната заявка: 0.48 ms Памет за заявки: 0.026 MB Памет преди заявката: 4.486 MB Върнати редове: 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.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.03 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.19 ms След последната заявка: 0.10 ms Памет за заявки: 0.026 MB Памет преди заявката: 4.495 MB Върнати редове: 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.19 ms След последната заявка: 0.09 ms Памет за заявки: 0.024 MB Памет преди заявката: 4.504 MB Върнати редове: 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.79 ms След последната заявка: 0.57 ms Памет за заявки: 0.047 MB Памет преди заявката: 4.593 MB Върнати редове: 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 = 1747
| 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.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.05 ms |
| After opening tables | 0.03 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.04 ms |
| Statistics | 0.79 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 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.17 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.29 ms След последната заявка: 1.89 ms Памет за заявки: 0.034 MB Памет преди заявката: 4.647 MB Върнати редове: 16
SHOW FULL COLUMNS
FROM `cz27f_users`
Не е възможно обяснение за заявката: SHOW FULL COLUMNS FROM `cz27f_users`
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.03 ms |
| closing tables | 0.03 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.33 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 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.08 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 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.03 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.80 ms След последната заявка: 0.13 ms Памет за заявки: 0.031 MB Памет преди заявката: 4.687 MB Върнати редове: 1
SELECT *
FROM `cz27f_users`
WHERE `id` = 1747
| 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.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.03 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.05 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.03 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.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.04 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.12 ms След последната заявка: 0.37 ms Памет за заявки: 0.027 MB Памет преди заявката: 4.703 MB Върнати редове: 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` = 1747
| 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.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.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.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.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.80 ms След последната заявка: 0.32 ms Памет за заявки: 0.008 MB Памет преди заявката: 4.727 MB
UPDATE `cz27f_kunena_users`
SET `view`='',`signature`='face shield mask The face achievement also helps at guardian the eyes
from irritants annex infections. It additionally contains a certain hermetic mask ventilation opening thus that the aerate inside is fit annex oxygenated.Many doctors shoplift nurses be disposed to disposable masks. They are at hand since they be up to be extant thrown away after certain aught aeon of once. They are again least grasshopper than those fortunate of polymer or lead.Disposable masks avow for quicker handling. Being a result, they save brace time annex hard pull when disposing of old masks
and replace them in keeping with contemporary ones.',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='659',`personalText`='',`gender`='1',`birthdate`='2020-04-13',`location`='Krasnystaw',`websitename`='face shield mask',`websiteurl`='http://protective-mask.xyz',`rank`='0',`hideEmail`='1',`showOnline`='1',`icq`='695544768',`yim`='warlikeskit87',`microsoft`='',`skype`='ekijabow',`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`='1747'
Не е възможно обяснение за заявката: UPDATE `cz27f_kunena_users` SET `view`='',`signature`='face shield mask The face achievement also helps at guardian the eyes from irritants annex infections. It additionally contains a certain hermetic mask ventilation opening thus that the aerate inside is fit annex oxygenated.Many doctors shoplift nurses be disposed to disposable masks. They are at hand since they be up to be extant thrown away after certain aught aeon of once. They are again least grasshopper than those fortunate of polymer or lead.Disposable masks avow for quicker handling. Being a result, they save brace time annex hard pull when disposing of old masks and replace them in keeping with contemporary ones.',`moderator`='0',`ordering`='0',`posts`='0',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='659',`personalText`='',`gender`='1',`birthdate`='2020-04-13',`location`='Krasnystaw',`websitename`='face shield mask',`websiteurl`='http://protective-mask.xyz',`rank`='0',`hideEmail`='1',`showOnline`='1',`icq`='695544768',`yim`='warlikeskit87',`microsoft`='',`skype`='ekijabow',`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`='1747'
| 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.09 ms |
| Updating | 0.79 ms |
| End of update loop | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.41 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.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.20 ms След последната заявка: 0.14 ms Памет за заявки: 0.027 MB Памет преди заявката: 4.729 MB Върнати редове: 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.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.18 ms След последната заявка: 0.10 ms Памет за заявки: 0.027 MB Памет преди заявката: 4.740 MB Върнати редове: 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.17 ms След последната заявка: 0.09 ms Памет за заявки: 0.027 MB Памет преди заявката: 4.750 MB Върнати редове: 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.19 ms След последната заявка: 1.25 ms Памет за заявки: 0.034 MB Памет преди заявката: 4.851 MB Върнати редове: 13
SHOW FULL COLUMNS
FROM `cz27f_kunena_users_banned`
Не е възможно обяснение за заявката: SHOW FULL COLUMNS FROM `cz27f_kunena_users_banned`
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.32 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.02 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.07 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.10 ms След последната заявка: 0.21 ms Памет за заявки: 0.031 MB Памет преди заявката: 4.885 MB Върнати редове: 0
SELECT *
FROM cz27f_kunena_users_banned
WHERE userid = '1747'
AND (expiration = '0000-00-00 00:00:00' OR expiration > '2025-06-09 08:09:12')
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.05 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.08 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.02 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.02 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| Updating status | 0.28 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.23 ms След последната заявка: 1.38 ms Памет за заявки: 0.036 MB Памет преди заявката: 5.012 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | 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.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.25 ms След последната заявка: 0.92 ms Памет за заявки: 0.030 MB Памет преди заявката: 5.050 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | 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.03 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.17 ms След последната заявка: 0.75 ms Памет за заявки: 0.031 MB Памет преди заявката: 5.092 MB Върнати редове: 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; Използване на файлове сортиране |
| 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.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.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.04 ms |
| Creating tmp table | 0.04 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.03 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.26 ms |
| Waiting for query cache lock | 0.02 ms |
| Updating status | 0.03 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 2.80 ms След последната заявка: 2.82 ms Памет за заявки: 0.034 MB Памет преди заявката: 5.167 MB Върнати редове: 12
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-09 08:09:12')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-09 08:09:12')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 289 OR mm.menuid <= 0)
AND m.language IN ('bg-BG','*')
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; Използване на файлове сортиране |
| 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.10 ms |
| checking permissions | 0.03 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.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.76 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.03 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 26 | JDatabaseDriver->loadObjectList() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.24 ms След последната заявка: 0.80 ms Памет за заявки: 0.059 MB Памет преди заявката: 5.189 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 25 | Използване на файлове сортиране |
| 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.87 ms След последната заявка: 0.81 ms Памет за заявки: 0.027 MB Памет преди заявката: 5.418 MB Върнати редове: 1
SELECT COUNT(*)
FROM cz27f_kunena_messages AS a
WHERE a.userid=1747
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.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.05 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 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.02 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.88 ms След последната заявка: 0.61 ms Памет за заявки: 0.028 MB Памет преди заявката: 5.436 MB Върнати редове: 0
SELECT a.id
FROM cz27f_kunena_messages AS a
WHERE a.userid=1747
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; Използване на файлове сортиране |
| 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.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.09 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.02 ms |
| Creating sort index | 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.04 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.03 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.24 ms След последната заявка: 6.21 ms Памет за заявки: 0.035 MB Памет преди заявката: 5.476 MB Върнати редове: 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; Използване на файлове сортиране |
| 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.02 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.27 ms След последната заявка: 5.37 ms Памет за заявки: 0.028 MB Памет преди заявката: 5.611 MB Върнати редове: 0
SELECT *
FROM cz27f_kunena_announcement
WHERE (published = 1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-06-09 08:09:12')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-06-09 08:09:12')
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.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.05 ms |
| init | 0.06 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.04 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.39 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.04 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.02 ms |
| Storing result in query cache | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.21 ms След последната заявка: 2.52 ms Памет за заявки: 0.023 MB Памет преди заявката: 5.620 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | 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.03 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.36 ms След последната заявка: 6.23 ms Памет за заявки: 0.049 MB Памет преди заявката: 5.813 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 341 | Using where |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| Waiting for query cache lock | 0.04 ms |
| starting | 0.02 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.03 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 1.52 ms След последната заявка: 0.41 ms Памет за заявки: 0.036 MB Памет преди заявката: 5.988 MB Върнати редове: 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 = 105
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-09 08:09:12')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-09 08:09:12')
| 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.04 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.02 ms |
| Checking query cache for query | 0.23 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.11 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.17 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 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.03 ms |
| Query end | 0.04 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.03 ms |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.24 ms След последната заявка: 0.29 ms Памет за заявки: 0.028 MB Памет преди заявката: 6.009 MB Върнати редове: 1
SELECT `alias`
FROM `cz27f_content`
WHERE id = '105'
| 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.03 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 22 | JDatabaseDriver->loadResult() | JROOT/components/com_content/router.php:125 |
| 21 | ContentRouter->getArticleSegment() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.23 ms След последната заявка: 0.49 ms Памет за заявки: 0.040 MB Памет преди заявката: 6.026 MB Върнати редове: 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 ('bg-BG','*')) 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.20 ms След последната заявка: 0.31 ms Памет за заявки: 0.027 MB Памет преди заявката: 6.046 MB Върнати редове: 1
SELECT alias
FROM cz27f_content
WHERE id=105
| 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.21 ms След последната заявка: 0.39 ms Памет за заявки: 0.039 MB Памет преди заявката: 6.059 MB Върнати редове: 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; Използване на файлове сортиране |
| 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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() | Също като извикването на реда долу. |
| 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 |
Време на заявката: 0.21 ms След последната заявка: 0.80 ms Памет за заявки: 0.038 MB Памет преди заявката: 6.074 MB Върнати редове: 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 ('*','bg-BG')
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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 25 | Using where; Използване на файлове сортиране |
| 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.21 ms След последната заявка: 5.76 ms Памет за заявки: 0.030 MB Памет преди заявката: 6.258 MB Върнати редове: 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.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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 |
Време на заявката: 0.20 ms След последната заявка: 1.40 ms Памет за заявки: 0.024 MB Памет преди заявката: 6.287 MB Върнати редове: 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 | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | 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.03 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 |
| # | Извиква се от | Файл и номер на ред |
|---|
| 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 ('bg-BG','*')) 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`
Тази уеб платформа е изготвена с финансовата помощ на Европейския съюз чрез ИНТЕРРЕГ-ИПП трансгранична програма България – Македония, CCI N