Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1606809787,
"last": 1606809787,
"now": 1606809787
},
"token": "zFbthKH9vy8pomdimaxTMQc90Cl626Uw"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "ru-RU"
}
}
}
Время
Память
Время: 23.08 ms / 23.08 ms Память: 1.685 MB / 2.02 MB Application: afterLoad
Время: 158.51 ms / 181.59 ms Память: 9.306 MB / 11.33 MB Application: afterInitialise
Время: 131.08 ms / 312.67 ms Память: 6.151 MB / 17.48 MB Application: afterRoute
Время: 1.21 ms / 313.88 ms Память: 0.308 MB / 17.79 MB Application: beforeRenderComponent com_sppagebuilder
Время: 6.47 ms / 320.35 ms Память: 0.315 MB / 18.10 MB Application: Before Access::preloadComponents (all components)
Время: 1.97 ms / 322.32 ms Память: 0.074 MB / 18.18 MB Application: After Access::preloadComponents (all components)
Время: 0.03 ms / 322.36 ms Память: 0.000 MB / 18.17 MB Application: Before Access::getAssetRules (id:295 name:com_sppagebuilder)
Время: 0.74 ms / 323.09 ms Память: 0.026 MB / 18.20 MB Application: After Access::getAssetRules (id:295 name:com_sppagebuilder)
Время: 59.32 ms / 382.41 ms Память: 2.631 MB / 20.83 MB Application: beforeRenderModule mod_custom (Почему выбирают нас?)
Время: 2.52 ms / 384.93 ms Память: 0.047 MB / 20.88 MB Application: afterRenderModule mod_custom (Почему выбирают нас?)
Время: 15.09 ms / 400.02 ms Память: 0.054 MB / 20.93 MB Application: beforeRenderModule mod_custom (Наши партнеры (копия) (копия))
Время: 0.61 ms / 400.63 ms Память: 0.003 MB / 20.93 MB Application: afterRenderModule mod_custom (Наши партнеры (копия) (копия))
Время: 1.89 ms / 402.52 ms Память: 0.000 MB / 20.91 MB Application: Before Access::preloadPermissions (com_sppagebuilder)
Время: 0.84 ms / 403.36 ms Память: 0.034 MB / 20.94 MB Application: After Access::preloadPermissions (com_sppagebuilder)
Время: 0.02 ms / 403.38 ms Память: 0.000 MB / 20.94 MB Application: Before Access::getAssetRules (id:544 name:com_sppagebuilder.page.24)
Время: 0.02 ms / 403.40 ms Память: 0.002 MB / 20.94 MB Application: After Access::getAssetRules (id:544 name:com_sppagebuilder.page.24)
Время: 0.09 ms / 403.49 ms Память: 0.000 MB / 20.76 MB Application: afterRenderComponent com_sppagebuilder
Время: 8.42 ms / 411.91 ms Память: 0.219 MB / 20.98 MB Application: afterDispatch
Время: 25.59 ms / 437.49 ms Память: 0.808 MB / 21.79 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Время: 0.07 ms / 437.57 ms Память: 0.007 MB / 21.80 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Время: 0.04 ms / 437.61 ms Память: 0.002 MB / 21.80 MB Application: beforeRenderModule mod_custom (Copyright)
Время: 0.60 ms / 438.21 ms Память: 0.003 MB / 21.80 MB Application: afterRenderModule mod_custom (Copyright)
Время: 0.07 ms / 438.27 ms Память: 0.001 MB / 21.80 MB Application: beforeRenderModule mod_custom (Контакты)
Время: 26.95 ms / 465.22 ms Память: 1.872 MB / 23.68 MB Application: afterRenderModule mod_custom (Контакты)
Время: 0.13 ms / 465.35 ms Память: 0.003 MB / 23.68 MB Application: beforeRenderModule mod_menu (Для бизнеса)
Время: 4.77 ms / 470.13 ms Память: 0.050 MB / 23.73 MB Application: afterRenderModule mod_menu (Для бизнеса)
Время: 0.12 ms / 470.25 ms Память: 0.000 MB / 23.73 MB Application: beforeRenderModule mod_menu (Для частного сектора)
Время: 2.18 ms / 472.42 ms Память: 0.013 MB / 23.74 MB Application: afterRenderModule mod_menu (Для частного сектора)
Время: 0.10 ms / 472.52 ms Память: 0.000 MB / 23.74 MB Application: beforeRenderModule mod_custom (Logo - footer )
Время: 0.59 ms / 473.11 ms Память: 0.003 MB / 23.74 MB Application: afterRenderModule mod_custom (Logo - footer )
Время: 0.19 ms / 473.30 ms Память: 0.019 MB / 23.76 MB Application: beforeRenderModule mod_sppagebuilder (Карта главная)
Время: 863.22 ms / 1336.53 ms Память: 0.360 MB / 24.12 MB Application: afterRenderModule mod_sppagebuilder (Карта главная)
Время: 0.36 ms / 1336.89 ms Память: 0.017 MB / 24.14 MB Application: beforeRenderModule mod_sppagebuilder (Главная)
Время: 15.92 ms / 1352.81 ms Память: 0.255 MB / 24.39 MB Application: beforeRenderModule mod_custom (Slider)
Время: 0.59 ms / 1353.40 ms Память: 0.003 MB / 24.39 MB Application: afterRenderModule mod_custom (Slider)
Время: 1696.19 ms / 3049.58 ms Память: 0.038 MB / 24.43 MB Application: afterRenderModule mod_sppagebuilder (Главная)
Время: 0.17 ms / 3049.76 ms Память: 0.000 MB / 24.40 MB Application: beforeRenderModule mod_search (Поиск)
Время: 3.44 ms / 3053.20 ms Память: 0.018 MB / 24.42 MB Application: afterRenderModule mod_search (Поиск)
Время: 0.16 ms / 3053.36 ms Память: 0.012 MB / 24.43 MB Application: beforeRenderModule mod_accordionmenu (Меню)
Время: 26.71 ms / 3080.07 ms Память: 1.213 MB / 25.64 MB Application: afterRenderModule mod_accordionmenu (Меню)
Время: 0.05 ms / 3080.13 ms Память: 0.000 MB / 25.61 MB Application: beforeRenderModule mod_custom (Карта сайта)
Время: 0.58 ms / 3080.70 ms Память: 0.003 MB / 25.62 MB Application: afterRenderModule mod_custom (Карта сайта)
Время: 0.09 ms / 3080.80 ms Память: 0.000 MB / 25.62 MB Application: beforeRenderModule mod_custom (Адрес хедер)
Время: 1.38 ms / 3082.17 ms Память: 0.004 MB / 25.62 MB Application: afterRenderModule mod_custom (Адрес хедер)
Время: 0.07 ms / 3082.24 ms Память: 0.000 MB / 25.62 MB Application: beforeRenderModule mod_custom (Social)
Время: 0.55 ms / 3082.78 ms Память: 0.003 MB / 25.62 MB Application: afterRenderModule mod_custom (Social)
Время: 293.70 ms / 3376.48 ms Память: 7.945 MB / 33.57 MB Application: afterRender
Всего SQL-запросов: 48.72 ms
34.45 MB (36 124 056 Байт)
64 SQL-запросов зафиксировано 48.72 ms
- Время запроса: 0.52 ms Память запроса: 0.024 MB Память до запроса: 3.634 MB Выбрано строк: 0
SELECT `session_id`
FROM `qp5wf_session`
WHERE `session_id` = X'32366c6262676234306d3239766f6b6869343273346f66673431'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.41 ms После последнего запроса: 0.12 ms Память запроса: 0.005 MB Память до запроса: 3.642 MB
INSERT INTO `qp5wf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'32366c6262676234306d3239766f6b6869343273346f66673431', 1, 1606809787, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `qp5wf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'32366c6262676234306d3239766f6b6869343273346f66673431', 1, 1606809787, 0, '', 0)Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 0.11 ms end 0.00 ms query end 0.09 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.83 ms После последнего запроса: 4.00 ms Память запроса: 0.035 MB Память до запроса: 3.917 MB Выбрано строк: 52
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qp5wf_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_extensions NULL ref extension extension 82 const 59 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.03 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.34 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Так же, как вызов в строке ниже. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 3.26 ms Память запроса: 0.025 MB Память до запроса: 4.128 MB Выбрано строк: 6
SELECT id, rules
FROM `qp5wf_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_viewlevels NULL ALL NULL Индекс не используется NULL NULL 6 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.11 ms Память запроса: 0.025 MB Память до запроса: 4.144 MB Выбрано строк: 2
SELECT b.id
FROM qp5wf_usergroups AS a
LEFT JOIN qp5wf_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.52 ms После последнего запроса: 0.76 ms Память запроса: 0.047 MB Память до запроса: 4.211 MB Выбрано строк: 184
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM qp5wf_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_extensions NULL ref extension extension 82 const 245 0.60 Using index condition; Using where; Используется filesort Status Duration starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.13 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.44 ms После последнего запроса: 10.88 ms Память запроса: 0.025 MB Память до запроса: 5.179 MB Выбрано строк: 0
SELECT `path`
FROM qp5wf_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL Индекс не используется NULL NULL NULL NULL no matching row in const table Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 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/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 5.187 MB Выбрано строк: 0
SELECT `file`
FROM qp5wf_rsfirewall_hashes
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_rsfirewall_hashes NULL ALL NULL Индекс не используется NULL NULL 43 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 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/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.25 ms После последнего запроса: 0.06 ms Память запроса: 0.032 MB Память до запроса: 5.195 MB Выбрано строк: 55
SELECT *
FROM qp5wf_rsfirewall_configurationid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_rsfirewall_configuration NULL ALL NULL Индекс не используется NULL NULL 55 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.81 ms После последнего запроса: 7.43 ms Память запроса: 0.031 MB Память до запроса: 5.659 MB Выбрано строк: 10
SHOW FULL COLUMNS
FROM `qp5wf_rsfirewall_logs`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `qp5wf_rsfirewall_logs`Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.21 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms Opening tables 0.02 ms checking permissions 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.00 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::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/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.72 ms После последнего запроса: 9.27 ms Память запроса: 0.029 MB Память до запроса: 6.334 MB Выбрано строк: 2
SHOW FULL COLUMNS
FROM `qp5wf_gsd_config`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `qp5wf_gsd_config`Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.21 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.00 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 11 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_gsd/tables/config.php:26 10 GSDTableConfig->__construct() JROOT/libraries/src/Table/Table.php:312 9 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_gsd/helpers/helper.php:374 8 GSDHelper::getParams() JROOT/plugins/system/gsd/gsd.php:59 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.28 ms После последнего запроса: 0.12 ms Память запроса: 0.025 MB Память до запроса: 6.350 MB Выбрано строк: 1
SELECT *
FROM qp5wf_gsd_config
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_gsd_config NULL system NULL Индекс не используется NULL NULL 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_gsd/helpers/helper.php:375 8 GSDHelper::getParams() JROOT/plugins/system/gsd/gsd.php:59 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.58 ms После последнего запроса: 16.32 ms Память запроса: 0.006 MB Память до запроса: 7.697 MB
UPDATE qp5wf_extensions
SET enabled=1
WHERE `type`='plugin'
AND `element`='jacontenttype'
AND `folder`='ajax'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE qp5wf_extensions NULL range element_clientid,element_folder_clientid,extension element_clientid 402 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.11 ms updating 0.06 ms end 0.02 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 9 JDatabaseDriverMysqli->execute() JROOT/plugins/system/jacontenttype/jacontenttype.php:61 8 PlgSystemJacontenttype->_check() JROOT/plugins/system/jacontenttype/jacontenttype.php:43 7 PlgSystemJacontenttype->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.62 ms После последнего запроса: 42.28 ms Память запроса: 0.028 MB Память до запроса: 9.928 MB Выбрано строк: 2
SELECT *
FROM qp5wf_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_languages NULL ALL NULL Индекс не используется NULL NULL 3 33.33 Using where; Используется filesort Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.10 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 0.18 ms Память запроса: 0.025 MB Память до запроса: 9.940 MB Выбрано строк: 6
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `qp5wf_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_extensions NULL ref extension extension 82 const 8 1.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.55 ms После последнего запроса: 21.90 ms Память запроса: 0.108 MB Память до запроса: 10.901 MB Выбрано строк: 48
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 qp5wf_menu AS m
LEFT JOIN qp5wf_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 124 3.33 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.m.component_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.02 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Так же, как вызов в строке ниже. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/jlnodoubles/jlnodoubles.php:191 8 plgSystemJlnodoubles->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.43 ms После последнего запроса: 16.89 ms Память запроса: 0.026 MB Память до запроса: 12.017 MB Выбрано строк: 0
SELECT *
FROM qp5wf_rsfirewall_hashes
WHERE (`type`='3.9.22' OR `type`='protect')
AND `flag`!='C'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_rsfirewall_hashes NULL ALL NULL Индекс не используется NULL NULL 43 17.10 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:1026 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/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.23 ms После последнего запроса: 0.44 ms Память запроса: 0.025 MB Память до запроса: 12.050 MB Выбрано строк: 0
SELECT *
FROM qp5wf_rsfirewall_snapshots
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL Индекс не используется NULL NULL NULL NULL no matching row in const table Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 9 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1049 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/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 0.09 ms Память запроса: 0.025 MB Память до запроса: 12.057 MB Выбрано строк: 0
SELECT `ip`,`reason`
FROM qp5wf_rsfirewall_lists
WHERE (`ip`='34.237.138.69' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL Индекс не используется NULL NULL NULL NULL no matching row in const table Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:169 10 plgSystemRSFirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:148 9 plgSystemRSFirewall->isWhitelisted() 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/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.21 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 12.065 MB Выбрано строк: 0
SELECT `ip`,`reason`
FROM qp5wf_rsfirewall_lists
WHERE (`ip`='34.237.138.69' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL Индекс не используется NULL NULL NULL NULL no matching row in const table Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:169 10 plgSystemRSFirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:138 9 plgSystemRSFirewall->isBlacklisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1089 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/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.24 ms После последнего запроса: 1.08 ms Память запроса: 0.027 MB Память до запроса: 12.106 MB Выбрано строк: 0
SELECT *
FROM qp5wf_rsfirewall_exceptions
WHERE `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL Индекс не используется NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:682 9 plgSystemRSFirewall->isException() JROOT/plugins/system/rsfirewall/rsfirewall.php:1142 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/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.47 ms После последнего запроса: 1.44 ms Память запроса: 0.030 MB Память до запроса: 12.185 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `qp5wf_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:62 8 plgSystemBdthemes_Shortcodes->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.44 ms После последнего запроса: 0.17 ms Память запроса: 0.009 MB Память до запроса: 12.181 MB
UPDATE `qp5wf_extensions`
SET `params` = '{\"mediaversion\":\"ee963a90c6ec57b5e02afbfb42b81233\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE qp5wf_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.06 ms updating 0.09 ms end 0.02 ms query end 0.10 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:62 8 plgSystemBdthemes_Shortcodes->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.44 ms После последнего запроса: 2.40 ms Память запроса: 0.026 MB Память до запроса: 12.354 MB Выбрано строк: 4
SELECT id, home, template, s.params
FROM qp5wf_template_styles as s
LEFT JOIN qp5wf_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 12 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 irpint00_newsite.e.element 1 81.82 Using index condition; Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.12 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 9 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:63 8 plgSystemBdthemes_Shortcodes->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.59 ms После последнего запроса: 117.28 ms Память запроса: 0.038 MB Память до запроса: 18.106 MB Выбрано строк: 52
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qp5wf_assets`
WHERE `name` IN ('root.1','com_aclmanager','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_bdthemes_shortcodes','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_csvi','com_fields','com_finder','com_gsd','com_installer','com_jaextmanager','com_jce','com_jch_optimize','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_newsfeeds','com_nextend2','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_rsform','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_tcpdf','com_templates','com_uniform','com_users','com_virtuemart','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_assets NULL ALL idx_asset_name Индекс не используется NULL NULL 459 11.55 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.23 ms preparing 0.01 ms executing 0.00 ms Sending data 0.91 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_sppagebuilder/models/page.php:29 14 SppagebuilderModelPage->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_sppagebuilder/models/page.php:41 12 SppagebuilderModelPage->getItem() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_sppagebuilder/views/page/view.html.php:24 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.56 ms После последнего запроса: 1.42 ms Память запроса: 0.085 MB Память до запроса: 18.208 MB Выбрано строк: 1Повторяющиеся запросы: #38
SELECT a.*,l.title AS language_title,ua.name AS author_name
FROM qp5wf_sppagebuilder as a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
WHERE a.id = 24
AND a.published = 1
AND a.language in ('ru-RU','*')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL 1 SIMPLE l NULL const idx_langcode idx_langcode 28 const 0 0.00 unique row not found 1 SIMPLE ua NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.01 ms executing 0.00 ms Sending data 0.19 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_sppagebuilder/models/page.php:82 12 SppagebuilderModelPage->getItem() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_sppagebuilder/views/page/view.html.php:24 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 0.49 ms Память запроса: 0.037 MB Память до запроса: 18.280 MB Выбрано строк: 25
SHOW FULL COLUMNS
FROM `qp5wf_sppagebuilder`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `qp5wf_sppagebuilder`Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.18 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_sppagebuilder/tables/page.php:17 13 SppagebuilderTablePage->__construct() JROOT/libraries/src/Table/Table.php:312 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_sppagebuilder/models/page.php:176 11 SppagebuilderModelPage->hit() JROOT/components/com_sppagebuilder/views/page/view.html.php:37 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.19 ms Память запроса: 0.061 MB Память до запроса: 18.339 MB Выбрано строк: 1
SELECT *
FROM qp5wf_sppagebuilder
WHERE `id` = '24'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_sppagebuilder NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.17 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 12 Joomla\CMS\Table\Table->load() JROOT/components/com_sppagebuilder/models/page.php:177 11 SppagebuilderModelPage->hit() JROOT/components/com_sppagebuilder/views/page/view.html.php:37 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.47 ms После последнего запроса: 0.23 ms Память запроса: 0.009 MB Память до запроса: 18.376 MB
UPDATE qp5wf_sppagebuilder
SET `hits` = (`hits` + 1)
WHERE `id` = '24'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE qp5wf_sppagebuilder NULL range PRIMARY PRIMARY 8 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.03 ms updating 0.12 ms end 0.02 ms query end 0.12 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_sppagebuilder/models/page.php:178 11 SppagebuilderModelPage->hit() JROOT/components/com_sppagebuilder/views/page/view.html.php:37 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 2.75 ms Память запроса: 0.030 MB Память до запроса: 18.535 MB Выбрано строк: 1
SELECT `template`
FROM `qp5wf_template_styles`
WHERE `client_id` = 0
AND `home` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 9 10.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_sppagebuilder/parser/addon-parser.php:583 16 AddonParser::getTemplateName() JROOT/components/com_sppagebuilder/parser/addon-parser.php:151 15 AddonParser::getAddons() JROOT/components/com_sppagebuilder/parser/addon-parser.php:611 14 require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:14 13 include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_sppagebuilder/views/page/view.html.php:40 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 31.08 ms Память запроса: 0.032 MB Память до запроса: 20.637 MB Выбрано строк: 1
SELECT `title`
FROM `qp5wf_sppagebuilder`
WHERE id = '24'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_sppagebuilder NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 22 JDatabaseDriver->loadResult() JROOT/components/com_sppagebuilder/router.php:126 21 SppagebuilderRouter->getPageSegment() JROOT/components/com_sppagebuilder/router.php:66 20 SppagebuilderRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 19 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 18 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 17 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 16 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 15 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 14 Joomla\CMS\Router\Route::_() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:64 13 include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_sppagebuilder/views/page/view.html.php:40 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 19.80 ms Память запроса: 0.032 MB Память до запроса: 20.751 MB Выбрано строк: 1
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM qp5wf_modules AS m
WHERE m.published = 1
AND m.id = 101
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-12-01 08:03:07')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-12-01 08:03:07')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND m.language IN ('ru-RU','*')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL const PRIMARY,published,idx_language PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_sppagebuilder/addons/module/site.php:99 17 SppagebuilderAddonModule::getModules() JROOT/components/com_sppagebuilder/addons/module/site.php:28 16 SppagebuilderAddonModule->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93 13 include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_sppagebuilder/views/page/view.html.php:40 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.54 ms После последнего запроса: 17.98 ms Память запроса: 0.033 MB Память до запроса: 20.914 MB Выбрано строк: 1
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM qp5wf_modules AS m
WHERE m.published = 1
AND m.id = 268
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-12-01 08:03:07')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-12-01 08:03:07')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND m.language IN ('ru-RU','*')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL const PRIMARY,published,idx_language PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.17 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_sppagebuilder/addons/module/site.php:99 17 SppagebuilderAddonModule::getModules() JROOT/components/com_sppagebuilder/addons/module/site.php:28 16 SppagebuilderAddonModule->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 15 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 14 AddonParser::viewAddons() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93 13 include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_sppagebuilder/views/page/view.html.php:40 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.70 ms После последнего запроса: 2.64 ms Память запроса: 0.034 MB Память до запроса: 20.907 MB Выбрано строк: 17
SELECT `id`,`name`,`rules`,`parent_id`
FROM `qp5wf_assets`
WHERE `name` LIKE 'com_sppagebuilder.%' OR `name` = 'com_sppagebuilder' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_assets NULL ALL idx_asset_name,idx_parent_id Индекс не используется NULL NULL 459 21.82 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.39 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95 13 include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_sppagebuilder/views/page/view.html.php:40 10 SppagebuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_sppagebuilder/controller.php:39 8 SppagebuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_sppagebuilder/sppagebuilder.php:26 6 require_once JROOT/components/com_sppagebuilder/sppagebuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.52 ms После последнего запроса: 2.39 ms Память запроса: 0.024 MB Память до запроса: 20.792 MB Выбрано строк: 3
SELECT language,id
FROM `qp5wf_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 125 1.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.25 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 1.45 ms Память запроса: 0.025 MB Память до запроса: 20.876 MB Выбрано строк: 2
SELECT `c2`.`language`,`c2`.`id`
FROM `qp5wf_menu` AS `c`
INNER JOIN `qp5wf_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `qp5wf_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `qp5wf_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 435id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a NULL const PRIMARY,idx_key PRIMARY 206 const,const 1 100.00 NULL 1 SIMPLE a2 NULL ref idx_key idx_key 128 const 2 100.00 Using index 1 SIMPLE c2 NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a2.id 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.37 ms После последнего запроса: 7.25 ms Память запроса: 0.156 MB Память до запроса: 21.277 MB Выбрано строк: 38
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qp5wf_modules AS m
LEFT JOIN qp5wf_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qp5wf_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 <= '2020-12-01 08:03:07')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-12-01 08:03:07')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 435 OR mm.menuid <= 0)
AND m.language IN ('ru-RU','*')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds,idx_language published 1 const 69 0.72 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 irpint00_newsite.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 irpint00_newsite.m.id 5 40.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.87 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 14 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 13 Joomla\CMS\Helper\ModuleHelper::load() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 12 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 11 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:645 10 T3Template->countModules() JROOT/templates/ja_alumni/tpls/my_default.php:18 9 include JROOT/templates/ja_alumni/tpls/my_default.php JROOT/plugins/system/t3/includes/core/template.php:221 8 T3Template->loadLayout() JROOT/templates/ja_alumni/index.php:34 7 require JROOT/templates/ja_alumni/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.89 ms После последнего запроса: 14.10 ms Память запроса: 0.062 MB Память до запроса: 21.637 MB Выбрано строк: 1Повторяющиеся запросы: #26
SELECT a.*,l.title AS language_title,ua.name AS author_name
FROM qp5wf_sppagebuilder as a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
WHERE a.id = 24
AND a.published = 1
AND a.language in ('ru-RU','*')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL 1 SIMPLE l NULL const idx_langcode idx_langcode 28 const 0 0.00 unique row not found 1 SIMPLE ua NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.01 ms executing 0.00 ms Sending data 0.31 ms end 0.05 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_sppagebuilder/models/page.php:82 14 SppagebuilderModelPage->getItem() JROOT/plugins/gsd/sppagebuilder/sppagebuilder.php:38 13 plgGSDSPPageBuilder->viewPage() JROOT/administrator/components/com_gsd/helpers/plugin.php:411 12 GSDPlugin->getPayload() JROOT/administrator/components/com_gsd/helpers/plugin.php:232 11 GSDPlugin->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/plugins/system/gsd/gsd.php:121 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:75 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1034 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.37 ms После последнего запроса: 0.13 ms Память запроса: 0.026 MB Память до запроса: 21.645 MB Выбрано строк: 0
SELECT `params`
FROM `qp5wf_gsd`
WHERE `thing` = 24
AND `plugin` = 'sppagebuilder'
AND `state` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_gsd NULL ref state,thing_plugin thing_plugin 156 const,const 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_gsd/helpers/plugin.php:306 12 GSDPlugin->getSnippets() JROOT/administrator/components/com_gsd/helpers/plugin.php:238 11 GSDPlugin->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/plugins/system/gsd/gsd.php:121 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:75 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1034 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.23 ms После последнего запроса: 0.14 ms Память запроса: 0.026 MB Память до запроса: 21.654 MB Выбрано строк: 0
SELECT `params`
FROM `qp5wf_gsd`
WHERE `thing` = 435
AND `plugin` = 'menus'
AND `state` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE qp5wf_gsd NULL ref state,thing_plugin thing_plugin 156 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_gsd/helpers/plugin.php:306 12 GSDPlugin->getSnippets() JROOT/administrator/components/com_gsd/helpers/plugin.php:238 11 GSDPlugin->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 10 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 9 JEventDispatcher->trigger() JROOT/plugins/system/gsd/gsd.php:121 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:75 7 plgSystemGSD->onBeforeRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1034 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.40 ms После последнего запроса: 21.17 ms Память запроса: 0.043 MB Память до запроса: 22.927 MB Выбрано строк: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM qp5wf_fields AS a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qp5wf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN qp5wf_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Используется filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 irpint00_newsite.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.group_id 1 100.00 Using where Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.08 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.04 ms Creating tmp table 0.11 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.29 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.07 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 14 JHtmlContent::prepare() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15 10 include JROOT/modules/mod_custom/mod_custom.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 4.32 ms После последнего запроса: 56.39 ms Память запроса: 0.188 MB Память до запроса: 24.044 MB Выбрано строк: 12
SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,COUNT(asso2.id)>1 as association
FROM qp5wf_content AS a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qp5wf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qp5wf_categories AS c
ON c.id = a.catid
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
LEFT JOIN qp5wf_associations AS asso
ON asso.id = a.id
AND asso.context='com_content.item'
LEFT JOIN qp5wf_associations AS asso2
ON asso2.key = asso.key
WHERE (a.state = 0 OR a.state = 1)
AND a.catid = 95
GROUP BY a.id
ORDER BY a.hits desc
LIMIT 12id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias idx_catid 4 const 19 52.94 Using where; Using temporary; Используется filesort 1 SIMPLE l NULL ALL idx_langcode Индекс не используется NULL NULL 3 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.checked_out 1 100.00 Using where 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.access 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.created_by 1 100.00 Using where 1 SIMPLE asso NULL eq_ref PRIMARY PRIMARY 206 const,irpint00_newsite.a.id 1 100.00 Using where 1 SIMPLE asso2 NULL ref idx_key idx_key 128 irpint00_newsite.asso.key 2 100.00 Using index Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.10 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.20 ms preparing 0.06 ms Creating tmp table 0.08 ms Sorting result 0.01 ms executing 0.00 ms Sending data 2.38 ms Creating sort index 0.93 ms end 0.00 ms query end 0.01 ms removing tmp table 0.08 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.07 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1180 20 Su_Tools::getArticlesNoShowMore() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1318 19 Su_Tools::get_slides() JROOT/plugins/system/bdthemes_shortcodes/shortcodes/post_grid/shortcode.php:54 18 Su_Shortcode_post_grid::post_grid() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77 17 su_do_shortcode_tag() Так же, как вызов в строке ниже. 16 preg_replace_callback() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42 15 su_do_shortcode() JROOT/plugins/sppagebuilder/shortcode_ultimate/addons/su_post_grid/site.php:61 14 SppagebuilderAddonSu_post_grid->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.06 ms После последнего запроса: 0.21 ms Память запроса: 0.188 MB Память до запроса: 24.311 MB Выбрано строк: 12
SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,COUNT(asso2.id)>1 as association
FROM qp5wf_content AS a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qp5wf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qp5wf_categories AS c
ON c.id = a.catid
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
LEFT JOIN qp5wf_associations AS asso
ON asso.id = a.id
AND asso.context='com_content.item'
LEFT JOIN qp5wf_associations AS asso2
ON asso2.key = asso.key
WHERE (a.state = 0 OR a.state = 1)
AND a.id in (139,89,97,99,144,95,98,93,142,96,92,141)
GROUP BY a.id
ORDER BY a.hits desc
LIMIT 12id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL range PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias PRIMARY 4 NULL 12 43.75 Using where; Using temporary; Используется filesort 1 SIMPLE l NULL ALL idx_langcode Индекс не используется NULL NULL 3 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.checked_out 1 100.00 Using where 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.access 1 100.00 NULL 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.catid 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.created_by 1 100.00 Using where 1 SIMPLE asso NULL eq_ref PRIMARY PRIMARY 206 const,irpint00_newsite.a.id 1 100.00 Using where 1 SIMPLE asso2 NULL ref idx_key idx_key 128 irpint00_newsite.asso.key 2 100.00 Using index Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.87 ms Creating sort index 0.55 ms end 0.00 ms query end 0.01 ms removing tmp table 0.05 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1213 20 Su_Tools::getArticlesNoShowMore() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1318 19 Su_Tools::get_slides() JROOT/plugins/system/bdthemes_shortcodes/shortcodes/post_grid/shortcode.php:54 18 Su_Shortcode_post_grid::post_grid() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77 17 su_do_shortcode_tag() Так же, как вызов в строке ниже. 16 preg_replace_callback() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42 15 su_do_shortcode() JROOT/plugins/sppagebuilder/shortcode_ultimate/addons/su_post_grid/site.php:61 14 SppagebuilderAddonSu_post_grid->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.65 ms После последнего запроса: 2.52 ms Память запроса: 0.051 MB Память до запроса: 24.352 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 `qp5wf_categories` AS `s`
INNER JOIN `qp5wf_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('ru-RU','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 95
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right,idx_language Индекс не используется NULL NULL 80 7.70 Using where Status Duration starting 0.14 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.14 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 33 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 32 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 31 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 30 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 29 ContentRouter->getCategorySegment() Так же, как вызов в строке ниже. 28 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 27 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 26 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 25 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 24 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 23 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 22 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 21 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 20 Joomla\CMS\Router\Route::_() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1367 19 Su_Tools::get_slides() JROOT/plugins/system/bdthemes_shortcodes/shortcodes/post_grid/shortcode.php:54 18 Su_Shortcode_post_grid::post_grid() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77 17 su_do_shortcode_tag() Так же, как вызов в строке ниже. 16 preg_replace_callback() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42 15 su_do_shortcode() JROOT/plugins/sppagebuilder/shortcode_ultimate/addons/su_post_grid/site.php:61 14 SppagebuilderAddonSu_post_grid->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.49 ms После последнего запроса: 830.03 ms Память запроса: 0.031 MB Память до запроса: 24.377 MB Выбрано строк: 1
SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM qp5wf_modules AS m
WHERE m.published = 1
AND m.id = 135
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-12-01 08:03:07')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-12-01 08:03:07')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND m.language IN ('ru-RU','*')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL const PRIMARY,published,idx_language PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.08 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/components/com_sppagebuilder/addons/module/site.php:99 15 SppagebuilderAddonModule::getModules() JROOT/components/com_sppagebuilder/addons/module/site.php:28 14 SppagebuilderAddonModule->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.05 ms После последнего запроса: 72.30 ms Память запроса: 0.117 MB Память до запроса: 24.455 MB Выбрано строк: 5
SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,COUNT(asso2.id)>1 as association
FROM qp5wf_content AS a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qp5wf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qp5wf_categories AS c
ON c.id = a.catid
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
LEFT JOIN qp5wf_associations AS asso
ON asso.id = a.id
AND asso.context='com_content.item'
LEFT JOIN qp5wf_associations AS asso2
ON asso2.key = asso.key
WHERE (a.state = 0 OR a.state = 1)
AND a.catid = 90
GROUP BY a.id
ORDER BY a.ordering desc
LIMIT 16id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias idx_catid 4 const 5 52.94 Using where; Using temporary; Используется filesort 1 SIMPLE l NULL ALL idx_langcode Индекс не используется NULL NULL 3 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.checked_out 1 100.00 Using where 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.access 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.created_by 1 100.00 Using where 1 SIMPLE asso NULL eq_ref PRIMARY PRIMARY 206 const,irpint00_newsite.a.id 1 100.00 Using where 1 SIMPLE asso2 NULL ref idx_key idx_key 128 irpint00_newsite.asso.key 2 100.00 Using index Status Duration starting 0.11 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.76 ms Creating sort index 0.48 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1180 20 Su_Tools::getArticlesNoShowMore() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1318 19 Su_Tools::get_slides() JROOT/plugins/system/bdthemes_shortcodes/shortcodes/post_grid/shortcode.php:54 18 Su_Shortcode_post_grid::post_grid() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77 17 su_do_shortcode_tag() Так же, как вызов в строке ниже. 16 preg_replace_callback() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42 15 su_do_shortcode() JROOT/plugins/sppagebuilder/shortcode_ultimate/addons/su_post_grid/site.php:61 14 SppagebuilderAddonSu_post_grid->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.43 ms После последнего запроса: 0.21 ms Память запроса: 0.093 MB Память до запроса: 24.603 MB Выбрано строк: 4
SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,COUNT(asso2.id)>1 as association
FROM qp5wf_content AS a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qp5wf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qp5wf_categories AS c
ON c.id = a.catid
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
LEFT JOIN qp5wf_associations AS asso
ON asso.id = a.id
AND asso.context='com_content.item'
LEFT JOIN qp5wf_associations AS asso2
ON asso2.key = asso.key
WHERE (a.state = 0 OR a.state = 1)
AND a.catid = 91
GROUP BY a.id
ORDER BY a.ordering desc
LIMIT 16id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias idx_catid 4 const 6 52.94 Using where; Using temporary; Используется filesort 1 SIMPLE l NULL ALL idx_langcode Индекс не используется NULL NULL 3 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.checked_out 1 100.00 Using where 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.access 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.created_by 1 100.00 Using where 1 SIMPLE asso NULL eq_ref PRIMARY PRIMARY 206 const,irpint00_newsite.a.id 1 100.00 Using where 1 SIMPLE asso2 NULL ref idx_key idx_key 128 irpint00_newsite.asso.key 2 100.00 Using index Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.50 ms Creating sort index 0.34 ms end 0.00 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1180 20 Su_Tools::getArticlesNoShowMore() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1318 19 Su_Tools::get_slides() JROOT/plugins/system/bdthemes_shortcodes/shortcodes/post_grid/shortcode.php:54 18 Su_Shortcode_post_grid::post_grid() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77 17 su_do_shortcode_tag() Так же, как вызов в строке ниже. 16 preg_replace_callback() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42 15 su_do_shortcode() JROOT/plugins/sppagebuilder/shortcode_ultimate/addons/su_post_grid/site.php:61 14 SppagebuilderAddonSu_post_grid->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.27 ms После последнего запроса: 0.20 ms Память запроса: 0.064 MB Память до запроса: 24.714 MB Выбрано строк: 2
SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,COUNT(asso2.id)>1 as association
FROM qp5wf_content AS a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qp5wf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qp5wf_categories AS c
ON c.id = a.catid
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
LEFT JOIN qp5wf_associations AS asso
ON asso.id = a.id
AND asso.context='com_content.item'
LEFT JOIN qp5wf_associations AS asso2
ON asso2.key = asso.key
WHERE (a.state = 0 OR a.state = 1)
AND a.catid = 92
GROUP BY a.id
ORDER BY a.ordering desc
LIMIT 16id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias idx_catid 4 const 2 52.94 Using index condition; Using where; Using temporary; Используется filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 irpint00_newsite.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.checked_out 1 100.00 Using where 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.access 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.created_by 1 100.00 Using where 1 SIMPLE asso NULL eq_ref PRIMARY PRIMARY 206 const,irpint00_newsite.a.id 1 100.00 Using where 1 SIMPLE asso2 NULL ref idx_key idx_key 128 irpint00_newsite.asso.key 2 100.00 Using index Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms Creating tmp table 0.03 ms Sorting for group 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.45 ms Creating sort index 0.18 ms end 0.00 ms query end 0.01 ms removing tmp table 0.09 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1180 20 Su_Tools::getArticlesNoShowMore() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1318 19 Su_Tools::get_slides() JROOT/plugins/system/bdthemes_shortcodes/shortcodes/post_grid/shortcode.php:54 18 Su_Shortcode_post_grid::post_grid() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77 17 su_do_shortcode_tag() Так же, как вызов в строке ниже. 16 preg_replace_callback() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42 15 su_do_shortcode() JROOT/plugins/sppagebuilder/shortcode_ultimate/addons/su_post_grid/site.php:61 14 SppagebuilderAddonSu_post_grid->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.17 ms После последнего запроса: 0.16 ms Память запроса: 0.060 MB Память до запроса: 24.783 MB Выбрано строк: 2
SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,COUNT(asso2.id)>1 as association
FROM qp5wf_content AS a
LEFT JOIN `qp5wf_languages` AS l
ON l.lang_code = a.language
LEFT JOIN qp5wf_users AS uc
ON uc.id=a.checked_out
LEFT JOIN qp5wf_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN qp5wf_categories AS c
ON c.id = a.catid
LEFT JOIN qp5wf_users AS ua
ON ua.id = a.created_by
LEFT JOIN qp5wf_associations AS asso
ON asso.id = a.id
AND asso.context='com_content.item'
LEFT JOIN qp5wf_associations AS asso2
ON asso2.key = asso.key
WHERE (a.state = 0 OR a.state = 1)
AND a.catid = 93
GROUP BY a.id
ORDER BY a.ordering desc
LIMIT 16id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias idx_catid 4 const 2 52.94 Using index condition; Using where; Using temporary; Используется filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 irpint00_newsite.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.checked_out 1 100.00 Using where 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.access 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 irpint00_newsite.a.created_by 1 100.00 Using where 1 SIMPLE asso NULL eq_ref PRIMARY PRIMARY 206 const,irpint00_newsite.a.id 1 100.00 Using where 1 SIMPLE asso2 NULL ref idx_key idx_key 128 irpint00_newsite.asso.key 2 100.00 Using index Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms Creating tmp table 0.03 ms Sorting for group 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.41 ms Creating sort index 0.17 ms end 0.00 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1180 20 Su_Tools::getArticlesNoShowMore() JROOT/plugins/system/bdthemes_shortcodes/config/inc/tools.php:1318 19 Su_Tools::get_slides() JROOT/plugins/system/bdthemes_shortcodes/shortcodes/post_grid/shortcode.php:54 18 Su_Shortcode_post_grid::post_grid() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:77 17 su_do_shortcode_tag() Так же, как вызов в строке ниже. 16 preg_replace_callback() JROOT/plugins/system/bdthemes_shortcodes/helper/shortcodes.php:42 15 su_do_shortcode() JROOT/plugins/sppagebuilder/shortcode_ultimate/addons/su_post_grid/site.php:61 14 SppagebuilderAddonSu_post_grid->render() JROOT/components/com_sppagebuilder/parser/addon-parser.php:454 13 AddonParser::getAddonHtmlView() JROOT/components/com_sppagebuilder/parser/addon-parser.php:336 12 AddonParser::viewAddons() JROOT/modules/mod_sppagebuilder/tmpl/default.php:19 11 require JROOT/modules/mod_sppagebuilder/tmpl/default.php JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:12 10 include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.83 ms После последнего запроса: 0.13 ms Память запроса: 0.253 MB Память до запроса: 24.854 MB Выбрано строк: 13