Время запроса: 0.24 ms Память запроса: 0.019 MB Память до запроса: 1.686 MB Выбрано строк: 0
SELECT `data`
FROM `jpcxt_session`
WHERE `session_id` = '5fa82c2acfd5f19ea59d8caa8e93740a'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_session | const | PRIMARY | PRIMARY | 575 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:44 |
| 12 | JSessionStorageDatabase->read() | Same as call in the line below. |
| 11 | session_start() | JROOT/libraries/joomla/session/handler/native.php:259 |
| 10 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:49 |
| 9 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:81 |
| 8 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:636 |
| 7 | JSession->_start() | JROOT/libraries/joomla/session/session.php:596 |
| 6 | JSession->start() | JROOT/libraries/cms/application/cms.php:773 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.30 ms После последнего запроса: 2.33 ms Память запроса: 0.012 MB Память до запроса: 1.839 MB Выбрано строк: 0
SELECT `session_id`
FROM `jpcxt_session`
WHERE `session_id` = '5fa82c2acfd5f19ea59d8caa8e93740a'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_session | const | PRIMARY | PRIMARY | 575 | const | 1 | Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.05 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.12 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:799 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.41 ms После последнего запроса: 0.18 ms Память запроса: 0.009 MB Память до запроса: 1.854 MB
INSERT INTO `jpcxt_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES
('5fa82c2acfd5f19ea59d8caa8e93740a', 0, 1, '1506014646', 0, '')
EXPLAIN не доступен для запроса: INSERT INTO `jpcxt_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('5fa82c2acfd5f19ea59d8caa8e93740a', 0, 1, '1506014646', 0, '')
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| init | 0.01 ms |
| update | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| update | 0.24 ms |
| end | 0.00 ms |
| query end | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:212 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:799 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.57 ms После последнего запроса: 1.84 ms Память запроса: 0.022 MB Память до запроса: 2.040 MB Выбрано строк: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jpcxt_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | extension | extension | 62 | const | 43 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.05 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.21 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 9 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:448 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:120 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:589 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.30 ms После последнего запроса: 1.28 ms Память запроса: 0.016 MB Память до запроса: 2.103 MB Выбрано строк: 2
SELECT b.id
FROM jpcxt_usergroups AS a
LEFT JOIN jpcxt_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 | 3 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:835 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:904 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.17 ms После последнего запроса: 0.49 ms Память запроса: 0.015 MB Память до запроса: 2.123 MB Выбрано строк: 5
SELECT id, rules
FROM `jpcxt_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | ALL | NULL | Индекс не используется | NULL | NULL | 5 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:921 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.92 ms После последнего запроса: 0.18 ms Память запроса: 0.015 MB Память до запроса: 2.142 MB Выбрано строк: 74
SELECT folder AS type, element AS name, params
FROM jpcxt_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 | jpcxt_extensions | ref | extension | extension | 62 | const | 93 | Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.04 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.28 ms |
| Sending data | 0.17 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.22 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:310 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.38 ms После последнего запроса: 17.66 ms Память запроса: 0.020 MB Память до запроса: 2.942 MB Выбрано строк: 1
Повторяющиеся запросы:
#9SELECT template
FROM jpcxt_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | Индекс не используется | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:96 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:255 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.04 ms После последнего запроса: 0.14 ms Память запроса: 0.021 MB Память до запроса: 2.961 MB Выбрано строк: 1
Повторяющиеся запросы:
#8SELECT template
FROM jpcxt_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | Индекс не используется | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.00 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:96 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:54 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:255 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.18 ms После последнего запроса: 5.71 ms Память запроса: 0.015 MB Память до запроса: 3.067 MB Выбрано строк: 4
SELECT extension, file, type
FROM jpcxt_rokcommon_configs
ORDER BY priority
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_rokcommon_configs | ALL | NULL | Индекс не используется | NULL | NULL | 4 | Используется filesort |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.33 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:132 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:76 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/cms/plugin/helper.php:255 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.54 ms После последнего запроса: 16.10 ms Память запроса: 0.014 MB Память до запроса: 3.486 MB Выбрано строк: 1
SELECT `enabled`
FROM `jpcxt_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.29 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.26 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:50 |
| 7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/cms/plugin/helper.php:230 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.36 ms После последнего запроса: 9.27 ms Память запроса: 0.024 MB Память до запроса: 3.870 MB Выбрано строк: 17
SHOW FULL COLUMNS
FROM `jpcxt_extensions`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `jpcxt_extensions`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.10 ms |
| System lock | 0.01 ms |
| init | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 12 | JTable->__construct() | JROOT/libraries/joomla/table/extension.php:31 |
| 11 | JTableExtension->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 10 | JTable::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 |
| 9 | plgSystemRokSprocket->onAfterInitialise() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 1.23 ms Память запроса: 0.016 MB Память до запроса: 3.945 MB Выбрано строк: 1
SELECT `extension_id`
FROM `jpcxt_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 11 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/table/extension.php:109 |
| 10 | JTableExtension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:49 |
| 9 | plgSystemRokSprocket->onAfterInitialise() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.15 ms После последнего запроса: 0.20 ms Память запроса: 0.020 MB Память до запроса: 3.962 MB Выбрано строк: 1
Повторяющиеся запросы:
#16SELECT *
FROM jpcxt_extensions
WHERE `extension_id` = '10035'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.03 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.11 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 10 | JTable->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 |
| 9 | plgSystemRokSprocket->onAfterInitialise() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.29 ms После последнего запроса: 0.19 ms Память запроса: 0.016 MB Память до запроса: 3.976 MB Выбрано строк: 1
SELECT `extension_id`
FROM `jpcxt_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.13 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 11 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/table/extension.php:109 |
| 10 | JTableExtension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:72 |
| 9 | plgSystemRokSprocket->onAfterInitialise() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.04 ms После последнего запроса: 0.16 ms Память запроса: 0.020 MB Память до запроса: 3.992 MB Выбрано строк: 1
Повторяющиеся запросы:
#14SELECT *
FROM jpcxt_extensions
WHERE `extension_id` = '10035'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.00 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 10 | JTable->load() | JROOT/plugins/system/roksprocket/roksprocket.php:76 |
| 9 | plgSystemRokSprocket->onAfterInitialise() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:670 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.82 ms После последнего запроса: 25.41 ms Память запроса: 0.035 MB Память до запроса: 4.347 MB Выбрано строк: 59
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 jpcxt_menu AS m
LEFT JOIN jpcxt_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 74 | Using where; Используется filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.m.component_id | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.05 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.17 ms |
| Sending data | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
| 14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:145 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:439 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:57 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:197 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:535 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:407 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1115 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.21 ms После последнего запроса: 22.42 ms Память запроса: 0.019 MB Память до запроса: 5.892 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jpcxt_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 13 | JDatabaseDriver->loadObject() | Same as call in the line below. |
| 12 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 11 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:156 |
| 10 | JLibraryHelper::_load() | JROOT/libraries/cms/library/helper.php:47 |
| 9 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:90 |
| 8 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:274 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:977 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.41 ms После последнего запроса: 0.25 ms Память запроса: 0.012 MB Память до запроса: 5.868 MB
UPDATE `jpcxt_extensions`
SET `params` = '{\"mediaversion\":\"3796711d8f9d5b174d2ff64b8f913d1c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN не доступен для запроса: UPDATE `jpcxt_extensions`
SET `params` = '{\"mediaversion\":\"3796711d8f9d5b174d2ff64b8f913d1c\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| init | 0.03 ms |
| Updating | 0.04 ms |
| end | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.17 ms |
| query end | 0.11 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:119 |
| 9 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:325 |
| 8 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:284 |
| 7 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 6 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 5 | JFactory::getDocument() | JROOT/libraries/joomla/application/web.php:977 |
| 4 | JApplicationWeb->loadDocument() | JROOT/libraries/cms/application/site.php:130 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 1.51 ms Память запроса: 0.014 MB Память до запроса: 6.051 MB Выбрано строк: 2
SELECT *
FROM jpcxt_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_languages | ALL | NULL | Индекс не используется | NULL | NULL | 2 | Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.04 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number | | 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:164 |
| 5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:329 |
| 4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.39 ms После последнего запроса: 0.51 ms Память запроса: 0.011 MB Память до запроса: 6.073 MB Выбрано строк: 10
SELECT id, home, template, s.params
FROM jpcxt_template_styles as s
LEFT JOIN jpcxt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | Индекс не используется | NULL | NULL | 12 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | shahcks_shahcks.s.template,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:484 |
| 4 | JApplicationSite->getTemplate() | JROOT/libraries/cms/application/site.php:165 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.30 ms После последнего запроса: 8.24 ms Память запроса: 0.034 MB Память до запроса: 6.629 MB Выбрано строк: 8
SHOW FULL COLUMNS
FROM `jpcxt_assets`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `jpcxt_assets`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| System lock | 0.01 ms |
| init | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 21 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 20 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
| 19 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 18 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:696 |
| 17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.27 ms После последнего запроса: 0.28 ms Память запроса: 0.028 MB Память до запроса: 6.682 MB Выбрано строк: 1
SELECT *
FROM jpcxt_assets
WHERE `id` = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_assets | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.05 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 18 | JTable->load() | JROOT/libraries/joomla/access/access.php:697 |
| 17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.22 ms После последнего запроса: 0.18 ms Память запроса: 0.024 MB Память до запроса: 6.703 MB Выбрано строк: 1
SELECT a.rules
FROM jpcxt_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_asset_name | PRIMARY,idx_asset_name | 4,152 | NULL | 2 | Using union(PRIMARY,idx_asset_name); Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.43 ms После последнего запроса: 0.95 ms Память запроса: 0.032 MB Память до запроса: 6.740 MB Выбрано строк: 213
SELECT a.id, a.parent_id
FROM jpcxt_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | Индекс не используется | NULL | NULL | 326 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.20 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:332 |
| 18 | JAccess::preloadPermissionsParentIdMapping() | JROOT/libraries/joomla/access/access.php:240 |
| 17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.43 ms После последнего запроса: 1.36 ms Память запроса: 0.034 MB Память до запроса: 6.929 MB Выбрано строк: 213
SELECT a.id, a.name, a.rules
FROM jpcxt_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | Индекс не используется | NULL | NULL | 326 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1255 |
| 19 | JDatabaseDriver->getIterator() | JROOT/libraries/joomla/access/access.php:373 |
| 18 | JAccess::preloadPermissions() | JROOT/libraries/joomla/access/access.php:243 |
| 17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.15 ms После последнего запроса: 2.81 ms Память запроса: 0.030 MB Память до запроса: 7.311 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,COUNT(i.`id`) AS numitems
FROM jpcxt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN jpcxt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `jpcxt_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND badcats.id is null
AND s.id=24
GROUP BY 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
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; Используется filesort |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 59 | Using where |
| 1 | PRIMARY | i | ref | idx_state,idx_catid | idx_catid | 4 | shahcks_shahcks.c.id | 4 | |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 10 | Using where; Not exists |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | Using where; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 59 | Using where; Using index; Using join buffer |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.12 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.11 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.01 ms |
| removing tmp table | 0.00 ms |
| Sending data | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.11 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.23 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| removing tmp table | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 15 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 14 | JCategories->get() | JROOT/components/com_content/models/category.php:354 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:115 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.26 ms После последнего запроса: 1.68 ms Память запроса: 0.031 MB Память до запроса: 7.408 MB Выбрано строк: 43
SELECT element
FROM jpcxt_extensions
WHERE type = 'component'
AND enabled = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | extension | extension | 62 | const | 43 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 22 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:413 |
| 21 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 20 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 18 | JUser->authorise() | JROOT/components/com_content/models/articles.php:466 |
| 17 | ContentModelArticles->getListQuery() | JROOT/libraries/legacy/model/list.php:129 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.94 ms После последнего запроса: 0.27 ms Память запроса: 0.031 MB Память до запроса: 7.446 MB Выбрано строк: 43
SELECT a.name, a.rules
FROM jpcxt_assets AS a
WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_finder','com_installer','com_jce','com_jevents','com_joomgallery','com_joomlaupdate','com_jsecure','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_rokgallery','com_roksprocket','com_search','com_sexypolling','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | idx_asset_name | Индекс не используется | NULL | NULL | 326 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.06 ms |
| init | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.15 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.48 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 22 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:441 |
| 21 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 20 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 18 | JUser->authorise() | JROOT/components/com_content/models/articles.php:466 |
| 17 | ContentModelArticles->getListQuery() | JROOT/libraries/legacy/model/list.php:129 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.19 ms После последнего запроса: 2.80 ms Память запроса: 0.041 MB Память до запроса: 7.857 MB Выбрано строк: 3
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jpcxt_content AS a
LEFT JOIN jpcxt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jpcxt_categories AS c
ON c.id = a.catid
LEFT JOIN jpcxt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jpcxt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jpcxt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jpcxt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 24
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-21 17:24:06')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-21 17:24:06')
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 50
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using temporary; Используется filesort |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 4 | Using where |
| 1 | PRIMARY | fp | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.created_by | 1 | |
| 1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.modified_by | 1 | |
| 1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 10 | Using where |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | Using where; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 59 | Using where; Using index; Using join buffer |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.12 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.13 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.01 ms |
| removing tmp table | 0.00 ms |
| Sending data | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| init | 0.11 ms |
| optimizing | 0.03 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.11 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.20 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| removing tmp table | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:310 |
| 16 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.62 ms После последнего запроса: 1.46 ms Память запроса: 0.024 MB Память до запроса: 8.009 MB Выбрано строк: 1
SELECT COUNT(*)
FROM jpcxt_content AS a
LEFT JOIN jpcxt_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jpcxt_categories AS c
ON c.id = a.catid
LEFT JOIN jpcxt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jpcxt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jpcxt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jpcxt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 24
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-21 17:24:06')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-21 17:24:06')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 4 | Using where |
| 1 | PRIMARY | fp | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | Using index |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.created_by | 1 | Using index |
| 1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.modified_by | 1 | Using index |
| 1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | Using index |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 10 | Using where |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | Using where; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 59 | Using where; Using index; Using join buffer |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.12 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.01 ms |
| removing tmp table | 0.00 ms |
| Sending data | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/legacy/model/legacy.php:337 |
| 16 | JModelLegacy->_getListCount() | JROOT/libraries/legacy/model/list.php:278 |
| 15 | JModelList->getTotal() | JROOT/libraries/legacy/model/list.php:228 |
| 14 | JModelList->getPagination() | JROOT/components/com_content/models/category.php:265 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.25 ms После последнего запроса: 1.27 ms Память запроса: 0.026 MB Память до запроса: 8.111 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jpcxt_contentitem_tag_map` AS m
INNER JOIN `jpcxt_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 24
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | Индекс не используется | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | shahcks_shahcks.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.05 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:435 |
| 12 | JHelperTags->getItemTags() | JROOT/libraries/legacy/view/category.php:217 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.88 ms После последнего запроса: 28.73 ms Память запроса: 0.039 MB Память до запроса: 8.970 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 jpcxt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN jpcxt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.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 badcats.id is null
AND s.id=24
GROUP BY 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
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; Используется filesort |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 59 | Using where |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 10 | Using where; Not exists |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | Using where; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 59 | Using where; Using index; Using join buffer |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.10 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.01 ms |
| removing tmp table | 0.00 ms |
| Sending data | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.03 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.09 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.13 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| removing tmp table | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 22 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 21 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
| 20 | ContentHelperRoute::getArticleRoute() | JROOT/templates/dd_musicpassion_30/library/Artx/Content/ListItem.php:15 |
| 19 | ArtxContentListItem->__construct() | JROOT/templates/dd_musicpassion_30/library/Artx/Content/CategoryArticle.php:10 |
| 18 | ArtxContentCategoryArticle->__construct() | JROOT/templates/dd_musicpassion_30/library/Artx/Content.php:47 |
| 17 | ArtxContent->article() | JROOT/templates/dd_musicpassion_30/html/com_content/category/blog_item.php:14 |
| 16 | include JROOT/templates/dd_musicpassion_30/html/com_content/category/blog_item.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 15 | JViewLegacy->loadTemplate() | JROOT/templates/dd_musicpassion_30/html/com_content/category/blog.php:43 |
| 14 | include JROOT/templates/dd_musicpassion_30/html/com_content/category/blog.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:216 |
| 12 | JViewLegacy->display() | JROOT/libraries/legacy/view/category.php:233 |
| 11 | JViewCategory->display() | JROOT/components/com_content/views/category/view.html.php:258 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.52 ms После последнего запроса: 8.71 ms Память запроса: 0.023 MB Память до запроса: 9.208 MB Выбрано строк: 8
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jpcxt_modules AS m
LEFT JOIN jpcxt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jpcxt_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 <= '2017-09-21 17:24:06')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-21 17:24:06')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
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 | published | 1 | const | 14 | Using where; Используется filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.m.id | 1 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | shahcks_shahcks.m.module,const | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.08 ms |
| Sending data | 0.14 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 14 | call_user_func_array() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 13 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:425 |
| 12 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:361 |
| 11 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 10 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:501 |
| 9 | JDocumentHtml->countModules() | JROOT/templates/dd_musicpassion_30/library/Artx/Page.php:43 |
| 8 | ArtxPage->containsModules() | JROOT/templates/dd_musicpassion_30/index.php:107 |
| 7 | require JROOT/templates/dd_musicpassion_30/index.php | JROOT/libraries/joomla/document/html.php:578 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:640 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:455 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1072 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.90 ms После последнего запроса: 19.38 ms Память запроса: 0.034 MB Память до запроса: 10.030 MB Выбрано строк: 5
SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
FROM jpcxt_content as a
LEFT JOIN jpcxt_categories AS c
ON c.id = a.catid
LEFT JOIN jpcxt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jpcxt_users AS um
ON um.id = a.modified_by
LEFT JOIN jpcxt_content_rating AS v
ON a.id = v.content_id
LEFT JOIN jpcxt_viewlevels AS vl
ON a.access = vl.id
LEFT JOIN jpcxt_languages AS l
ON a.language = l.lang_code
LEFT JOIN jpcxt_contentitem_tag_map AS ct
ON ct.content_item_id = a.id
LEFT JOIN jpcxt_tags AS t
ON t.id = ct.tag_id
LEFT
OUTER JOIN (select rsi.provider_id, rsi.
order
from jpcxt_roksprocket_items as rsi
where module_id = 148) rsi
on a.id = rsi.provider_id
WHERE ((a.access IN(1,1,5)
AND (a.state = 1 or a.state = 2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-21 17:24:06')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-21 17:24:06')
AND (a.state != -2))
AND a.id IN (173,162,50,174,175))
GROUP BY id
ORDER BY IF(ISNULL(rsi.
order),1,0),rsi.
order
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | range | PRIMARY,idx_access,idx_state | PRIMARY | 4 | NULL | 5 | Using where; Using temporary; Используется filesort |
| 1 | PRIMARY | c | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.catid | 1 | |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.created_by | 1 | |
| 1 | PRIMARY | um | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.modified_by | 1 | |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | |
| 1 | PRIMARY | vl | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.access | 1 | |
| 1 | PRIMARY | l | eq_ref | idx_langcode | idx_langcode | 21 | shahcks_shahcks.a.language | 1 | |
| 1 | PRIMARY | ct | index | NULL | idx_core_content_id | 4 | NULL | 1 | Using index |
| 1 | PRIMARY | t | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.ct.tag_id | 1 | Using index |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 5 | |
| 2 | DERIVED | rsi | ALL | idx_module,idx_module_order | Индекс не используется | NULL | NULL | 41 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| System lock | 0.03 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.03 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.08 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.18 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| removing tmp table | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58 |
| 18 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 17 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 16 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 15 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 14 | ModRokSprocket->_realGetData() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 12 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 11 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 10 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.15 ms После последнего запроса: 0.83 ms Память запроса: 0.029 MB Память до запроса: 10.102 MB Выбрано строк: 0
SELECT ct.content_item_id as article_id, t.title as tag
FROM jpcxt_contentitem_tag_map as ct
LEFT JOIN jpcxt_tags AS t
ON t.id = ct.tag_id
WHERE ct.content_item_id in (173,50,175,174,162)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ct | index | NULL | idx_core_content_id | 4 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.ct.tag_id | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.23 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 21 | JDatabaseDriver->loadAssocList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26 |
| 20 | RokSprocket_Provider_Joomla_TagMerge->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159 |
| 19 | RokSprocket_Provider_Joomla->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62 |
| 18 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 17 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 16 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 15 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 14 | ModRokSprocket->_realGetData() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 12 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 11 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 10 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.84 ms После последнего запроса: 2.50 ms Память запроса: 0.039 MB Память до запроса: 10.249 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 jpcxt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN jpcxt_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.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 badcats.id is null
AND s.id=29
GROUP BY 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
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; Используется filesort |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 59 | Using where |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 10 | Using where; Not exists |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | Using where; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 59 | Using where; Using index; Using join buffer |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.10 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.01 ms |
| removing tmp table | 0.00 ms |
| Sending data | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.02 ms |
| init | 0.04 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.08 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.14 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| removing tmp table | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.08 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 23 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 22 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
| 21 | ContentHelperRoute::getArticleRoute() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:93 |
| 20 | RokSprocket_Provider_Joomla->convertRawToItem() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:83 |
| 19 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->convertRawToItems() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:63 |
| 18 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 17 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 16 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 15 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 14 | ModRokSprocket->_realGetData() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 12 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 11 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 10 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.70 ms После последнего запроса: 2.75 ms Память запроса: 0.028 MB Память до запроса: 10.329 MB Выбрано строк: 5
SELECT i.provider_id as id, i.
order, i.params
FROM jpcxt_roksprocket_items as i
WHERE i.module_id = '148'
AND i.provider = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | idx_module,idx_module_order | idx_module | 137 | const | 5 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.45 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139 |
| 19 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64 |
| 18 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 17 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 16 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 15 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 14 | ModRokSprocket->_realGetData() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 12 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 11 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 10 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.10 ms После последнего запроса: 18.22 ms Память запроса: 0.033 MB Память до запроса: 10.586 MB Выбрано строк: 0
SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
FROM jpcxt_content as a
LEFT JOIN jpcxt_categories AS c
ON c.id = a.catid
LEFT JOIN jpcxt_users AS ua
ON ua.id = a.created_by
LEFT JOIN jpcxt_users AS um
ON um.id = a.modified_by
LEFT JOIN jpcxt_content_rating AS v
ON a.id = v.content_id
LEFT JOIN jpcxt_viewlevels AS vl
ON a.access = vl.id
LEFT JOIN jpcxt_languages AS l
ON a.language = l.lang_code
LEFT JOIN jpcxt_contentitem_tag_map AS ct
ON ct.content_item_id = a.id
LEFT JOIN jpcxt_tags AS t
ON t.id = ct.tag_id
LEFT
OUTER JOIN (select rsi.provider_id, rsi.
order
from jpcxt_roksprocket_items as rsi
where module_id = 112) rsi
on a.id = rsi.provider_id
WHERE ((a.access IN(1,1,5)
AND (a.state = 1 or a.state = 2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-21 17:24:06')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-21 17:24:06')
AND (a.state != -2))
AND a.id IN (150,144,149))
GROUP BY id
ORDER BY IF(ISNULL(rsi.
order),1,0),rsi.
order,a.title ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | a | range | PRIMARY,idx_access,idx_state | PRIMARY | 4 | NULL | 3 | Using where; Using temporary; Используется filesort |
| 1 | PRIMARY | c | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.catid | 1 | |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.created_by | 1 | |
| 1 | PRIMARY | um | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.modified_by | 1 | |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | |
| 1 | PRIMARY | vl | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.access | 1 | |
| 1 | PRIMARY | l | eq_ref | idx_langcode | idx_langcode | 21 | shahcks_shahcks.a.language | 1 | |
| 1 | PRIMARY | ct | index | NULL | idx_core_content_id | 4 | NULL | 1 | Using index |
| 1 | PRIMARY | t | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.ct.tag_id | 1 | Using index |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 3 | |
| 2 | DERIVED | rsi | ALL | idx_module,idx_module_order | Индекс не используется | NULL | NULL | 41 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.26 ms |
| checking query cache for query | 0.11 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| System lock | 0.03 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.06 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.10 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.06 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| removing tmp table | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58 |
| 18 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 17 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 16 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 15 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 14 | ModRokSprocket->_realGetData() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 12 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 11 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 10 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.50 ms После последнего запроса: 0.32 ms Память запроса: 0.028 MB Память до запроса: 10.621 MB Выбрано строк: 3
SELECT i.provider_id as id, i.
order, i.params
FROM jpcxt_roksprocket_items as i
WHERE i.module_id = '112'
AND i.provider = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | idx_module,idx_module_order | idx_module | 137 | const | 3 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.25 ms |
| freeing items | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139 |
| 19 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64 |
| 18 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 17 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 16 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 15 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 14 | ModRokSprocket->_realGetData() | Same as call in the line below. |
| 13 | call_user_func_array() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 12 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 11 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 10 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.52 ms После последнего запроса: 8.27 ms Память запроса: 0.032 MB Память до запроса: 10.673 MB Выбрано строк: 3
SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.showresultsduringpoll showresultsduringpoll, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name
FROM `jpcxt_sexy_polls` sp JOIN `jpcxt_sexy_answers` sa
ON sa.id_poll = sp.id
AND sa.published = '1'
LEFT JOIN `jpcxt_sexy_templates` st
ON st.id = sp.id_template
WHERE sp.published = '1'
AND sp.id_category = 2
ORDER BY sp.ordering,sp.name,sa.ordering,sa.name
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | sp | ref | PRIMARY,id_category | id_category | 3 | const | 1 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | sa | ref | id_poll | id_poll | 4 | shahcks_shahcks.sp.id | 2 | Using where |
| 1 | SIMPLE | st | eq_ref | PRIMARY | PRIMARY | 3 | shahcks_shahcks.sp.id_template | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.07 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 ms |
| init | 0.04 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.08 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.07 ms |
| Sorting result | 0.03 ms |
| Sending data | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.14 ms |
| Sending data | 0.15 ms |
| end | 0.00 ms |
| removing tmp table | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.55 ms |
| freeing items | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.14 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sexypolling/helpers/helper.php:133 |
| 12 | SexypollingHelper->get_data() | JROOT/components/com_sexypolling/helpers/helper.php:160 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.65 ms После последнего запроса: 1.35 ms Память запроса: 0.019 MB Память до запроса: 10.783 MB Выбрано строк: 1
Повторяющиеся запросы:
#43SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.38 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.19 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.05 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 12 | JDatabase->query() | JROOT/components/com_sexypolling/helpers/helper.php:241 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.13 ms После последнего запроса: 0.11 ms Память запроса: 0.019 MB Память до запроса: 10.801 MB Выбрано строк: 1
Повторяющиеся запросы:
#42SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.00 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 12 | JDatabaseDriver->loadResult() | JROOT/components/com_sexypolling/helpers/helper.php:242 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.40 ms После последнего запроса: 0.16 ms Память запроса: 0.019 MB Память до запроса: 10.817 MB Выбрано строк: 1
Повторяющиеся запросы:
#45SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.08 ms |
| checking query cache for query | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.13 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.06 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 12 | JDatabase->query() | JROOT/components/com_sexypolling/helpers/helper.php:254 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.21 ms После последнего запроса: 0.10 ms Память запроса: 0.019 MB Память до запроса: 10.835 MB Выбрано строк: 1
Повторяющиеся запросы:
#44SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.12 ms |
| checking query cache for query | 0.00 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 12 | JDatabaseDriver->loadResult() | JROOT/components/com_sexypolling/helpers/helper.php:255 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.11 ms После последнего запроса: 0.18 ms Память запроса: 0.019 MB Память до запроса: 10.851 MB Выбрано строк: 0
Повторяющиеся запросы:
#47SELECT sv.`ip`,sv.`date`
FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa
ON sa.id_poll = '2'
WHERE sv.id_answer = sa.id
AND sv.ip = '54.224.214.93'
ORDER BY sv.`date` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | sa | ref | PRIMARY,id_poll | id_poll | 4 | const | 2 | Using temporary; Используется filesort |
| 1 | SIMPLE | sv | ref | id_answer | id_answer | 4 | shahcks_shahcks.sa.id | 42 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.49 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.06 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.04 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.00 ms |
| end | 0.00 ms |
| removing tmp table | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.22 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.07 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.03 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 12 | JDatabase->query() | JROOT/components/com_sexypolling/helpers/helper.php:303 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.05 ms После последнего запроса: 0.10 ms Память запроса: 0.019 MB Память до запроса: 10.869 MB Выбрано строк: 0
Повторяющиеся запросы:
#46SELECT sv.`ip`,sv.`date`
FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa
ON sa.id_poll = '2'
WHERE sv.id_answer = sa.id
AND sv.ip = '54.224.214.93'
ORDER BY sv.`date` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | sa | ref | PRIMARY,id_poll | id_poll | 4 | const | 2 | Using temporary; Используется filesort |
| 1 | SIMPLE | sv | ref | id_answer | id_answer | 4 | shahcks_shahcks.sa.id | 42 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.00 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 12 | JDatabaseDriver->loadAssoc() | JROOT/components/com_sexypolling/helpers/helper.php:305 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.94 ms После последнего запроса: 0.77 ms Память запроса: 0.019 MB Память до запроса: 10.907 MB Выбрано строк: 1
SELECT COUNT(sv.`id_answer`) total_count, MAX(sv.`date`) max_date,MIN(sv.`date`) min_date
FROM `jpcxt_sexy_votes` sv JOIN `jpcxt_sexy_answers` sa
ON sa.id_poll = '2'
WHERE sv.id_answer = sa.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | sa | ref | PRIMARY,id_poll | id_poll | 4 | const | 2 | |
| 1 | SIMPLE | sv | ref | id_answer | id_answer | 4 | shahcks_shahcks.sa.id | 42 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.59 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.09 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.04 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 12 | JDatabaseDriver->loadAssoc() | JROOT/components/com_sexypolling/helpers/helper.php:444 |
| 11 | SexypollingHelper->render_html() | JROOT/modules/mod_sexypolling/mod_sexypolling.php:32 |
| 10 | include JROOT/modules/mod_sexypolling/mod_sexypolling.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.43 ms После последнего запроса: 16.48 ms Память запроса: 0.037 MB Память до запроса: 11.410 MB Выбрано строк: 18
SHOW FULL COLUMNS
FROM `jpcxt_jev_users`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `jpcxt_jev_users`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.12 ms |
| System lock | 0.00 ms |
| init | 0.03 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 23 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 22 | JTable->__construct() | JROOT/administrator/components/com_jevents/tables/jevuser.php:69 |
| 21 | TableUser->__construct() | JROOT/components/com_jevents/libraries/helper.php:2173 |
| 20 | JEVHelper::getAuthorisedUser() | JROOT/components/com_jevents/libraries/helper.php:1094 |
| 19 | JEVHelper::isEventCreator() | JROOT/components/com_jevents/libraries/filters/Published.php:50 |
| 18 | jevPublishedFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:140 |
| 17 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:198 |
| 16 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:2252 |
| 15 | JEventsDBModel->listIcalEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2623 |
| 14 | JEventsDBModel->listIcalEventsByMonth() | JROOT/components/com_jevents/libraries/datamodel.php:243 |
| 13 | JEventsDataModel->getCalendarData() | JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77 |
| 12 | FlatModCalView->_displayCalendarMod() | JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491 |
| 11 | DefaultModCalView->getCal() | JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46 |
| 10 | include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 2.00 ms После последнего запроса: 2.61 ms Память запроса: 0.041 MB Память до запроса: 11.547 MB Выбрано строк: 10
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 jpcxt_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_jevents'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | cat_idx,idx_access | Индекс не используется | NULL | NULL | 59 | Using where; Using temporary; Используется filesort |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 1 | Using where; Not exists |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | Using where; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | idx_left_right | idx_left_right | 8 | NULL | 59 | Using where; Using index; Using join buffer |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.07 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.02 ms |
| removing tmp table | 0.00 ms |
| Sending data | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.59 ms |
| Sending data | 0.03 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.15 ms |
| executing | 0.00 ms |
| Copying to tmp table | 0.23 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| removing tmp table | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.26 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number | | 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 23 | JCategories->_load() | JROOT/components/com_jevents/helpers/category.php:47 |
| 22 | JEventsCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 21 | JCategories->get() | JROOT/components/com_jevents/libraries/dbmodel.php:90 |
| 20 | JEventsDBModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/datamodel.php:886 |
| 19 | JEventsDataModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/filters/Category.php:39 |
| 18 | jevCategoryFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:140 |
| 17 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:198 |
| 16 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:2252 |
| 15 | JEventsDBModel->listIcalEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2623 |
| 14 | JEventsDBModel->listIcalEventsByMonth() | JROOT/components/com_jevents/libraries/datamodel.php:243 |
| 13 | JEventsDataModel->getCalendarData() | JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77 |
| 12 | FlatModCalView->_displayCalendarMod() | JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491 |
| 11 | DefaultModCalView->getCal() | JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46 |
| 10 | include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.83 ms После последнего запроса: 0.74 ms Память запроса: 0.029 MB Память до запроса: 11.648 MB Выбрано строк: 9
SELECT c.id
FROM jpcxt_categories AS c
WHERE c.access IN (1,1,5)
AND c.published = 1
AND c.language in ('ru-RU','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft asc
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_language | cat_idx | 157 | NULL | 10 | Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sorting result | 0.06 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 1.46 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 21 | JDatabaseDriver->loadColumn() | JROOT/components/com_jevents/libraries/dbmodel.php:160 |
| 20 | JEventsDBModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/datamodel.php:886 |
| 19 | JEventsDataModel->accessibleCategoryList() | JROOT/components/com_jevents/libraries/filters/Category.php:39 |
| 18 | jevCategoryFilter->__construct() | JROOT/components/com_jevents/libraries/filters.php:140 |
| 17 | jevFilterProcessing->__construct() | JROOT/components/com_jevents/libraries/filters.php:198 |
| 16 | jevFilterProcessing::getInstance() | JROOT/components/com_jevents/libraries/dbmodel.php:2252 |
| 15 | JEventsDBModel->listIcalEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2623 |
| 14 | JEventsDBModel->listIcalEventsByMonth() | JROOT/components/com_jevents/libraries/datamodel.php:243 |
| 13 | JEventsDataModel->getCalendarData() | JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77 |
| 12 | FlatModCalView->_displayCalendarMod() | JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491 |
| 11 | DefaultModCalView->getCal() | JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46 |
| 10 | include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.67 ms После последнего запроса: 1.39 ms Память запроса: 0.046 MB Память до запроса: 11.686 MB Выбрано строк: 4
SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.state as published, ev.created as created
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM jpcxt_jevents_repetition as rpt
LEFT JOIN jpcxt_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jpcxt_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jpcxt_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jpcxt_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,54,55,56,57,58,59,60,61,62)
AND rpt.endrepeat >= '2017-09-01 00:00:00'
AND rpt.startrepeat <= '2017-09-30 23:59:59'
AND NOT (rpt.startrepeat < '2017-09-01 00:00:00'
AND det.multiday=0)
AND ev.state=1
AND ev.access IN (1,1,5)
AND icsf.state=1
AND icsf.access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | icsf | system | PRIMARY,stateidx | Индекс не используется | NULL | NULL | 1 | |
| 1 | SIMPLE | rpt | range | eventid,eventstart,eventend,startrepeat,startend,endrepeat | endrepeat | 8 | NULL | 4 | Using where |
| 1 | SIMPLE | ev | eq_ref | PRIMARY,icsid,stateidx,evaccess | PRIMARY | 4 | shahcks_shahcks.rpt.eventid | 1 | Using where |
| 1 | SIMPLE | det | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.rpt.eventdetail_id | 1 | Using where |
| 1 | SIMPLE | rr | ref | eventid | eventid | 4 | shahcks_shahcks.rpt.eventid | 1 | |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 ms |
| init | 0.05 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/dbmodel.php:2499 |
| 16 | JEventsDBModel->_cachedlistIcalEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2448 |
| 15 | JEventsDBModel->listIcalEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2623 |
| 14 | JEventsDBModel->listIcalEventsByMonth() | JROOT/components/com_jevents/libraries/datamodel.php:243 |
| 13 | JEventsDataModel->getCalendarData() | JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77 |
| 12 | FlatModCalView->_displayCalendarMod() | JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491 |
| 11 | DefaultModCalView->getCal() | JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46 |
| 10 | include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.17 ms После последнего запроса: 2.22 ms Память запроса: 0.028 MB Память до запроса: 11.953 MB Выбрано строк: 0
SELECT *, summary as title, description as content
FROM jpcxt_jevents_translation
WHERE evdet_id IN(115,116,117,118)
AND language='ru-RU'
| 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.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.05 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jevents/libraries/dbmodel.php:2568 |
| 17 | JEventsDBModel::translateEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2528 |
| 16 | JEventsDBModel->_cachedlistIcalEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2448 |
| 15 | JEventsDBModel->listIcalEvents() | JROOT/components/com_jevents/libraries/dbmodel.php:2623 |
| 14 | JEventsDBModel->listIcalEventsByMonth() | JROOT/components/com_jevents/libraries/datamodel.php:243 |
| 13 | JEventsDataModel->getCalendarData() | JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77 |
| 12 | FlatModCalView->_displayCalendarMod() | JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491 |
| 11 | DefaultModCalView->getCal() | JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46 |
| 10 | include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 70.64 ms После последнего запроса: 56.75 ms Память запроса: 7.005 MB Память до запроса: 12.401 MB Выбрано строк: 91574
select *
from jpcxt_jvcounter_logs
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_jvcounter_logs | ALL | NULL | Индекс не используется | NULL | NULL | 91575 | |
| Status | Duration |
|---|
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 62.77 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jvcounter/jvcounter.php:107 |
| 10 | plgSystemJVCounter->getDataLogs() | JROOT/plugins/system/jvcounter/jvcounter.php:48 |
| 9 | plgSystemJVCounter->saveData() | JROOT/plugins/system/jvcounter/jvcounter.php:24 |
| 8 | plgSystemJVCounter->onAfterRender() | Same as call in the line below. |
| 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1092 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.74 ms После последнего запроса: 567.58 ms Память запроса: 0.018 MB Память до запроса: 207.498 MB Выбрано строк: 1
select *
from jpcxt_session
where session_id = '5fa82c2acfd5f19ea59d8caa8e93740a'
and client_id=0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | jpcxt_session | const | PRIMARY | PRIMARY | 575 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.33 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.11 ms |
| logging slow query | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jvcounter/jvcounter.php:123 |
| 10 | plgSystemJVCounter->getSession() | JROOT/plugins/system/jvcounter/jvcounter.php:50 |
| 9 | plgSystemJVCounter->saveData() | JROOT/plugins/system/jvcounter/jvcounter.php:24 |
| 8 | plgSystemJVCounter->onAfterRender() | Same as call in the line below. |
| 7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1092 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.53 ms После последнего запроса: 0.22 ms Память запроса: 0.013 MB Память до запроса: 207.515 MB
Дорогие друзья
ОЧЕНЬ ВАЖНАЯ ИНФОРМАЦИЯ
мы приготовили для вас настоящий сюрприз
