Время запроса: 0.31 ms Память запроса: 0.020 MB Память до запроса: 0.661 MB Выбрано строк: 0
SELECT `session_id`
FROM `new_session`
WHERE `session_id` = '124a6cbe2579031d388ed2c9d3f61781'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:831 |
| 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:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.24 ms После последнего запроса: 0.06 ms Память запроса: 0.003 MB Память до запроса: 0.666 MB
INSERT INTO `new_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('124a6cbe2579031d388ed2c9d3f61781', 1, '1732364528', 0, '', 0)
EXPLAIN не доступен для запроса: INSERT INTO `new_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('124a6cbe2579031d388ed2c9d3f61781', 1, '1732364528', 0, '', 0)
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init for update | 0.02 ms |
| Update | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Update | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:216 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:831 |
| 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:413 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Время запроса: 0.51 ms После последнего запроса: 0.22 ms Память запроса: 0.040 MB Память до запроса: 0.690 MB Выбрано строк: 48
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `new_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | ref | extension | extension | 82 | const | 39 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.21 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/component/helper.php:447 |
| 8 | JComponentHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:455 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:111 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:593 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.08 ms После последнего запроса: 0.31 ms Память запроса: 0.021 MB Память до запроса: 0.729 MB Выбрано строк: 5
SELECT id, rules
FROM `new_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_viewlevels | ALL | NULL | Индекс не используется | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:1061 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 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:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.06 ms Память запроса: 0.021 MB Память до запроса: 0.742 MB Выбрано строк: 2
SELECT b.id
FROM new_usergroups AS a
LEFT JOIN new_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:1093 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:309 |
| 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:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.89 ms После последнего запроса: 0.10 ms Память запроса: 0.030 MB Память до запроса: 0.763 MB Выбрано строк: 123
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM new_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | ALL | extension | Индекс не используется | NULL | NULL | 302 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.56 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:327 |
| 8 | JPluginHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/plugin/helper.php:332 |
| 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:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.09 ms После последнего запроса: 4.44 ms Память запроса: 0.021 MB Память до запроса: 1.340 MB Выбрано строк: 0
SELECT `path`
FROM new_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.04 ms Память запроса: 0.021 MB Память до запроса: 1.345 MB Выбрано строк: 0
SELECT `file`
FROM new_rsfirewall_hashes
WHERE `type`='protect'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_rsfirewall_hashes | ALL | NULL | Индекс не используется | NULL | NULL | 236 | Using where |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.03 ms Память запроса: 0.025 MB Память до запроса: 1.351 MB Выбрано строк: 52
SELECT *
FROM new_rsfirewall_configuration
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_rsfirewall_configuration | ALL | NULL | Индекс не используется | NULL | NULL | 52 | |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 |
| 10 | RSFirewallConfig->load() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 |
| 9 | RSFirewallConfig->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 |
| 8 | RSFirewallConfig::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:28 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.59 ms После последнего запроса: 1.60 ms Память запроса: 0.024 MB Память до запроса: 1.575 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `new_rsfirewall_logs`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `new_rsfirewall_logs`
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| closing tables | 0.00 ms |
| Opening tables | 0.23 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.06 ms |
| closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.08 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 12 | JTable->__construct() | JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 |
| 11 | RSFirewallTableLogs->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 10 | JTable::getInstance() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 |
| 9 | RSFirewallLogger->__construct() | JROOT/administrator/components/com_rsfirewall/helpers/log.php:57 |
| 8 | RSFirewallLogger::getInstance() | JROOT/plugins/system/rsfirewall/rsfirewall.php:50 |
| 7 | plgSystemRSFirewall->__construct() | JROOT/libraries/cms/plugin/helper.php:271 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:181 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.72 ms После последнего запроса: 2.68 ms Память запроса: 0.027 MB Память до запроса: 1.770 MB Выбрано строк: 169
SHOW TABLES
EXPLAIN не доступен для запроса: SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.00 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.00 ms |
| checking permissions | 0.45 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:497 |
| 10 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68 |
| 9 | JSNConfigHelper::get() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114 |
| 8 | PlgSystemJSNMobilize->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.10 ms После последнего запроса: 0.12 ms Память запроса: 0.021 MB Память до запроса: 1.797 MB Выбрано строк: 8
SELECT name,value
FROM new_jsn_mobilize_config
WHERE 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jsn_mobilize_config | ALL | NULL | Индекс не используется | NULL | NULL | 8 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81 |
| 9 | JSNConfigHelper::get() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114 |
| 8 | PlgSystemJSNMobilize->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.08 ms После последнего запроса: 0.23 ms Память запроса: 0.021 MB Память до запроса: 1.787 MB Выбрано строк: 1
Повторяющиеся запросы:
#24SELECT *
FROM new_jsn_mobilize_os
WHERE os_type = 'other'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jsn_mobilize_os | ALL | NULL | Индекс не используется | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:445 |
| 10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
| 9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 |
| 8 | PlgSystemJSNMobilize->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.08 ms После последнего запроса: 0.25 ms Память запроса: 0.021 MB Память до запроса: 1.795 MB Выбрано строк: 1
Повторяющиеся запросы:
#25SELECT *
FROM new_jsn_mobilize_profiles AS p
INNER JOIN new_jsn_mobilize_os_support AS s
ON s.profile_id = p.profile_id
WHERE s.os_id = '11'
AND p.profile_state = 1
AND p.profile_device = "jsn_mobile"
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | p | system | PRIMARY | Индекс не используется | NULL | NULL | 1 | |
| 1 | SIMPLE | s | ALL | NULL | Индекс не используется | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 11 | JDatabaseDriver->loadObject() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:512 |
| 10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
| 9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 |
| 8 | PlgSystemJSNMobilize->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.10 ms После последнего запроса: 0.06 ms Память запроса: 0.070 MB Память до запроса: 1.800 MB Выбрано строк: 24
Повторяющиеся запросы:
#26SELECT *
FROM new_jsn_mobilize_design
WHERE profile_id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jsn_mobilize_design | ALL | NULL | Индекс не используется | NULL | NULL | 24 | Using where |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:519 |
| 10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
| 9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 |
| 8 | PlgSystemJSNMobilize->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.05 ms После последнего запроса: 0.59 ms Память запроса: 0.089 MB Память до запроса: 1.831 MB Выбрано строк: 43
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 new_menu AS m
LEFT JOIN new_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 11 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.44 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.13 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:88 |
| 20 | JMenuSite->{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 19 | JCacheControllerCallback->get() | JROOT/libraries/cms/menu/site.php:96 |
| 18 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 17 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 16 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:129 |
| 15 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:444 |
| 14 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 13 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:59 |
| 12 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:198 |
| 11 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:549 |
| 10 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:402 |
| 9 | JApplicationSite::getRouter() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170 |
| 8 | PlgSystemJSNMobilize->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:684 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.41 ms После последнего запроса: 4.70 ms Память запроса: 0.022 MB Память до запроса: 2.241 MB Выбрано строк: 0
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 new_categories as c
LEFT JOIN new_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 s.id=8857
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.09 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.00 ms |
| Executing | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 12 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 11 | JCategories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/cms/component/router/view.php:263 |
| 9 | JComponentRouterView->parse() | JROOT/libraries/cms/router/site.php:432 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:236 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1146 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.24 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB Память до запроса: 2.247 MB Выбрано строк: 1
SELECT `alias`,`catid`
FROM `new_content`
WHERE `id` = 8857
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
| 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/cms/component/router/view.php:263 |
| 9 | JComponentRouterView->parse() | JROOT/libraries/cms/router/site.php:432 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:483 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:236 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1146 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.09 ms После последнего запроса: 0.22 ms Память запроса: 0.020 MB Память до запроса: 2.253 MB Выбрано строк: 0
SELECT *
FROM new_rsfirewall_hashes
WHERE (`type`='3.7.5' OR `type`='protect')
AND `flag`!='C'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_rsfirewall_hashes | ALL | NULL | Индекс не используется | NULL | NULL | 236 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:974 |
| 8 | plgSystemRSFirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.10 ms Память запроса: 0.021 MB Память до запроса: 2.260 MB Выбрано строк: 0
SELECT *
FROM new_rsfirewall_snapshots
WHERE `type`='protect'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 |
| 9 | RSFirewallSnapshot::get() | JROOT/plugins/system/rsfirewall/rsfirewall.php:997 |
| 8 | plgSystemRSFirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.20 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB Память до запроса: 2.266 MB Выбрано строк: 0
SELECT `ip`,`reason`
FROM new_rsfirewall_lists
WHERE (`ip`='3.144.38.184' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:168 |
| 10 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:147 |
| 9 | plgSystemRSFirewall->isWhitelisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1033 |
| 8 | plgSystemRSFirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.20 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB Память до запроса: 2.272 MB Выбрано строк: 0
SELECT `ip`,`reason`
FROM new_rsfirewall_lists
WHERE (`ip`='3.144.38.184' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:168 |
| 10 | plgSystemRSFirewall->isListed() | JROOT/plugins/system/rsfirewall/rsfirewall.php:137 |
| 9 | plgSystemRSFirewall->isBlacklisted() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1037 |
| 8 | plgSystemRSFirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.08 ms После последнего запроса: 0.25 ms Память запроса: 0.021 MB Память до запроса: 2.279 MB Выбрано строк: 0
SELECT *
FROM new_rsfirewall_exceptions
WHERE `published`='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rsfirewall/rsfirewall.php:642 |
| 9 | plgSystemRSFirewall->isException() | JROOT/plugins/system/rsfirewall/rsfirewall.php:1085 |
| 8 | plgSystemRSFirewall->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.19 ms Память запроса: 0.021 MB Память до запроса: 2.283 MB Выбрано строк: 1
Повторяющиеся запросы:
#13SELECT *
FROM new_jsn_mobilize_os
WHERE os_type = 'other'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jsn_mobilize_os | ALL | NULL | Индекс не используется | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:445 |
| 10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
| 9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 |
| 8 | PlgSystemJSNMobilize->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.09 ms После последнего запроса: 0.27 ms Память запроса: 0.021 MB Память до запроса: 2.291 MB Выбрано строк: 1
Повторяющиеся запросы:
#14SELECT *
FROM new_jsn_mobilize_profiles AS p
INNER JOIN new_jsn_mobilize_os_support AS s
ON s.profile_id = p.profile_id
WHERE s.os_id = '11'
AND p.profile_state = 1
AND p.profile_device = "jsn_mobile"
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | p | system | PRIMARY | Индекс не используется | NULL | NULL | 1 | |
| 1 | SIMPLE | s | ALL | NULL | Индекс не используется | NULL | NULL | 12 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 11 | JDatabaseDriver->loadObject() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:512 |
| 10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
| 9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 |
| 8 | PlgSystemJSNMobilize->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.09 ms После последнего запроса: 0.05 ms Память запроса: 0.070 MB Память до запроса: 2.296 MB Выбрано строк: 24
Повторяющиеся запросы:
#15SELECT *
FROM new_jsn_mobilize_design
WHERE profile_id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jsn_mobilize_design | ALL | NULL | Индекс не используется | NULL | NULL | 24 | Using where |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:519 |
| 10 | JSNMobilizeTemplateHelper::getOSSupport() | JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 |
| 9 | JSNMobilizeTemplateHelper::getConfig() | JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 |
| 8 | PlgSystemJSNMobilize->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.43 ms После последнего запроса: 1.05 ms Память запроса: 0.024 MB Память до запроса: 2.375 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `new_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.16 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/library/helper.php:166 |
| 16 | JLibraryHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:174 |
| 14 | JLibraryHelper::loadLibrary() | JROOT/libraries/cms/library/helper.php:42 |
| 13 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:89 |
| 12 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:270 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.42 ms После последнего запроса: 0.14 ms Память запроса: 0.006 MB Память до запроса: 2.367 MB
UPDATE `new_extensions`
SET `params` = '{\"mediaversion\":\"575c367cbca15a5a073dbfce013b0344\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN не доступен для запроса: UPDATE `new_extensions`
SET `params` = '{\"mediaversion\":\"575c367cbca15a5a073dbfce013b0344\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init for update | 0.13 ms |
| Updating | 0.05 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.05 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:116 |
| 13 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:321 |
| 12 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:280 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.33 ms Память запроса: 0.031 MB Память до запроса: 2.407 MB Выбрано строк: 91
SELECT *
FROM `new_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jcomments_settings | ALL | PRIMARY | Индекс не используется | NULL | NULL | 91 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.00 ms |
| Sending cached result to clien | 0.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
| 13 | JCommentsCfg::_load() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 12 | JCacheControllerCallback->get() | JROOT/components/com_jcomments/classes/config.php:159 |
| 11 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
| 10 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
| 9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.50 ms После последнего запроса: 0.16 ms Память запроса: 0.022 MB Память до запроса: 2.412 MB Выбрано строк: 6
SELECT id, home, template, s.params
FROM new_template_styles as s
LEFT JOIN new_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 11 | Using index condition; Using where |
| 1 | SIMPLE | s | ALL | idx_template | Индекс не используется | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.14 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:485 |
| 10 | JApplicationSite->getTemplate() | JROOT/components/com_jcomments/helpers/system.php:46 |
| 9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
| 8 | plgSystemJComments->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.31 ms После последнего запроса: 0.53 ms Память запроса: 0.022 MB Память до запроса: 2.442 MB Выбрано строк: 1
SELECT manifest_cache
FROM new_extensions
WHERE element LIKE 'jsn_megazine_pro'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | range | element_clientid,element_folder_clientid | element_folder_clientid | 402 | NULL | 8 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.09 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 13 | JDatabaseDriver->loadResult() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122 |
| 12 | JSNTplHelper::getManifestCache() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:198 |
| 11 | JSNTplHelper::getTemplateVersion() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35 |
| 10 | jsn_template_framework_class_loader() | Так же, как вызов в строке ниже. |
| 9 | spl_autoload_call() | JROOT/plugins/system/jsntplframework/jsntplframework.php:145 |
| 8 | PlgSystemJSNTPLFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1155 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.85 ms Память запроса: 0.019 MB Память до запроса: 2.463 MB Выбрано строк: 1
SELECT *
FROM new_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_languages | system | NULL | Индекс не используется | NULL | NULL | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:148 |
| 5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:327 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 1.04 ms Память запроса: 0.029 MB Память до запроса: 2.536 MB Выбрано строк: 47
SELECT `id`,`name`,`rules`,`parent_id`
FROM `new_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_blogopros','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djtabs','com_fields','com_finder','com_flippingbook','com_imageshow','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_jsecurelite','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilize','com_modules','com_newsfeeds','com_osmap','com_phocagallery','com_plugins','com_postinstall','com_poweradmin','com_privacy','com_redirect','com_rsfirewall','com_search','com_tags','com_templates','com_uniform','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 49 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:427 |
| 16 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:211 |
| 15 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:529 |
| 14 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:434 |
| 10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:248 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.70 ms После последнего запроса: 0.27 ms Память запроса: 0.031 MB Память до запроса: 2.603 MB Выбрано строк: 31
SHOW FULL COLUMNS
FROM `new_content`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `new_content`
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| closing tables | 0.00 ms |
| Opening tables | 0.24 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| checking permissions | 0.12 ms |
| closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Removing tmp table | 0.08 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 12 | JTable->__construct() | JROOT/libraries/legacy/table/content.php:33 |
| 11 | JTableContent->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 10 | JTable::getInstance() | JROOT/components/com_content/models/article.php:250 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.31 ms После последнего запроса: 0.26 ms Память запроса: 0.092 MB Память до запроса: 2.714 MB Выбрано строк: 1
SELECT *
FROM new_content
WHERE `id` = '8857'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 10 | JTable->load() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.39 ms После последнего запроса: 0.08 ms Память запроса: 0.005 MB Память до запроса: 2.756 MB
UPDATE new_content
SET `hits` = (`hits` + 1)
WHERE `id` = '8857'
EXPLAIN не доступен для запроса: UPDATE new_content
SET `hits` = (`hits` + 1)
WHERE `id` = '8857'
| Status | Duration |
|---|
| Starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init for update | 0.03 ms |
| Updating | 0.08 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.13 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/table/table.php:1240 |
| 10 | JTable->hit() | JROOT/components/com_content/models/article.php:252 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.53 ms После последнего запроса: 0.23 ms Память запроса: 0.093 MB Память до запроса: 2.784 MB Выбрано строк: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM new_content AS a
INNER JOIN new_categories AS c
on c.id = a.catid
LEFT JOIN new_users AS u
on u.id = a.created_by
LEFT JOIN new_categories as parent
ON parent.id = c.parent_id
LEFT JOIN new_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 8857
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-23 12:22:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 12:22:08')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | v | system | PRIMARY | Индекс не используется | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | a | const | PRIMARY,idx_state,idx_catid | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.10 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:148 |
| 12 | ContentModelArticle->getItem() | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 |
| 11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.09 ms После последнего запроса: 0.34 ms Память запроса: 0.027 MB Память до запроса: 2.847 MB Выбрано строк: 4
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 new_categories as c
LEFT JOIN new_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 s.id=101
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 139 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 20 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 19 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 18 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 17 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 16 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 15 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 14 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 13 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 12 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 11 | JRoute::_() | JROOT/components/com_content/views/article/view.html.php:71 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.42 ms После последнего запроса: 0.25 ms Память запроса: 0.022 MB Память до запроса: 2.911 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `new_contentitem_tag_map` AS m
INNER JOIN `new_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 8857
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | t | ref | PRIMARY,tag_idx,idx_access | tag_idx | 1 | const | 1 | Using index condition |
| 1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | c16299_ural_tatar.t.id | 2 | Using where |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.05 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:450 |
| 11 | JHelperTags->getItemTags() | JROOT/components/com_content/views/article/view.html.php:180 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.13 ms После последнего запроса: 3.32 ms Память запроса: 0.025 MB Память до запроса: 3.127 MB Выбрано строк: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM new_fields AS a
LEFT JOIN `new_languages` AS l
ON l.lang_code = a.language
LEFT JOIN new_users AS uc
ON uc.id=a.checked_out
LEFT JOIN new_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN new_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN new_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `new_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (101,0,95,93))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 17 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:326 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 15 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:190 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.24 ms Память запроса: 0.025 MB Память до запроса: 3.159 MB Выбрано строк: 0
SELECT `name`, `value`
FROM `new_jsn_imageshow_config`
WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jsn_imageshow_config | range | name | name | 767 | NULL | 3 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81 |
| 16 | JSNISParameter->getParameters() | JROOT/administrator/components/com_imageshow/imageshow.defines.php:27 |
| 15 | require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php | JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16 |
| 14 | include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php | JROOT/plugins/content/imageshow/imageshow.php:28 |
| 13 | plgContentImageShow->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:190 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.44 ms После последнего запроса: 1.47 ms Память запроса: 0.023 MB Память до запроса: 3.287 MB Выбрано строк: 1
Повторяющиеся запросы:
#54SELECT *
FROM new_extensions
WHERE element='com_imageshow'
AND type='component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.15 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310 |
| 14 | JSNISUtils->getComponentInfo() | JROOT/plugins/content/imageshow/imageshow.php:47 |
| 13 | plgContentImageShow->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:190 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.33 ms После последнего запроса: 1.47 ms Память запроса: 0.026 MB Память до запроса: 3.370 MB Выбрано строк: 1
SELECT *
FROM `new_jcomments_objects`
WHERE `object_id` = '8857'
AND `object_group` = 'com_content'
AND `lang` = 'ru-RU'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_jcomments_objects | ref | idx_object | idx_object | 833 | const,const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 22 | JDatabaseDriver->loadObject() | JROOT/components/com_jcomments/models/object.php:28 |
| 21 | JCommentsModelObject::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:117 |
| 20 | JCommentsObjectHelper::fetchObjectInfo() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 19 | JCacheControllerCallback->get() | JROOT/components/com_jcomments/helpers/object.php:159 |
| 18 | JCommentsObjectHelper::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:46 |
| 17 | JCommentsObjectHelper::getLink() | JROOT/components/com_jcomments/classes/factory.php:255 |
| 16 | JCommentsFactory::getTemplate() | JROOT/components/com_jcomments/jcomments.php:194 |
| 15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
| 14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
| 13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:199 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.39 ms После последнего запроса: 0.09 ms Память запроса: 0.025 MB Память до запроса: 3.352 MB Выбрано строк: 1
SELECT count(*)
FROM new_jcomments AS c
WHERE c.object_id = 8857
AND c.object_group = 'com_content'
AND c.published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 9 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.14 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.02 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 18 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/models/jcomments.php:35 |
| 17 | JCommentsModel::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:1306 |
| 16 | JComments::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:224 |
| 15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
| 14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
| 13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:199 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.87 ms После последнего запроса: 0.10 ms Память запроса: 0.029 MB Память до запроса: 3.364 MB Выбрано строк: 8
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, v.value as voted
,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM new_jcomments AS c
LEFT JOIN new_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '3.144.38.184'
WHERE c.object_id = 8857
AND c.object_group = 'com_content'
AND c.published = 1
ORDER BY c.date DESC
LIMIT 0, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 9 | Using where |
| 1 | SIMPLE | v | ref | idx_comment,idx_user | idx_comment | 8 | c16299_ural_tatar.c.id,const | 12 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.07 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.14 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.39 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/models/jcomments.php:80 |
| 17 | JCommentsModel::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:658 |
| 16 | JComments::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:272 |
| 15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
| 14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
| 13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:199 |
| 10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:671 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:39 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:389 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:364 |
| 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:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.87 ms После последнего запроса: 4.88 ms Память запроса: 0.055 MB Память до запроса: 3.574 MB Выбрано строк: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM new_modules AS m
LEFT JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN new_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 <= '2024-11-23 12:22:08')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-23 12:22:08')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 1504 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 17 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_folder_clientid | 402 | c16299_ural_tatar.m.module | 11 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.m.id | 13 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.33 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.12 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:422 |
| 12 | JModuleHelper::load() | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89 |
| 11 | JModuleHelper::getModules() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:158 |
| 10 | JSNTplUtils->countModules() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:470 |
| 9 | JSNTplTemplateHelper->_prepare() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118 |
| 8 | JSNTplTemplateHelper::prepare() | JROOT/templates/jsn_megazine_pro/index.php:18 |
| 7 | require JROOT/templates/jsn_megazine_pro/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.12 ms После последнего запроса: 3.75 ms Память запроса: 0.023 MB Память до запроса: 3.725 MB Выбрано строк: 0
SELECT m.id
FROM new_modules AS m
INNER JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_k2_%'
AND (mm.menuid < 0
AND mm.menuid = -1504)
AND m.position IN ("topbar", "top1", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom", "floatercontent", "floatercontainer")
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 26 | Using where |
| 1 | SIMPLE | mm | eq_ref | PRIMARY | PRIMARY | 8 | c16299_ural_tatar.m.id,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:701 |
| 13 | JSNTplUtils->checkExt() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:742 |
| 12 | JSNTplUtils->checkK2() | JROOT/templates/jsn_megazine_pro/template_custom.php:23 |
| 11 | include_once JROOT/templates/jsn_megazine_pro/template_custom.php | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:950 |
| 10 | JSNTplTemplateHelper->_prepareHead() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:707 |
| 9 | JSNTplTemplateHelper->_prepare() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118 |
| 8 | JSNTplTemplateHelper::prepare() | JROOT/templates/jsn_megazine_pro/index.php:18 |
| 7 | require JROOT/templates/jsn_megazine_pro/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.10 ms После последнего запроса: 0.05 ms Память запроса: 0.023 MB Память до запроса: 3.733 MB Выбрано строк: 0
SELECT m.id
FROM new_modules AS m
INNER JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_k2_%'
AND (mm.menuid = 1504 OR mm.menuid = 0 OR (mm.menuid < 0
AND mm.menuid != -1504))
AND m.position IN ("topbar", "top1", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom", "floatercontent", "floatercontainer")
GROUP BY m.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 26 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.m.id | 13 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:722 |
| 13 | JSNTplUtils->checkExt() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:742 |
| 12 | JSNTplUtils->checkK2() | JROOT/templates/jsn_megazine_pro/template_custom.php:23 |
| 11 | include_once JROOT/templates/jsn_megazine_pro/template_custom.php | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:950 |
| 10 | JSNTplTemplateHelper->_prepareHead() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:707 |
| 9 | JSNTplTemplateHelper->_prepare() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118 |
| 8 | JSNTplTemplateHelper::prepare() | JROOT/templates/jsn_megazine_pro/index.php:18 |
| 7 | require JROOT/templates/jsn_megazine_pro/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.09 ms После последнего запроса: 0.07 ms Память запроса: 0.023 MB Память до запроса: 3.740 MB Выбрано строк: 0
SELECT m.id
FROM new_modules AS m
INNER JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_virtuemart_%'
AND (mm.menuid < 0
AND mm.menuid = -1504)
AND m.position IN ("topbar", "top1", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom", "floatercontent", "floatercontainer")
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 26 | Using where |
| 1 | SIMPLE | mm | eq_ref | PRIMARY | PRIMARY | 8 | c16299_ural_tatar.m.id,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:701 |
| 13 | JSNTplUtils->checkExt() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:751 |
| 12 | JSNTplUtils->checkVM() | JROOT/templates/jsn_megazine_pro/template_custom.php:28 |
| 11 | include_once JROOT/templates/jsn_megazine_pro/template_custom.php | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:950 |
| 10 | JSNTplTemplateHelper->_prepareHead() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:707 |
| 9 | JSNTplTemplateHelper->_prepare() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118 |
| 8 | JSNTplTemplateHelper::prepare() | JROOT/templates/jsn_megazine_pro/index.php:18 |
| 7 | require JROOT/templates/jsn_megazine_pro/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.08 ms После последнего запроса: 0.03 ms Память запроса: 0.023 MB Память до запроса: 3.749 MB Выбрано строк: 0
SELECT m.id
FROM new_modules AS m
INNER JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_virtuemart_%'
AND (mm.menuid = 1504 OR mm.menuid = 0 OR (mm.menuid < 0
AND mm.menuid != -1504))
AND m.position IN ("topbar", "top1", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom", "floatercontent", "floatercontainer")
GROUP BY m.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 26 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.m.id | 13 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:722 |
| 13 | JSNTplUtils->checkExt() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:751 |
| 12 | JSNTplUtils->checkVM() | JROOT/templates/jsn_megazine_pro/template_custom.php:28 |
| 11 | include_once JROOT/templates/jsn_megazine_pro/template_custom.php | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:950 |
| 10 | JSNTplTemplateHelper->_prepareHead() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:707 |
| 9 | JSNTplTemplateHelper->_prepare() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118 |
| 8 | JSNTplTemplateHelper::prepare() | JROOT/templates/jsn_megazine_pro/index.php:18 |
| 7 | require JROOT/templates/jsn_megazine_pro/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.05 ms После последнего запроса: 0.04 ms Память запроса: 0.023 MB Память до запроса: 3.756 MB Выбрано строк: 0
SELECT m.id
FROM new_modules AS m
INNER JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_dj%'
AND (mm.menuid < 0
AND mm.menuid = -1504)
AND m.position IN ("topbar", "top1", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom", "floatercontent", "floatercontainer")
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 26 | Using where |
| 1 | SIMPLE | mm | eq_ref | PRIMARY | PRIMARY | 8 | c16299_ural_tatar.m.id,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:701 |
| 13 | JSNTplUtils->checkExt() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:812 |
| 12 | JSNTplUtils->checkDJ() | JROOT/templates/jsn_megazine_pro/template_custom.php:33 |
| 11 | include_once JROOT/templates/jsn_megazine_pro/template_custom.php | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:950 |
| 10 | JSNTplTemplateHelper->_prepareHead() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:707 |
| 9 | JSNTplTemplateHelper->_prepare() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118 |
| 8 | JSNTplTemplateHelper::prepare() | JROOT/templates/jsn_megazine_pro/index.php:18 |
| 7 | require JROOT/templates/jsn_megazine_pro/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.05 ms После последнего запроса: 0.03 ms Память запроса: 0.023 MB Память до запроса: 3.765 MB Выбрано строк: 1
SELECT m.id
FROM new_modules AS m
INNER JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_dj%'
AND (mm.menuid = 1504 OR mm.menuid = 0 OR (mm.menuid < 0
AND mm.menuid != -1504))
AND m.position IN ("topbar", "top1", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom", "floatercontent", "floatercontainer")
GROUP BY m.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 26 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.m.id | 13 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:722 |
| 13 | JSNTplUtils->checkExt() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:812 |
| 12 | JSNTplUtils->checkDJ() | JROOT/templates/jsn_megazine_pro/template_custom.php:33 |
| 11 | include_once JROOT/templates/jsn_megazine_pro/template_custom.php | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:950 |
| 10 | JSNTplTemplateHelper->_prepareHead() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:707 |
| 9 | JSNTplTemplateHelper->_prepare() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118 |
| 8 | JSNTplTemplateHelper::prepare() | JROOT/templates/jsn_megazine_pro/index.php:18 |
| 7 | require JROOT/templates/jsn_megazine_pro/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1102 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.12 ms После последнего запроса: 6.63 ms Память запроса: 0.026 MB Память до запроса: 3.798 MB Выбрано строк: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM new_fields AS a
LEFT JOIN `new_languages` AS l
ON l.lang_code = a.language
LEFT JOIN new_users AS uc
ON uc.id=a.checked_out
LEFT JOIN new_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN new_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN new_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `new_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (101,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 20 | JModelLegacy->_getList() | JROOT/administrator/components/com_fields/models/fields.php:326 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 18 | JModelList->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:134 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:378 |
| 16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:233 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:140 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.11 ms Память запроса: 0.025 MB Память до запроса: 3.810 MB Выбрано строк: 1
Повторяющиеся запросы:
#42SELECT *
FROM new_extensions
WHERE element='com_imageshow'
AND type='component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 18 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310 |
| 17 | JSNISUtils->getComponentInfo() | JROOT/plugins/content/imageshow/imageshow.php:47 |
| 16 | plgContentImageShow->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:233 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:140 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.08 ms После последнего запроса: 2.63 ms Память запроса: 0.023 MB Память до запроса: 3.989 MB Выбрано строк: 2
SELECT lft, rgt
FROM new_menu
WHERE id = 1258 OR id = 1276
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_menu | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:578 |
| 12 | JSNTplUtils->isLastMenu() | JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php:58 |
| 11 | require JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php | JROOT/modules/mod_menu/mod_menu.php:27 |
| 10 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.06 ms После последнего запроса: 0.10 ms Память запроса: 0.023 MB Память до запроса: 3.996 MB Выбрано строк: 2
SELECT lft, rgt
FROM new_menu
WHERE id = 1258 OR id = 1277
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_menu | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:578 |
| 12 | JSNTplUtils->isLastMenu() | JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php:58 |
| 11 | require JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php | JROOT/modules/mod_menu/mod_menu.php:27 |
| 10 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.06 ms После последнего запроса: 0.07 ms Память запроса: 0.023 MB Память до запроса: 4.003 MB Выбрано строк: 2
SELECT lft, rgt
FROM new_menu
WHERE id = 1258 OR id = 1504
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_menu | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:578 |
| 12 | JSNTplUtils->isLastMenu() | JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php:58 |
| 11 | require JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php | JROOT/modules/mod_menu/mod_menu.php:27 |
| 10 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.05 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 4.010 MB Выбрано строк: 2
SELECT lft, rgt
FROM new_menu
WHERE id = 1258 OR id = 1279
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_menu | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:578 |
| 12 | JSNTplUtils->isLastMenu() | JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php:58 |
| 11 | require JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php | JROOT/modules/mod_menu/mod_menu.php:27 |
| 10 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.05 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 4.017 MB Выбрано строк: 2
SELECT lft, rgt
FROM new_menu
WHERE id = 1258 OR id = 1280
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_menu | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:578 |
| 12 | JSNTplUtils->isLastMenu() | JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php:58 |
| 11 | require JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php | JROOT/modules/mod_menu/mod_menu.php:27 |
| 10 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.05 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 4.023 MB Выбрано строк: 2
SELECT lft, rgt
FROM new_menu
WHERE id = 1258 OR id = 1281
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_menu | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:578 |
| 12 | JSNTplUtils->isLastMenu() | JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php:58 |
| 11 | require JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php | JROOT/modules/mod_menu/mod_menu.php:27 |
| 10 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.06 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 4.030 MB Выбрано строк: 2
SELECT lft, rgt
FROM new_menu
WHERE id = 1258 OR id = 1484
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_menu | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:578 |
| 12 | JSNTplUtils->isLastMenu() | JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php:58 |
| 11 | require JROOT/templates/jsn_megazine_pro/html/mod_menu/default.php | JROOT/modules/mod_menu/mod_menu.php:27 |
| 10 | include JROOT/modules/mod_menu/mod_menu.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.48 ms После последнего запроса: 1.76 ms Память запроса: 0.022 MB Память до запроса: 4.422 MB Выбрано строк: 1
Повторяющиеся запросы:
#67select enabled
from new_extensions
where type="component"
and element = "com_content"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.16 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 12 | JDatabaseDriver->loadResult() | JROOT/modules/mod_news_pro_gk5/helper.php:93 |
| 11 | NSP_GK5_Helper->getComponentStatus() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.43 ms После последнего запроса: 0.07 ms Память запроса: 0.038 MB Память до запроса: 4.428 MB Выбрано строк: 263
SELECT
c.id AS CID
FROM
new_categories AS c
LEFT JOIN
new_content AS content
ON
c.id = content.catid
WHERE
1=1
AND ( c.id = 133)
AND
c.extension = 'com_content'
AND
c.published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,cat_idx | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | content | ref | idx_catid | idx_catid | 4 | const | 468 | Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:86 |
| 12 | NSP_GK5_com_content_Model::getSources() | JROOT/modules/mod_news_pro_gk5/helper.php:119 |
| 11 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 1.37 ms После последнего запроса: 0.20 ms Память запроса: 0.022 MB Память до запроса: 4.445 MB Выбрано строк: 1
SELECT
content.id AS iid
FROM
new_content AS content
WHERE
content.state = 1
AND content.access IN (1,1,5)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-11-23 15:22:08' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-11-23 15:22:08' )
AND ( content.catid = 133 )
ORDER BY
content.publish_up DESC
LIMIT
0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | content | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 468 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.00 ms |
| Creating sort index | 1.04 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:269 |
| 12 | NSP_GK5_com_content_Model::getArticles() | JROOT/modules/mod_news_pro_gk5/helper.php:133 |
| 11 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.54 ms После последнего запроса: 0.03 ms Память запроса: 0.028 MB Память до запроса: 4.465 MB Выбрано строк: 1
SELECT
content.id AS iid,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.images AS images,
content.featured AS frontpage,
content.access AS access,
content.language AS lang,
categories.title AS catname,
users.email AS author_email,
content.created_by_alias AS author_alias,
users.name AS author_username,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as cid
FROM
new_content AS content
LEFT JOIN
new_categories AS categories
ON categories.id = content.catid
LEFT JOIN
new_users AS users
ON users.id = content.created_by
LEFT JOIN
new_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN
new_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id
WHERE
1=1
AND ( content.id = 12318)
ORDER BY
content.publish_up DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | content_rating | system | PRIMARY | Индекс не используется | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | users | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.10 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.06 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:333 |
| 12 | NSP_GK5_com_content_Model::getArticles() | JROOT/modules/mod_news_pro_gk5/helper.php:133 |
| 11 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.12 ms После последнего запроса: 0.23 ms Память запроса: 0.029 MB Память до запроса: 4.483 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 new_categories as c
LEFT JOIN new_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 s.id=133
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 139 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 24 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 23 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 22 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 21 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 20 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 19 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 18 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 17 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 16 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 15 | JRoute::_() | JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189 |
| 14 | NSP_GK5_com_content_View::itemLink() | JROOT/modules/mod_news_pro_gk5/tmpl/view.php:127 |
| 13 | NSP_GK5_View::lists() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:93 |
| 12 | NSP_GK5_com_content_Controller->initialize() | JROOT/modules/mod_news_pro_gk5/helper.php:199 |
| 11 | NSP_GK5_Helper->renderLayout() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.12 ms После последнего запроса: 0.60 ms Память запроса: 0.022 MB Память до запроса: 4.498 MB Выбрано строк: 1
Повторяющиеся запросы:
#62select enabled
from new_extensions
where type="component"
and element = "com_content"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | new_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 12 | JDatabaseDriver->loadResult() | JROOT/modules/mod_news_pro_gk5/helper.php:93 |
| 11 | NSP_GK5_Helper->getComponentStatus() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.41 ms После последнего запроса: 0.03 ms Память запроса: 0.025 MB Память до запроса: 4.504 MB Выбрано строк: 72
SELECT
c.id AS CID
FROM
new_categories AS c
LEFT JOIN
new_content AS content
ON
c.id = content.catid
WHERE
1=1
AND ( c.id = 132)
AND
c.extension = 'com_content'
AND
c.published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,cat_idx | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | content | ref | idx_catid | idx_catid | 4 | const | 128 | Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:86 |
| 12 | NSP_GK5_com_content_Model::getSources() | JROOT/modules/mod_news_pro_gk5/helper.php:119 |
| 11 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.89 ms После последнего запроса: 0.09 ms Память запроса: 0.022 MB Память до запроса: 4.513 MB Выбрано строк: 1
SELECT
content.id AS iid
FROM
new_content AS content
WHERE
content.state = 1
AND content.access IN (1,1,5)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-11-23 15:22:08' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-11-23 15:22:08' )
AND ( content.catid = 132 )
ORDER BY
content.publish_up DESC
LIMIT
0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | content | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 128 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.49 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.02 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:269 |
| 12 | NSP_GK5_com_content_Model::getArticles() | JROOT/modules/mod_news_pro_gk5/helper.php:133 |
| 11 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.54 ms После последнего запроса: 0.03 ms Память запроса: 0.023 MB Память до запроса: 4.523 MB Выбрано строк: 1
SELECT
content.id AS iid,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.images AS images,
content.featured AS frontpage,
content.access AS access,
content.language AS lang,
categories.title AS catname,
users.email AS author_email,
content.created_by_alias AS author_alias,
users.name AS author_username,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as cid
FROM
new_content AS content
LEFT JOIN
new_categories AS categories
ON categories.id = content.catid
LEFT JOIN
new_users AS users
ON users.id = content.created_by
LEFT JOIN
new_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN
new_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id
WHERE
1=1
AND ( content.id = 10466)
ORDER BY
content.publish_up DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | content_rating | system | PRIMARY | Индекс не используется | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | users | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.14 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:333 |
| 12 | NSP_GK5_com_content_Model::getArticles() | JROOT/modules/mod_news_pro_gk5/helper.php:133 |
| 11 | NSP_GK5_Helper->getDatas() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 0.14 ms Память запроса: 0.029 MB Память до запроса: 4.535 MB Выбрано строк: 4
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 new_categories as c
LEFT JOIN new_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 s.id=132
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 139 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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.02 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 24 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 23 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 22 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 21 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 20 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 19 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 18 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 17 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 16 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 15 | JRoute::_() | JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189 |
| 14 | NSP_GK5_com_content_View::itemLink() | JROOT/modules/mod_news_pro_gk5/tmpl/view.php:127 |
| 13 | NSP_GK5_View::lists() | JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:93 |
| 12 | NSP_GK5_com_content_Controller->initialize() | JROOT/modules/mod_news_pro_gk5/helper.php:199 |
| 11 | NSP_GK5_Helper->renderLayout() | JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32 |
| 10 | include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 80.77 ms После последнего запроса: 1.05 ms Память запроса: 0.699 MB Память до запроса: 4.473 MB Выбрано строк: 21
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM new_content AS a
LEFT JOIN new_categories AS c
ON c.id = a.catid
LEFT JOIN new_users AS ua
ON ua.id = a.created_by
LEFT JOIN new_users AS uam
ON uam.id = a.modified_by
LEFT JOIN new_categories as parent
ON parent.id = c.parent_id
LEFT JOIN new_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (99,100,101,102,103,104,105,106,107,108,111,129,134,131,132,137,138,139,125,142,143,126,127)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-23 12:22:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 12:22:08')
ORDER BY a.publish_up DESC
LIMIT 21
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | v | system | PRIMARY | Индекс не используется | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | a | range | idx_access,idx_state,idx_catid | idx_catid | 4 | NULL | 11975 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | c16299_ural_tatar.a.catid | 1 | Using index condition; Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.a.created_by | 1 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.a.modified_by | 1 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | c16299_ural_tatar.c.parent_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| Checking query cache for query | 0.25 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.29 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.21 ms |
| Sorting result | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 78.46 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.09 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.02 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:307 |
| 14 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:186 |
| 13 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:536 |
| 12 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_latest/helper.php:116 |
| 11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
| 10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.11 ms После последнего запроса: 1.46 ms Память запроса: 0.028 MB Память до запроса: 5.263 MB Выбрано строк: 4
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 new_categories as c
LEFT JOIN new_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 s.id=105
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 139 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 21 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 20 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 19 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 18 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 17 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 16 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 15 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 14 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 13 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 12 | JRoute::_() | JROOT/modules/mod_articles_latest/helper.php:128 |
| 11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
| 10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.08 ms После последнего запроса: 0.21 ms Память запроса: 0.028 MB Память до запроса: 5.280 MB Выбрано строк: 4
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 new_categories as c
LEFT JOIN new_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 s.id=102
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 139 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 21 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 20 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 19 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 18 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 17 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 16 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 15 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 14 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 13 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 12 | JRoute::_() | JROOT/modules/mod_articles_latest/helper.php:128 |
| 11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
| 10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.28 ms Память запроса: 0.028 MB Память до запроса: 5.297 MB Выбрано строк: 4
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 new_categories as c
LEFT JOIN new_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 s.id=99
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 139 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 21 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 20 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 19 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 18 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 17 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 16 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 15 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 14 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 13 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 12 | JRoute::_() | JROOT/modules/mod_articles_latest/helper.php:128 |
| 11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
| 10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Время запроса: 0.07 ms После последнего запроса: 0.15 ms Память запроса: 0.028 MB Память до запроса: 5.313 MB Выбрано строк: 4
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 new_categories as c
LEFT JOIN new_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 s.id=100
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | Индекс не используется | NULL | NULL | 139 | Using where; Используется filesort |
| Status | Duration |
|---|
| Starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 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 |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:304 |
| 21 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 20 | JCategories->get() | JROOT/components/com_content/router.php:72 |
| 19 | ContentRouter->getCategorySegment() | JROOT/libraries/cms/component/router/view.php:117 |
| 18 | JComponentRouterView->getPath() | JROOT/libraries/cms/component/router/rules/menu.php:82 |
| 17 | JComponentRouterRulesMenu->preprocess() | JROOT/libraries/cms/component/router/view.php:219 |
| 16 | JComponentRouterView->preprocess() | JROOT/libraries/cms/router/site.php:660 |
| 15 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:267 |
| 14 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 13 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 12 | JRoute::_() | JROOT/modules/mod_articles_latest/helper.php:128 |
| 11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 |
| 10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 |
| 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:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1116 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
8 × 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 new_categories as c
LEFT JOIN new_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
7 × SELECT lft, rgt
FROM new_menu
6 × SELECT m.id
FROM new_modules AS m
INNER JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
2 × SELECT *
FROM new_jsn_mobilize_design
2 × SELECT *
FROM new_extensions
2 × SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.images AS images, content.featured AS frontpage, content.access AS access, content.language AS lang, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM new_content AS content
LEFT JOIN new_categories AS categories
ON categories.id = content.catid
LEFT JOIN new_users AS users
ON users.id = content.created_by
LEFT JOIN new_content_rating AS content_rating
ON content_rating.content_id = content.id
LEFT JOIN new_content_frontpage AS content_frontpage
ON content_frontpage.content_id = content.id
2 × SELECT content.id AS iid
FROM new_content AS content
2 × SELECT c.id AS CID
FROM new_categories AS c
LEFT JOIN new_content AS content
ON c.id = content.catid
2 × select enabled
from new_extensions
2 × SELECT *
FROM new_jsn_mobilize_os
2 × SELECT *
FROM new_jsn_mobilize_profiles AS p
INNER JOIN new_jsn_mobilize_os_support AS s
ON s.profile_id = p.profile_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `new_extensions`
2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM new_fields AS a
LEFT JOIN `new_languages` AS l
ON l.lang_code = a.language
LEFT JOIN new_users AS uc
ON uc.id=a.checked_out
LEFT JOIN new_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN new_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN new_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `new_fields_categories` AS fc
ON fc.field_id = a.id
2 × SELECT `ip`,`reason`
FROM new_rsfirewall_lists
1 × SELECT `m`.`tag_id`,`t`.*
FROM `new_contentitem_tag_map` AS m
INNER JOIN `new_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT `name`, `value`
FROM `new_jsn_imageshow_config`
1 × SELECT `session_id`
FROM `new_session`
1 × SELECT *
FROM `new_jcomments_objects`
1 × SELECT count(*)
FROM new_jcomments AS c
1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , v.value as voted ,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM new_jcomments AS c
LEFT JOIN new_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '3.144.38.184'
1 × SELECT *
FROM new_content
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM new_modules AS m
LEFT JOIN new_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN new_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM new_content AS a
INNER JOIN new_categories AS c
on c.id = a.catid
LEFT JOIN new_users AS u
on u.id = a.created_by
LEFT JOIN new_categories as parent
ON parent.id = c.parent_id
LEFT JOIN new_content_rating AS v
ON a.id = v.content_id
1 × SELECT id, home, template, s.params
FROM new_template_styles as s
LEFT JOIN new_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `new_assets`
1 × SELECT name,value
FROM new_jsn_mobilize_config
1 × SELECT id, rules
FROM `new_viewlevels
1 × SELECT b.id
FROM new_usergroups AS a
LEFT JOIN new_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM new_extensions
1 × SELECT `path`
FROM new_rsfirewall_ignored
1 × SELECT `file`
FROM new_rsfirewall_hashes
1 × SELECT *
FROM new_rsfirewall_configuratio
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 new_menu AS m
LEFT JOIN new_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM new_languages
1 × SELECT `alias`,`catid`
FROM `new_content`
1 × SELECT *
FROM new_rsfirewall_hashes
1 × SELECT *
FROM new_rsfirewall_snapshots
1 × SELECT *
FROM new_rsfirewall_exceptions
1 × SELECT *
FROM `new_jcomments_settings`
1 × SELECT manifest_cache
FROM new_extensions
1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
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,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM new_content AS a
LEFT JOIN new_categories AS c
ON c.id = a.catid
LEFT JOIN new_users AS ua
ON ua.id = a.created_by
LEFT JOIN new_users AS uam
ON uam.id = a.modified_by
LEFT JOIN new_categories as parent
ON parent.id = c.parent_id
LEFT JOIN new_content_rating AS v
ON a.id = v.content_id
Комментарии
And i am glad reading your article. But wanna remark on some general things, The website style is
ideal, the articles is really excellent : D. Good job, cheers
my site: Levitra 10 mg: https://peakpharmacy.shop/sitemap-2.xml
I'd be very grateful if you could elaborate a little
bit more. Many thanks!
my page - dowiedz się
o cenie goutex na receptę w Gdańsku: http://www.gumgang.net/bbs/board.php?bo_table=free&wr_id=5669
is just spectacular and i can assume you're an expert
on this subject. Well with your permission allow me
to grab your feed to keep updated with forthcoming post.
Thanks a million and please keep up the enjoyable work.
Also visit my web site ... (주)웨이투웨이: http://www.wtwkorea.co.kr/bbs/board.php?bo_table=free&wr_id=208280
some of the post I realized it's new to me. Anyways, I'm definitely delighted I found it
and I'll be book-marking and checking back frequently!
Here is my blog; wellbutrin and pregnancy first trimester: https://za.amicidellestelle.it/2c38c
Wonderful .. I will bookmark your site and take the feeds additionally?
I'm satisfied to seek out so many useful info right here within the put up, we'd like work out more strategies
on this regard, thanks for sharing. . . . . .
Also visit my web-site :: hair loss treatment: https://consuelovita.it/from-balding-to-beautiful-one-man-s-journey-to-regaining-his-confidence-with-hair-loss-treatment
blog, thanks admin of this site.
Also visit my blog post - Electrolyte Supplement: https://consuelovita.it/the-benefits-of-electrolyte-supplements-for-active-individuals
order diabetes medication online
Cheap Glyburide online Online pharmacy for diabetes medication
my web blog :: Glyburide mail order: http://eduplusshow.co.kr/bbs/board.php?bo_table=free&wr_id=32812
I was wondering your situation; we have developed some nice procedures
and we are looking to swap solutions with others, please shoot me an email if interested.
Here is my blog post ... buy amoxicillin online without prescription: https://healthy-lifestylehub.blogspot.com/2023/03/where-to-safely-buy-amoxicillin-online.html