Время запроса: 0.30 ms Память запроса: 0.019 MB Память до запроса: 1.702 MB Выбрано строк: 0
SELECT `data`
FROM `jpcxt_session`
WHERE `session_id` = '190164c1e7182fdfd2c266ede7bdda78'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_session | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.04 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.02 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.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.18 ms После последнего запроса: 1.21 ms Память запроса: 0.008 MB Память до запроса: 1.856 MB
DELETE
FROM `jpcxt_session`
WHERE `time` < '1539931263'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_session | range | time | time | 45 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.04 ms |
| updating | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.04 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:790 |
| 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.14 ms После последнего запроса: 0.15 ms Память запроса: 0.012 MB Память до запроса: 1.871 MB Выбрано строк: 0
SELECT `session_id`
FROM `jpcxt_session`
WHERE `session_id` = '190164c1e7182fdfd2c266ede7bdda78'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_session | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.02 ms |
| executing | 0.00 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.08 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.23 ms После последнего запроса: 0.18 ms Память запроса: 0.009 MB Память до запроса: 1.885 MB
INSERT INTO `jpcxt_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES
('190164c1e7182fdfd2c266ede7bdda78', 0, 1, '1539940263', 0, '')
EXPLAIN не доступен для запроса: INSERT INTO `jpcxt_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('190164c1e7182fdfd2c266ede7bdda78', 0, 1, '1539940263', 0, '')
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| update | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| update | 0.06 ms |
| end | 0.00 ms |
| query end | 0.04 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 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.55 ms После последнего запроса: 0.92 ms Память запроса: 0.022 MB Память до запроса: 2.066 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | extension | extension | 62 | const | 43 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.09 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.10 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 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 |
| 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.10 ms После последнего запроса: 0.70 ms Память запроса: 0.016 MB Память до запроса: 2.129 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 | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 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 |
| 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.10 ms После последнего запроса: 0.24 ms Память запроса: 0.015 MB Память до запроса: 2.149 MB Выбрано строк: 5
SELECT id, rules
FROM `jpcxt_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | ALL | NULL | Индекс не используется | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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.69 ms После последнего запроса: 0.17 ms Память запроса: 0.015 MB Память до запроса: 2.168 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | extension | extension | 62 | const | 93 | 100.00 | Using index condition; 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 |
| init | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| Creating sort index | 0.42 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.08 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 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.10 ms После последнего запроса: 10.23 ms Память запроса: 0.020 MB Память до запроса: 2.972 MB Выбрано строк: 1
Повторяющиеся запросы:
#10SELECT 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 | filtered | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | Индекс не используется | NULL | NULL | 12 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 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.06 ms После последнего запроса: 0.14 ms Память запроса: 0.021 MB Память до запроса: 2.991 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 | filtered | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | Индекс не используется | NULL | NULL | 12 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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.06 ms После последнего запроса: 2.90 ms Память запроса: 0.015 MB Память до запроса: 3.097 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_rokcommon_configs | ALL | NULL | Индекс не используется | NULL | NULL | 4 | 100.00 | Используется filesort |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 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.27 ms После последнего запроса: 4.86 ms Память запроса: 0.014 MB Память до запроса: 3.518 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 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.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.00 ms |
| storing result in query cache | 0.04 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.49 ms После последнего запроса: 4.61 ms Память запроса: 0.024 MB Память до запроса: 3.904 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 |
| checking permissions | 0.00 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 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.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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.06 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 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.29 ms После последнего запроса: 0.83 ms Память запроса: 0.016 MB Память до запроса: 3.979 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.04 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 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.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 |
| 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.28 ms После последнего запроса: 0.20 ms Память запроса: 0.020 MB Память до запроса: 3.996 MB Выбрано строк: 1
Повторяющиеся запросы:
#17SELECT *
FROM jpcxt_extensions
WHERE `extension_id` = '10035'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.07 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.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 |
| 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.21 ms После последнего запроса: 0.20 ms Память запроса: 0.016 MB Память до запроса: 4.010 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.02 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.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 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.07 ms После последнего запроса: 0.25 ms Память запроса: 0.020 MB Память до запроса: 4.026 MB Выбрано строк: 1
Повторяющиеся запросы:
#15SELECT *
FROM jpcxt_extensions
WHERE `extension_id` = '10035'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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 |
Время запроса: 1.21 ms После последнего запроса: 20.72 ms Память запроса: 0.034 MB Память до запроса: 4.382 MB Выбрано строк: 58
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 | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 74 | 100.00 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.34 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Creating sort index | 0.09 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.09 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Creating sort index | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.04 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 |
| 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.34 ms После последнего запроса: 16.33 ms Память запроса: 0.019 MB Память до запроса: 5.953 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 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.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.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.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.68 ms После последнего запроса: 0.32 ms Память запроса: 0.012 MB Память до запроса: 5.930 MB
UPDATE `jpcxt_extensions`
SET `params` = '{\"mediaversion\":\"5b4788dbf1687c37f8d168f5ada7f50f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.06 ms |
| updating | 0.08 ms |
| end | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.38 ms |
| query end | 0.06 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 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.11 ms После последнего запроса: 1.23 ms Память запроса: 0.014 MB Память до запроса: 6.113 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_languages | ALL | NULL | Индекс не используется | NULL | NULL | 2 | 100.00 | 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 |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| cleaning up | 0.00 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.56 ms После последнего запроса: 0.56 ms Память запроса: 0.011 MB Память до запроса: 6.136 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 | filtered | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | Индекс не используется | NULL | NULL | 12 | 100.00 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | shahcks_shahcks.s.template,const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.12 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.08 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 |
| 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.43 ms После последнего запроса: 5.20 ms Память запроса: 0.034 MB Память до запроса: 6.692 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 |
| checking permissions | 0.00 ms |
| Opening tables | 0.11 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 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.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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.04 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 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.06 ms После последнего запроса: 0.39 ms Память запроса: 0.028 MB Память до запроса: 6.745 MB Выбрано строк: 1
SELECT *
FROM jpcxt_assets
WHERE `id` = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_assets | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.00 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 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.07 ms После последнего запроса: 0.22 ms Память запроса: 0.024 MB Память до запроса: 6.766 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 | filtered | Extra |
|---|
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_asset_name | PRIMARY,idx_asset_name | 4,152 | NULL | 2 | 100.00 | Using union(PRIMARY,idx_asset_name); Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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.21 ms После последнего запроса: 0.74 ms Память запроса: 0.032 MB Память до запроса: 6.804 MB Выбрано строк: 221
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 | filtered | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | Индекс не используется | NULL | NULL | 332 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| cleaning up | 0.02 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.19 ms После последнего запроса: 1.10 ms Память запроса: 0.034 MB Память до запроса: 6.998 MB Выбрано строк: 221
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 | filtered | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | Индекс не используется | NULL | NULL | 332 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.04 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 |
Время запроса: 2.51 ms После последнего запроса: 2.78 ms Память запроса: 0.030 MB Память до запроса: 7.389 MB Выбрано строк: 3
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=46
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 | filtered | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Используется filesort |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 63 | 57.14 | Using where |
| 1 | PRIMARY | i | ref | idx_state,idx_catid | idx_catid | 4 | shahcks_shahcks.c.id | 2 | 100.00 | Using where |
| 1 | PRIMARY | <derived2> | ref | <auto_key0> | <auto_key0> | 4 | shahcks_shahcks.c.id | 10 | 100.00 | Using where; Not exists; Using index |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | 100.00 | Using index condition; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 63 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.17 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.06 ms |
| init | 0.07 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.09 ms |
| System lock | 0.04 ms |
| optimizing | 0.00 ms |
| optimizing | 0.02 ms |
| statistics | 0.10 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.05 ms |
| statistics | 0.20 ms |
| preparing | 0.05 ms |
| Creating tmp table | 0.08 ms |
| Sorting result | 0.00 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.19 ms |
| Creating sort index | 0.03 ms |
| removing tmp table | 0.01 ms |
| Creating sort index | 0.81 ms |
| Creating sort index | 0.04 ms |
| end | 0.00 ms |
| removing tmp table | 0.06 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.04 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.09 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 |
| cleaning up | 0.01 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.45 ms После последнего запроса: 1.90 ms Память запроса: 0.031 MB Память до запроса: 7.492 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 | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_extensions | ref | extension | extension | 62 | const | 43 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.12 ms |
| end | 0.02 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.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.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.11 ms После последнего запроса: 0.32 ms Память запроса: 0.031 MB Память до запроса: 7.530 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 | filtered | Extra |
|---|
| 1 | SIMPLE | a | ALL | idx_asset_name | Индекс не используется | NULL | NULL | 332 | 13.25 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 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.08 ms После последнего запроса: 3.12 ms Память запроса: 0.034 MB Память до запроса: 7.941 MB Выбрано строк: 1
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN 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_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 = 46
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-19 09:11:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-19 09:11:03')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Используется filesort |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 1 | 100.00 | Using where |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.created_by | 1 | 100.00 | Using where |
| 1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.modified_by | 1 | 100.00 | Using where |
| 1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | 100.00 | Using where |
| 1 | PRIMARY | <derived2> | ref | <auto_key0> | <auto_key0> | 4 | const | 10 | 100.00 | Using where; Using index |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | 100.00 | Using index condition; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 63 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.18 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.06 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.04 ms |
| optimizing | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.02 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.07 ms |
| executing | 0.00 ms |
| Sending data | 0.15 ms |
| Creating sort index | 0.02 ms |
| removing tmp table | 0.01 ms |
| Creating sort index | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 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 |
| cleaning up | 0.03 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.81 ms После последнего запроса: 1.04 ms Память запроса: 0.024 MB Память до запроса: 8.031 MB Выбрано строк: 1
SELECT COUNT(*)
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 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 = 46
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-19 09:11:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-19 09:11:03')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 1 | 100.00 | Using where |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.created_by | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.modified_by | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.id | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | <derived2> | ref | <auto_key0> | <auto_key0> | 4 | const | 10 | 100.00 | Using where; Using index |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | 100.00 | Using index condition; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 63 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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.05 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.03 ms |
| optimizing | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| Creating sort index | 0.02 ms |
| removing tmp table | 0.00 ms |
| Creating sort index | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Waiting on query cache mutex | 0.00 ms |
| freeing items | 0.09 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.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.34 ms После последнего запроса: 0.98 ms Память запроса: 0.026 MB Память до запроса: 8.136 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` = 46
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_tag_type | Индекс не используется | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | shahcks_shahcks.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| init | 0.03 ms |
| System lock | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 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.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 |
| 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 |
Время запроса: 1.31 ms После последнего запроса: 12.15 ms Память запроса: 0.039 MB Память до запроса: 8.896 MB Выбрано строк: 3
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=46
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 | filtered | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Используется filesort |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 63 | 57.14 | Using where |
| 1 | PRIMARY | <derived2> | ref | <auto_key0> | <auto_key0> | 4 | shahcks_shahcks.c.id | 10 | 100.00 | Using where; Not exists; Using index |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 10 | 100.00 | Using index condition; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 63 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.13 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 |
| init | 0.07 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.03 ms |
| optimizing | 0.00 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.00 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.15 ms |
| Creating sort index | 0.02 ms |
| removing tmp table | 0.00 ms |
| Creating sort index | 0.27 ms |
| Creating sort index | 0.03 ms |
| end | 0.00 ms |
| removing tmp table | 0.03 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.02 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.65 ms После последнего запроса: 4.60 ms Память запроса: 0.023 MB Память до запроса: 9.103 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 <= '2018-10-19 09:11:03')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-10-19 09:11:03')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 270 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 15 | 100.00 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.m.id | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | shahcks_shahcks.m.module,const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.00 ms |
| Creating sort index | 0.25 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 |
| 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 |
Время запроса: 1.20 ms После последнего запроса: 16.13 ms Память запроса: 0.033 MB Память до запроса: 9.988 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 <= '2018-10-19 09:11:03')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-19 09:11:03')
AND (a.state != -2))
AND a.id IN (190,189))
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 | filtered | Extra |
|---|
| 1 | PRIMARY | a | range | PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference | PRIMARY | 4 | NULL | 2 | 100.00 | Using where; Using temporary; Используется filesort |
| 1 | PRIMARY | c | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.catid | 1 | 100.00 | Using where |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.created_by | 1 | 100.00 | Using where |
| 1 | PRIMARY | um | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.modified_by | 1 | 100.00 | Using where |
| 1 | PRIMARY | v | ALL | PRIMARY | Индекс не используется | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 1 | PRIMARY | vl | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.a.access | 1 | 100.00 | NULL |
| 1 | PRIMARY | l | ALL | idx_langcode | Индекс не используется | NULL | NULL | 2 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 1 | PRIMARY | ct | index | NULL | idx_core_content_id | 4 | NULL | 1 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
| 1 | PRIMARY | t | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.ct.tag_id | 1 | 100.00 | Using index |
| 1 | PRIMARY | <derived2> | ALL | NULL | Индекс не используется | NULL | NULL | 40 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 2 | DERIVED | rsi | ALL | idx_module,idx_module_order | Индекс не используется | NULL | NULL | 40 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| checking permissions | 0.00 ms |
| Opening tables | 0.08 ms |
| init | 0.08 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.19 ms |
| optimizing | 0.00 ms |
| optimizing | 0.02 ms |
| statistics | 0.01 ms |
| preparing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.05 ms |
| Creating tmp table | 0.06 ms |
| Sorting result | 0.00 ms |
| executing | 0.01 ms |
| Sending data | 0.15 ms |
| Creating sort index | 0.02 ms |
| end | 0.00 ms |
| removing tmp table | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.00 ms |
| closing tables | 0.04 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.02 ms |
| storing result in query cache | 0.03 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.11 ms После последнего запроса: 0.79 ms Память запроса: 0.028 MB Память до запроса: 10.047 MB Выбрано строк: 2
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 | filtered | Extra |
|---|
| 1 | SIMPLE | i | ref | idx_module,idx_module_order | idx_module | 137 | const | 2 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.00 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 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 |
Время запроса: 0.24 ms После последнего запроса: 7.73 ms Память запроса: 0.032 MB Память до запроса: 10.169 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 | filtered | Extra |
|---|
| 1 | SIMPLE | sp | ref | PRIMARY,id_category | id_category | 3 | const | 1 | 100.00 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | st | eq_ref | PRIMARY | PRIMARY | 3 | shahcks_shahcks.sp.id_template | 1 | 100.00 | NULL |
| 1 | SIMPLE | sa | ref | id_poll | id_poll | 4 | shahcks_shahcks.sp.id | 3 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.11 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 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.17 ms После последнего запроса: 1.09 ms Память запроса: 0.019 MB Память до запроса: 10.278 MB Выбрано строк: 1
Повторяющиеся запросы:
#40SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.09 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 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.05 ms После последнего запроса: 0.09 ms Память запроса: 0.019 MB Память до запроса: 10.295 MB Выбрано строк: 1
Повторяющиеся запросы:
#39SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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.05 ms После последнего запроса: 0.14 ms Память запроса: 0.018 MB Память до запроса: 10.312 MB Выбрано строк: 1
Повторяющиеся запросы:
#42SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 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.06 ms После последнего запроса: 0.08 ms Память запроса: 0.018 MB Память до запроса: 10.329 MB Выбрано строк: 1
Повторяющиеся запросы:
#41SELECT `rules`
FROM jpcxt_viewlevels
WHERE id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_viewlevels | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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 |
Время запроса: 0.05 ms После последнего запроса: 0.15 ms Память запроса: 0.019 MB Память до запроса: 10.346 MB Выбрано строк: 0
Повторяющиеся запросы:
#44SELECT 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.89.34'
ORDER BY sv.`date` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | sa | ref | PRIMARY,id_poll | id_poll | 4 | const | 2 | 100.00 | Using temporary; Используется filesort |
| 1 | SIMPLE | sv | ref | id_answer | id_answer | 4 | shahcks_shahcks.sa.id | 29 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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.08 ms Память запроса: 0.019 MB Память до запроса: 10.363 MB Выбрано строк: 0
Повторяющиеся запросы:
#43SELECT 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.89.34'
ORDER BY sv.`date` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | sa | ref | PRIMARY,id_poll | id_poll | 4 | const | 2 | 100.00 | Using temporary; Используется filesort |
| 1 | SIMPLE | sv | ref | id_answer | id_answer | 4 | shahcks_shahcks.sa.id | 29 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 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 |
| 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.05 ms После последнего запроса: 0.57 ms Память запроса: 0.019 MB Память до запроса: 10.402 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 | filtered | Extra |
|---|
| 1 | SIMPLE | sa | ref | PRIMARY,id_poll | id_poll | 4 | const | 2 | 100.00 | NULL |
| 1 | SIMPLE | sv | ref | id_answer | id_answer | 4 | shahcks_shahcks.sa.id | 29 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 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 |
| 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.48 ms После последнего запроса: 23.41 ms Память запроса: 0.037 MB Память до запроса: 11.001 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 |
| checking permissions | 0.00 ms |
| Opening tables | 0.16 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 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.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 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.04 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 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 |
Время запроса: 0.16 ms После последнего запроса: 1.90 ms Память запроса: 0.041 MB Память до запроса: 11.139 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 | filtered | Extra |
|---|
| 1 | PRIMARY | c | ALL | cat_idx,idx_access | Индекс не используется | NULL | NULL | 63 | 19.05 | Using where; Using temporary; Используется filesort |
| 1 | PRIMARY | <derived2> | ref | <auto_key0> | <auto_key0> | 4 | shahcks_shahcks.c.id | 10 | 100.00 | Using where; Not exists; Using index |
| 2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | 100.00 | Using index condition; Using temporary; Используется filesort |
| 2 | DERIVED | cat | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 63 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.04 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| cleaning up | 0.00 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 |
Время запроса: 0.10 ms После последнего запроса: 0.72 ms Память запроса: 0.029 MB Память до запроса: 11.240 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 | filtered | Extra |
|---|
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_language | cat_idx | 157 | NULL | 10 | 100.00 | Using index condition; Using where; Используется filesort |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| init | 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 |
| 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.12 ms После последнего запроса: 0.91 ms Память запроса: 0.044 MB Память до запроса: 11.279 MB Выбрано строк: 0
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 >= '2018-10-01 00:00:00'
AND rpt.startrepeat <= '2018-10-31 23:59:59'
AND NOT (rpt.startrepeat < '2018-10-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 | filtered | Extra |
|---|
| 1 | SIMPLE | icsf | system | PRIMARY,stateidx | Индекс не используется | NULL | NULL | 1 | 100.00 | NULL |
| 1 | SIMPLE | rpt | range | eventid,eventstart,eventend,startrepeat,startend,endrepeat | endrepeat | 8 | NULL | 2 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | ev | eq_ref | PRIMARY,icsid,stateidx,evaccess | PRIMARY | 4 | shahcks_shahcks.rpt.eventid | 1 | 100.00 | Using where |
| 1 | SIMPLE | det | eq_ref | PRIMARY | PRIMARY | 4 | shahcks_shahcks.rpt.eventdetail_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | rr | ref | eventid | eventid | 4 | shahcks_shahcks.rpt.eventid | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 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 |
| sending cached result to clien | 0.01 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 |
Время запроса: 185.69 ms После последнего запроса: 60.90 ms Память запроса: 17.403 MB Память до запроса: 11.989 MB Выбрано строк: 227860
select *
from jpcxt_jvcounter_logs
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_jvcounter_logs | ALL | NULL | Индекс не используется | NULL | NULL | 227861 | 100.00 | NULL |
| Status | Duration |
|---|
| 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.14 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 ms |
| Sending data | 0.19 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 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 |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.04 ms |
| Sending data | 0.21 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 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.10 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.12 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.13 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.13 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.14 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.10 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| Sending data | 0.27 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.06 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.14 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.15 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 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.11 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.01 ms |
| Sending data | 0.18 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.03 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.09 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 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.11 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.02 ms |
| Sending data | 167.96 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 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.29 ms После последнего запроса: 1307.27 ms Память запроса: 0.018 MB Память до запроса: 492.513 MB Выбрано строк: 1
select *
from jpcxt_session
where session_id = '190164c1e7182fdfd2c266ede7bdda78'
and client_id=0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | jpcxt_session | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.03 ms |
| init | 0.00 ms |
| checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Waiting on query cache mutex | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 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.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.12 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 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.50 ms После последнего запроса: 0.25 ms Память запроса: 0.013 MB Память до запроса: 492.530 MB
INSERT INTO jpcxt_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl)
VALUES('190164c1e7182fdfd2c266ede7bdda78','0','54.224.89.34','1539940263','1539940263','0','CCBot/2.0 (https://commoncrawl.org/faq/)','','')
EXPLAIN не доступен для запроса: INSERT INTO jpcxt_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl) VALUES('190164c1e7182fdfd2c266ede7bdda78','0','54.224.89.34','1539940263','1539940263','0','CCBot/2.0 (https://commoncrawl.org/faq/)','','')
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| update | 0.39 ms |
| Waiting for query cache lock | 0.00 ms |
| update | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.03 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/database.php:33 |
| 10 | JDatabase->query() | JROOT/plugins/system/jvcounter/jvcounter.php:95 |
| 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 |
4 × SELECT `rules`
FROM jpcxt_viewlevels
2 × SELECT sv.`ip`,sv.`date`
FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa
ON sa.id_poll = '2'
2 × SELECT *
FROM jpcxt_extensions
2 × SELECT template
FROM jpcxt_template_styles as s
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
2 × SELECT `extension_id`
FROM `jpcxt_extensions`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jpcxt_extensions`
1 × 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
1 × select *
from jpcxt_session
1 × SELECT `m`.`tag_id`,`t`.*
FROM `jpcxt_contentitem_tag_map` AS m
INNER JOIN `jpcxt_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN 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_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
1 × SELECT COUNT(*)
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 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
1 × 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
1 × 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
1 × 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
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'
1 × SELECT a.name, a.rules
FROM jpcxt_assets AS a
1 × select *
from jpcxt_jvcounter_log
1 × SELECT c.id
FROM jpcxt_categories AS c
1 × SELECT i.provider_id as id, i.
order, i.params
FROM jpcxt_roksprocket_items as i
1 × SELECT a.id, a.name, a.rules
FROM jpcxt_assets AS a
1 × SELECT extension, file, type
FROM jpcxt_rokcommon_configs
1 × SELECT `enabled`
FROM `jpcxt_extensions`
1 × SELECT folder AS type, element AS name, params
FROM jpcxt_extensions
1 × SELECT id, rules
FROM `jpcxt_viewlevels
1 × SELECT `session_id`
FROM `jpcxt_session`
1 × SELECT b.id
FROM jpcxt_usergroups AS a
LEFT JOIN jpcxt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jpcxt_menu AS m
LEFT JOIN jpcxt_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM jpcxt_languages
1 × SELECT `data`
FROM `jpcxt_session`
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,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
1 × SELECT a.id, a.parent_id
FROM jpcxt_assets AS a
1 × SELECT a.rules
FROM jpcxt_assets AS a
1 × 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
1 × SELECT *
FROM jpcxt_assets
1 × SELECT element
FROM jpcxt_extensions
9 Мая в д. Мелёшиха у памятника погибшим воинам-землякам, традиционно прошёл митинг-концерт «Славному подвигу нет забвения», на который пришли все неравнодушные жители д. Мелёшиха.
