Login
Участники проекта
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1555858839,
"last": 1555858839,
"now": 1555858839
},
"token": "GuHxUNQdatDmHDht5R8zcHR9DahAoS1k"
},
"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
}
}
}
Время
Память
Время: 24.99 ms / 24.99 ms Память: 1.960 MB / 2.19 MB Application: afterLoad
Время: 103.14 ms / 128.13 ms Память: 7.403 MB / 9.60 MB Application: afterInitialise
Время: 36.07 ms / 164.20 ms Память: 2.106 MB / 11.70 MB Application: Before Access::preloadComponents (all components)
Время: 1.62 ms / 165.82 ms Память: 0.106 MB / 11.81 MB Application: After Access::preloadComponents (all components)
Время: 0.10 ms / 165.91 ms Память: 0.000 MB / 11.80 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Время: 0.96 ms / 166.87 ms Память: 0.053 MB / 11.85 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Время: 0.96 ms / 167.83 ms Память: 0.042 MB / 11.90 MB Application: afterRoute
Время: 6.51 ms / 174.34 ms Память: 0.430 MB / 12.33 MB Application: beforeRenderComponent com_content
Время: 10.55 ms / 184.89 ms Память: 0.863 MB / 13.19 MB Application: Before Access::preloadPermissions (com_content)
Время: 1.35 ms / 186.24 ms Память: 0.135 MB / 13.32 MB Application: After Access::preloadPermissions (com_content)
Время: 0.06 ms / 186.31 ms Память: 0.000 MB / 13.32 MB Application: Before Access::getAssetRules (id:98 name:com_content.category.13)
Время: 0.19 ms / 186.50 ms Память: 0.013 MB / 13.33 MB Application: After Access::getAssetRules (id:98 name:com_content.category.13)
Время: 6.31 ms / 192.81 ms Память: 0.407 MB / 13.74 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Время: 0.03 ms / 192.84 ms Память: 0.003 MB / 13.74 MB Application: After Access::getAssetRules (id:8 name:com_content)
Время: 40.30 ms / 233.14 ms Память: 3.540 MB / 17.28 MB Application: afterRenderComponent com_content
Время: 1.93 ms / 235.07 ms Память: 0.158 MB / 17.44 MB Application: afterDispatch
Время: 14.08 ms / 249.15 ms Память: 0.749 MB / 18.19 MB Application: beforeRenderModule mod_cblogin (Login)
Время: 100.05 ms / 349.20 ms Память: 12.236 MB / 30.42 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Время: 0.16 ms / 349.36 ms Память: 0.013 MB / 30.44 MB Application: After Access::getAssetRules (id:1 name:root.1)
Время: 13.40 ms / 362.75 ms Память: 0.549 MB / 30.98 MB Application: afterRenderModule mod_cblogin (Login)
Время: 0.14 ms / 362.89 ms Память: 0.000 MB / 30.96 MB Application: beforeRenderModule mod_yj_vertical_menu (Участники проекта)
Время: 2.79 ms / 365.68 ms Память: 0.075 MB / 31.03 MB Application: afterRenderModule mod_yj_vertical_menu (Участники проекта)
Время: 0.24 ms / 365.92 ms Память: 0.015 MB / 31.05 MB Application: beforeRenderModule mod_accordeonck (Выбор жанра)
Время: 11.29 ms / 377.22 ms Память: 0.463 MB / 31.51 MB Application: afterRenderModule mod_accordeonck (Выбор жанра)
Время: 0.34 ms / 377.56 ms Память: 0.000 MB / 31.47 MB Application: beforeRenderModule mod_accordeonck (Фонотека)
Время: 12.43 ms / 389.99 ms Память: 0.316 MB / 31.78 MB Application: afterRenderModule mod_accordeonck (Фонотека)
Время: 0.28 ms / 390.27 ms Память: 0.000 MB / 31.71 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 2.84 ms / 393.11 ms Память: 0.038 MB / 31.75 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Время: 0.19 ms / 393.30 ms Память: 0.000 MB / 31.74 MB Application: beforeRenderModule mod_menu (Main Menu)
Время: 5.15 ms / 398.45 ms Память: 0.165 MB / 31.91 MB Application: afterRenderModule mod_menu (Main Menu)
Время: 5.84 ms / 404.29 ms Память: 0.267 MB / 32.17 MB Application: afterRender
Всего SQL-запросов: 23.20 ms
32.72 MB (34 309 656 Байт)
32 SQL-запросов зафиксировано 23.20 ms
- Время запроса: 0.28 ms Память запроса: 0.021 MB Память до запроса: 4.446 MB Выбрано строк: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '8e8h2knv6ita52fgcsvp365j90'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Так же, как вызов в строке ниже. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.24 ms После последнего запроса: 2.71 ms Память запроса: 0.013 MB Память до запроса: 4.622 MB Выбрано строк: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '8e8h2knv6ita52fgcsvp365j90'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.31 ms После последнего запроса: 0.26 ms Память запроса: 0.010 MB Память до запроса: 4.639 MB
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('8e8h2knv6ita52fgcsvp365j90', 1, 1555858839, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('8e8h2knv6ita52fgcsvp365j90', 1, 1555858839, 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.12 ms Waiting for query cache lock 0.00 ms update 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.02 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 - Время запроса: 1.08 ms После последнего запроса: 4.14 ms Память запроса: 0.024 MB Память до запроса: 4.976 MB Выбрано строк: 45
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_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 jos_extensions NULL ref extension extension 82 const 46 1.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.02 ms executing 0.00 ms Sending data 0.55 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Так же, как вызов в строке ниже. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 3.74 ms Память запроса: 0.015 MB Память до запроса: 5.296 MB Выбрано строк: 5
SELECT id, rules
FROM `jos_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_viewlevels NULL ALL NULL Индекс не используется NULL NULL 5 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 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.11 ms end 0.00 ms query end 0.02 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.43 ms После последнего запроса: 0.25 ms Память запроса: 0.016 MB Память до запроса: 5.321 MB Выбрано строк: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.02 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.73 ms После последнего запроса: 1.07 ms Память запроса: 0.020 MB Память до запроса: 5.424 MB Выбрано строк: 107
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_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 jos_extensions NULL ref extension extension 82 const 136 0.60 Using index condition; Using where; Используется filesort Status Duration starting 0.07 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.06 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.32 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.64 ms После последнего запроса: 49.77 ms Память запроса: 0.041 MB Память до запроса: 9.168 MB Выбрано строк: 44
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 jos_menu AS m
LEFT JOIN jos_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 61 3.33 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.m.component_id 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.06 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 22 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Так же, как вызов в строке ниже. 21 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 20 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 19 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 18 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 17 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 16 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 15 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 14 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 13 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 12 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 11 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 10 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/communitybuilder/communitybuilder.php:300 9 plgSystemCommunityBuilder->onAfterInitialise() Так же, как вызов в строке ниже. 8 call_user_func_array() 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 - Время запроса: 1.04 ms После последнего запроса: 24.72 ms Память запроса: 0.028 MB Память до запроса: 11.157 MB Выбрано строк: 2
SHOW FULL COLUMNS
FROM `jos_komento_configs`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `jos_komento_configs`Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.34 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.03 ms checking permissions 0.05 ms checking permissions 0.02 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.31 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_komento/tables/parent.php:18 14 KomentoParentTable->__construct() JROOT/administrator/components/com_komento/tables/configs.php:40 13 KomentoTableConfigs->__construct() JROOT/libraries/src/Table/Table.php:312 12 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_komento/tables/parent.php:49 11 KomentoParentTable::getInstance() JROOT/components/com_komento/helpers/helper.php:99 10 Komento::getTable() JROOT/components/com_komento/helpers/helper.php:228 9 Komento::getKonfig() JROOT/components/com_komento/bootstrap.php:30 8 require_once JROOT/components/com_komento/bootstrap.php JROOT/components/com_komento/router.php:16 7 require_once JROOT/components/com_komento/router.php JROOT/libraries/src/Router/SiteRouter.php:775 6 Joomla\CMS\Router\SiteRouter->getComponentRouter() JROOT/libraries/src/Router/SiteRouter.php:130 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.26 ms После последнего запроса: 0.94 ms Память запроса: 0.017 MB Память до запроса: 11.219 MB Выбрано строк: 1
SELECT *
FROM jos_komento_configs
WHERE `component` = 'com_komento'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_komento_configs NULL ALL NULL Индекс не используется NULL NULL 5 20.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.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_komento/helpers/helper.php:229 9 Komento::getKonfig() JROOT/components/com_komento/bootstrap.php:30 8 require_once JROOT/components/com_komento/bootstrap.php JROOT/components/com_komento/router.php:16 7 require_once JROOT/components/com_komento/router.php JROOT/libraries/src/Router/SiteRouter.php:775 6 Joomla\CMS\Router\SiteRouter->getComponentRouter() JROOT/libraries/src/Router/SiteRouter.php:130 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.98 ms После последнего запроса: 12.43 ms Память запроса: 0.028 MB Память до запроса: 11.710 MB Выбрано строк: 45
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_advportfolio','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_droppics','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_universal_ajax_live_search','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_assets NULL ALL idx_asset_name Индекс не используется NULL NULL 186 24.73 Using where Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.21 ms preparing 0.01 ms executing 0.00 ms Sending data 0.46 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 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/plugins/system/advancedmodules/src/Document.php:28 13 RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() JROOT/plugins/system/advancedmodules/src/Helper.php:32 12 RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute() Так же, как вызов в строке ниже. 11 call_user_func_array() JROOT/plugins/system/advancedmodules/src/Plugin.php:97 10 RegularLabs\Plugin\System\AdvancedModules\Plugin->run() JROOT/plugins/system/advancedmodules/advancedmodules.php:64 9 PlgSystemAdvancedModules->onAfterRoute() Так же, как вызов в строке ниже. 8 call_user_func_array() 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:1119 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.35 ms После последнего запроса: 2.97 ms Память запроса: 0.020 MB Память до запроса: 11.951 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_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.00 ms Opening tables 0.01 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.05 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 # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Так же, как вызов в строке ниже. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1119 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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 После последнего запроса: 0.33 ms Память запроса: 0.013 MB Память до запроса: 11.954 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"5d029a9d979a186a717d516aa7b7beb4\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos_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.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.05 ms updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.06 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1119 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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.82 ms Память запроса: 0.014 MB Память до запроса: 12.280 MB Выбрано строк: 1
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_languages NULL ALL NULL Индекс не используется NULL NULL 2 50.00 Using where; Используется filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 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.44 ms После последнего запроса: 0.71 ms Память запроса: 0.010 MB Память до запроса: 12.312 MB Выбрано строк: 4
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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 s NULL ALL idx_template Индекс не используется NULL NULL 6 16.67 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 sixworlds_app_joomla_0.s.template,const 1 4.45 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.12 ms end 0.00 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.58 ms После последнего запроса: 11.33 ms Память запроса: 0.030 MB Память до запроса: 13.191 MB Выбрано строк: 75
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_assets NULL ALL idx_asset_name,idx_parent_id Индекс не используется NULL NULL 186 23.33 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.01 ms executing 0.00 ms Sending data 0.20 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.91 ms После последнего запроса: 2.54 ms Память запроса: 0.030 MB Память до запроса: 13.424 MB Выбрано строк: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `jos_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 13
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Используется filesort 1 PRIMARY c NULL ALL cat_idx,idx_left_right Индекс не используется NULL NULL 21 39.91 Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 sixworlds_app_joomla_0.c.id 4 100.00 Using index condition; Using where Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.18 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.14 ms executing 0.00 ms Sending data 0.03 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.93 ms После последнего запроса: 3.73 ms Память запроса: 0.034 MB Память до запроса: 13.739 MB Выбрано строк: 0
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 13
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-04-21 15:00:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-04-21 15:00:39')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 1 16.00 Using index condition; Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.a.id 1 100.00 Using where Status Duration starting 0.20 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.12 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.44 ms После последнего запроса: 1.75 ms Память запроса: 0.024 MB Память до запроса: 13.931 MB Выбрано строк: 1
SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 13
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-04-21 15:00:39')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-04-21 15:00:39')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 1 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where; Using index 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.a.id 1 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.05 ms executing 0.00 ms Sending data 0.02 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 # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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.45 ms После последнего запроса: 2.54 ms Память запроса: 0.026 MB Память до запроса: 14.151 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 13
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type Индекс не используется NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 sixworlds_app_joomla_0.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.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 - Время запроса: 1.65 ms После последнего запроса: 37.92 ms Память запроса: 0.035 MB Память до запроса: 17.633 MB Выбрано строк: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM jos_modules AS m
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN jos_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1,5)
AND m.client_id = 0
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 published,newsfeeds published 1 const 25 3.00 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 sixworlds_app_joomla_0.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE am NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.m.id 1 100.00 Using where Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.11 ms end 0.00 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:406 16 PlgSystemAdvancedModuleHelper->getModuleList() JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123 15 PlgSystemAdvancedModuleHelper->onPrepareModuleList() Так же, как вызов в строке ниже. 14 call_user_func_array() JROOT/libraries/joomla/event/dispatcher.php:165 13 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 12 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Helper/ModuleHelper.php:357 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/ajt005_j30/functions.php:3 8 include JROOT/templates/ajt005_j30/functions.php JROOT/templates/ajt005_j30/index.php:18 7 require JROOT/templates/ajt005_j30/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.43 ms После последнего запроса: 35.40 ms Память запроса: 0.037 MB Память до запроса: 20.924 MB Выбрано строк: 1
SELECT `params`
FROM `jos_comprofiler_plugin`
WHERE `id` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_comprofiler_plugin NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 28 JDatabaseDriver->loadResult() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 27 CBLib\Database\Driver\CmsDatabaseDriver->loadResult() JROOT/libraries/CBLib/CB/Application/CBConfig.php:43 26 CB\Application\CBConfig::getConfig() JROOT/libraries/CBLib/CB/Application/CBApplication.php:45 25 CB\Application\CBApplication::CB\Application\{closure}() Так же, как вызов в строке ниже. 24 call_user_func_array() JROOT/libraries/CBLib/CBLib/Application/Config.php:38 23 CBLib\Application\Config::setMainConfig() JROOT/libraries/CBLib/CBLib/Core/CBLib.php:70 22 CBLib\Core\CBLib::CBLib\Core\{closure}() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605 21 CBLib\DependencyInjection\Container->build() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496 20 CBLib\DependencyInjection\Container->make() JROOT/libraries/CBLib/CBLib/Application/Application.php:179 19 CBLib\Application\Application::__callStatic() JROOT/libraries/CBLib/CB/Application/CBConfig.php:77 18 CBLib\Application\Application::Config() JROOT/libraries/CBLib/CB/Application/CBConfig.php:77 17 CB\Application\CBConfig::loadLegacyCBueConfig() JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109 16 CB\Legacy\LegacyFoundationFunctions->__construct() Так же, как вызов в строке ниже. 15 ReflectionClass->newInstanceArgs() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643 14 CBLib\DependencyInjection\Container->build() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496 13 CBLib\DependencyInjection\Container->make() JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132 12 CBLib\DependencyInjection\Container->get() JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33 11 include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php JROOT/modules/mod_cblogin/mod_cblogin.php:22 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.57 ms После последнего запроса: 17.42 ms Память запроса: 0.026 MB Память до запроса: 22.923 MB Выбрано строк: 11
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `jos_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,5)
AND `type` = 'user'
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_comprofiler_plugin NULL ref idx_folder,type_pub_order type_pub_order 404 const,const 11 20.00 Using index condition; Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.01 ms Sending data 0.13 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 14 JDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394 13 CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446 12 CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181 11 cbPluginHandler->loadPluginGroup() JROOT/modules/mod_cblogin/mod_cblogin.php:64 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.59 ms После последнего запроса: 35.76 ms Память запроса: 0.048 MB Память до запроса: 28.689 MB Выбрано строк: 2
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `jos_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,5)
AND `type` = 'user/plug_cbgroupjive/plugins'
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_comprofiler_plugin NULL ref idx_folder,type_pub_order type_pub_order 404 const,const 2 20.00 Using index condition; Using where Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 33 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 32 JDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394 31 CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446 30 CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181 29 cbPluginHandler->loadPluginGroup() JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php:23 28 require_once JROOT/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.php JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402 27 cbPluginHandler->_loadPluginFile() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238 26 cbPluginHandler->loadPluginGroup() JROOT/components/com_comprofiler/plugin/user/plug_cbconditional/cbconditional.php:14 25 require_once JROOT/components/com_comprofiler/plugin/user/plug_cbconditional/cbconditional.php JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402 24 cbPluginHandler->_loadPluginFile() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238 23 cbPluginHandler->loadPluginGroup() JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22 22 require_once JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402 21 cbPluginHandler->_loadPluginFile() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238 20 cbPluginHandler->loadPluginGroup() JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php:14 19 require_once JROOT/components/com_comprofiler/plugin/user/plug_cbprivacy/cbprivacy.php JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402 18 cbPluginHandler->_loadPluginFile() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238 17 cbPluginHandler->loadPluginGroup() JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:22 16 require_once JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402 15 cbPluginHandler->_loadPluginFile() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238 14 cbPluginHandler->loadPluginGroup() JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:20 13 require_once JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402 12 cbPluginHandler->_loadPluginFile() JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238 11 cbPluginHandler->loadPluginGroup() JROOT/modules/mod_cblogin/mod_cblogin.php:64 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.82 ms После последнего запроса: 7.47 ms Память запроса: 0.033 MB Память до запроса: 29.332 MB Выбрано строк: 16
SHOW FULL COLUMNS
FROM `jos_users`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `jos_users`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.28 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.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.12 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 19 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:40 18 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:312 17 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 16 Joomla\CMS\User\User::getTable() JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:180 15 CB\Database\Table\UserTable->_reinitNonComprofileVars() JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:120 14 CB\Database\Table\UserTable->__construct() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194 13 CBuser::_getOrSetInstance() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84 12 CBuser::getInstance() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:68 11 CBuser::getMyInstance() JROOT/modules/mod_cblogin/mod_cblogin.php:68 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.32 ms После последнего запроса: 3.86 ms Память запроса: 0.067 MB Память до запроса: 29.793 MB Выбрано строк: 60
SELECT f.*
FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
ORDER BY t.position, t.ordering, f.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f NULL ALL tabid_pub_prof_order Индекс не используется NULL NULL 63 10.00 Using where; Using temporary; Используется filesort 1 SIMPLE t NULL eq_ref PRIMARY PRIMARY 4 sixworlds_app_joomla_0.f.tabid 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 1.04 ms Creating sort index 0.74 ms end 0.00 ms query end 0.01 ms removing tmp table 0.13 ms query end 0.00 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 19 JDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394 18 CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446 17 CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList() JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:953 16 cbTabs->_getTabFieldsDb() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332 15 CBuser->getField() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1075 14 CBuser->_evaluateCbFields() Так же, как вызов в строке ниже. 13 preg_replace_callback() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1125 12 CBuser->_evaluateCbFields() JROOT/libraries/CBLib/CB/Legacy/CBuser.php:640 11 CBuser->replaceUserVars() JROOT/modules/mod_cblogin/mod_cblogin.php:134 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.73 ms После последнего запроса: 7.50 ms Память запроса: 0.022 MB Память до запроса: 30.494 MB Выбрано строк: 2
SELECT `id`
FROM `jos_menu`
WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
AND `published` = 1
AND `access` IN ( 1,5 )
AND `language` IN ( 'ru-RU', '*', '' )
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 56 0.82 Using index condition; Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.38 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 14 CBLib\Database\Driver\CmsDatabaseDriver->loadResult() JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:242 13 getCBprofileItemid() JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967 12 CBframework->viewUrl() JROOT/libraries/CBLib/CB/Legacy/CBframework.php:826 11 CBframework->userProfileUrl() JROOT/modules/mod_cblogin/mod_cblogin.php:198 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.73 ms После последнего запроса: 7.33 ms Память запроса: 0.022 MB Память до запроса: 31.024 MB Выбрано строк: 1
SELECT `id`
FROM `jos_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
AND `published` = 1
AND `access` IN ( 1,5 )
AND `language` IN ( 'ru-RU', '*', '' )
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 56 0.82 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.37 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 14 CBLib\Database\Driver\CmsDatabaseDriver->loadResult() JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222 13 getCBprofileItemid() JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967 12 CBframework->viewUrl() JROOT/modules/mod_cblogin/tmpl/bootstrap.php:15 11 require JROOT/modules/mod_cblogin/tmpl/bootstrap.php JROOT/modules/mod_cblogin/mod_cblogin.php:219 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.53 ms После последнего запроса: 0.67 ms Память запроса: 0.022 MB Память до запроса: 31.047 MB Выбрано строк: 1
SELECT `id`
FROM `jos_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
AND `published` = 1
AND `access` IN ( 1,5 )
AND `language` IN ( 'ru-RU', '*', '' )
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 56 0.82 Using index condition; Using where Status Duration starting 0.04 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.01 ms executing 0.00 ms Sending data 0.24 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 # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 14 CBLib\Database\Driver\CmsDatabaseDriver->loadResult() JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222 13 getCBprofileItemid() JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967 12 CBframework->viewUrl() JROOT/modules/mod_cblogin/tmpl/bootstrap.php:151 11 require JROOT/modules/mod_cblogin/tmpl/bootstrap.php JROOT/modules/mod_cblogin/mod_cblogin.php:219 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.52 ms После последнего запроса: 0.54 ms Память запроса: 0.022 MB Память до запроса: 31.070 MB Выбрано строк: 2
SELECT `id`
FROM `jos_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
AND `published` = 1
AND `access` IN ( 1,5 )
AND `language` IN ( 'ru-RU', '*', '' )
AND `client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 56 0.82 Using index condition; 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.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.26 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 15 JDatabaseDriver->loadResult() JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 14 CBLib\Database\Driver\CmsDatabaseDriver->loadResult() JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222 13 getCBprofileItemid() JROOT/libraries/CBLib/CB/Legacy/CBframework.php:967 12 CBframework->viewUrl() JROOT/modules/mod_cblogin/tmpl/bootstrap.php:165 11 require JROOT/modules/mod_cblogin/tmpl/bootstrap.php JROOT/modules/mod_cblogin/mod_cblogin.php:219 10 include JROOT/modules/mod_cblogin/mod_cblogin.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.60 ms После последнего запроса: 7.11 ms Память запроса: 0.027 MB Память до запроса: 31.342 MB Выбрано строк: 25Повторяющиеся запросы: #32
SELECT *
FROM jos_modules
WHERE published=1
ORDER BY id ;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_modules NULL ref published published 1 const 25 100.00 Using index condition; Используется filesort Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.30 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_accordeonck/helper.php:208 12 ModaccordeonckHelper::CreateModulesList() JROOT/modules/mod_accordeonck/helper.php:40 11 ModaccordeonckHelper::GetItems() JROOT/modules/mod_accordeonck/mod_accordeonck.php:21 10 include JROOT/modules/mod_accordeonck/mod_accordeonck.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.45 ms После последнего запроса: 10.35 ms Память запроса: 0.028 MB Память до запроса: 31.574 MB Выбрано строк: 25Повторяющиеся запросы: #31
SELECT *
FROM jos_modules
WHERE published=1
ORDER BY id ;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_modules NULL ref published published 1 const 25 100.00 Using index condition; Используется filesort Status Duration starting 0.03 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 Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.19 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_accordeonck/helper.php:208 12 ModaccordeonckHelper::CreateModulesList() JROOT/modules/mod_accordeonck/helper.php:40 11 ModaccordeonckHelper::GetItems() JROOT/modules/mod_accordeonck/mod_accordeonck.php:21 10 include JROOT/modules/mod_accordeonck/mod_accordeonck.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
25 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
4 × SELECT `id`
FROM `jos_menu`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`2 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `jos_comprofiler_plugin`2 × SELECT *
FROM jos_modules2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`1 × SELECT COUNT(*)
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `params`
FROM `jos_comprofiler_plugin`1 × SELECT f.*
FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM jos_modules AS m
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN jos_advancedmodules as am
ON am.moduleid = m.id1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jos_viewlevels1 × SELECT `session_id`
FROM `jos_session`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions1 × 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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `jos_session`1 × SELECT *
FROM jos_languages1 × SELECT *
FROM jos_komento_configs1 × 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,( SELECT COUNT(i.`id`)
FROM `jos_content` AS `i`
Прочие SQL-запросы:
1 × SHOW FULL COLUMNS
FROM `jos_users1 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"5d029a9d979a186a717d516aa7b7beb4\"}'1 × SHOW FULL COLUMNS
FROM `jos_komento_configs1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('8e8h2knv6ita52fgcsvp365j90', 1, 1555858839, 0, '', 0