- Главная
- Сведения о медицинской организации
- Информация для пациентов
- Информация для специалистов
- Медицинские работники
- Вакансии
- Лекарственное обеспечение
- Вышестоящие и контролирующие органы
- Документы
- Отзывы пациентов
- Контактная информация
- Электронные услуги
- Диспансеризация
- Противодействие коррупции
- Поиск
- ВАКЦИНАЦИЯ
Menu
- Главная
- Сведения о медицинской организации
- Информация для пациентов
- Информация для специалистов
- Медицинские работники
- Вакансии
- Лекарственное обеспечение
- Вышестоящие и контролирующие органы
- Документы
- Отзывы пациентов
- Контактная информация
- Электронные услуги
- Диспансеризация
- Противодействие коррупции
- Поиск
- ВАКЦИНАЦИЯ
- Подробности
- Просмотров: 269
- Подробности
- Просмотров: 284
- Подробности
- Просмотров: 318
- Подробности
- Просмотров: 237
© 2021 ОБУЗ "Дмитриевская ЦРБ". Все права защищены.
Joomla! - бесплатное программное обеспечение, распространяемое по лицензии GNU General Public License.
Счётчик yandex.ru
Счётчик sputnik.ru
JSN Boot template designed by JoomlaShine.com
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1614507955,
"last": 1614507955,
"now": 1614507955
},
"client": {
"forwarded": "34.234.223.227"
},
"token": "rpwoU4PSfVdybRqmeLIm48nmhIzJ93Wq"
},
"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
}
}
}
Время
Память
Время: 8.07 ms / 8.07 ms Память: 0.581 MB / 0.93 MB Application: afterLoad
Время: 45.22 ms / 53.28 ms Память: 1.031 MB / 1.96 MB Application: afterInitialise
Время: 10.56 ms / 63.85 ms Память: 0.401 MB / 2.36 MB Application: afterRoute
Время: 2.95 ms / 66.80 ms Память: 0.062 MB / 2.42 MB Application: beforeRenderComponent com_content
Время: 2.01 ms / 68.81 ms Память: 0.136 MB / 2.55 MB Application: Before Access::preloadComponents (all components)
Время: 1.45 ms / 70.26 ms Память: 0.060 MB / 2.61 MB Application: After Access::preloadComponents (all components)
Время: 0.05 ms / 70.31 ms Память: 0.000 MB / 2.61 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Время: 0.34 ms / 70.64 ms Память: 0.009 MB / 2.62 MB Application: After Access::getAssetRules (id:8 name:com_content)
Время: 29.65 ms / 100.29 ms Память: 0.513 MB / 3.13 MB Application: afterRenderComponent com_content
Время: 0.67 ms / 100.97 ms Память: 0.010 MB / 3.14 MB Application: afterDispatch
Время: 22.23 ms / 123.19 ms Память: 0.457 MB / 3.60 MB Application: beforeRenderModule mod_custom (Счётчик yandex.ru)
Время: 0.66 ms / 123.86 ms Память: 0.007 MB / 3.61 MB Application: afterRenderModule mod_custom (Счётчик yandex.ru)
Время: 0.04 ms / 123.90 ms Память: 0.001 MB / 3.61 MB Application: beforeRenderModule mod_custom (Счётчик sputnik.ru)
Время: 0.20 ms / 124.10 ms Память: 0.004 MB / 3.61 MB Application: afterRenderModule mod_custom (Счётчик sputnik.ru)
Время: 0.07 ms / 124.17 ms Память: 0.000 MB / 3.61 MB Application: beforeRenderModule mod_footer (Копирайт)
Время: 0.51 ms / 124.69 ms Память: 0.007 MB / 3.62 MB Application: afterRenderModule mod_footer (Копирайт)
Время: 0.07 ms / 124.75 ms Память: 0.000 MB / 3.62 MB Application: beforeRenderModule mod_slider (Слайдер внизу)
Время: 1.93 ms / 126.68 ms Память: 0.130 MB / 3.75 MB Application: afterRenderModule mod_slider (Слайдер внизу)
Время: 0.10 ms / 126.78 ms Память: 0.000 MB / 3.75 MB Application: beforeRenderModule mod_custom (Баннеры внизу страницы)
Время: 0.23 ms / 127.01 ms Память: 0.003 MB / 3.75 MB Application: afterRenderModule mod_custom (Баннеры внизу страницы)
Время: 0.07 ms / 127.08 ms Память: 0.000 MB / 3.75 MB Application: beforeRenderModule mod_custom (Полезные ссылки)
Время: 2.14 ms / 129.22 ms Память: 0.014 MB / 3.76 MB Application: afterRenderModule mod_custom (Полезные ссылки)
Время: 0.08 ms / 129.30 ms Память: 0.001 MB / 3.76 MB Application: beforeRenderModule mod_slider (Слайдер с наркотой под контентом)
Время: 1.50 ms / 130.80 ms Память: 0.119 MB / 3.88 MB Application: afterRenderModule mod_slider (Слайдер с наркотой под контентом)
Время: 0.06 ms / 130.85 ms Память: 0.000 MB / 3.88 MB Application: beforeRenderModule mod_slider (Huge-IT Slider Module (верхний слайдер))
Время: 1.56 ms / 132.42 ms Память: 0.141 MB / 4.02 MB Application: afterRenderModule mod_slider (Huge-IT Slider Module (верхний слайдер))
Время: 0.11 ms / 132.53 ms Память: 0.000 MB / 4.01 MB Application: beforeRenderModule mod_custom (Версия для слабовидящих)
Время: 0.23 ms / 132.76 ms Память: 0.003 MB / 4.02 MB Application: afterRenderModule mod_custom (Версия для слабовидящих)
Время: 0.07 ms / 132.83 ms Память: 0.001 MB / 4.02 MB Application: beforeRenderModule mod_menu (Main Menu)
Время: 7.80 ms / 140.63 ms Память: 0.159 MB / 4.18 MB Application: afterRenderModule mod_menu (Main Menu)
Время: 981.59 ms / 1122.22 ms Память: 0.741 MB / 4.92 MB Application: afterRender
Всего SQL-запросов: 55.80 ms
5.52 MB (5 787 832 Байт)
48 SQL-запросов зафиксировано 55.80 ms
12 повторяющийся запрос!
- Время запроса: 0.37 ms Память запроса: 0.025 MB Память до запроса: 1.263 MB Выбрано строк: 0
SELECT `data`
FROM `DCRB_session`
WHERE `session_id` = X'3965656265616635393336613737393037313737303832613835636363303164'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_session const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 ms executing 0.01 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 # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 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.25 ms После последнего запроса: 0.58 ms Память запроса: 0.022 MB Память до запроса: 1.279 MB Выбрано строк: 0
SELECT `session_id`
FROM `DCRB_session`
WHERE `session_id` = X'3965656265616635393336613737393037313737303832613835636363303164'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_session const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 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.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 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 - Время запроса: 18.86 ms После последнего запроса: 0.14 ms Память запроса: 0.004 MB Память до запроса: 1.284 MB
INSERT INTO `DCRB_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3965656265616635393336613737393037313737303832613835636363303164', 1, 1614507955, 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `DCRB_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3965656265616635393336613737393037313737303832613835636363303164', 1, 1614507955, 0, '', 0)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 update 18.56 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.01 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.72 ms После последнего запроса: 0.98 ms Память запроса: 0.029 MB Память до запроса: 1.321 MB Выбрано строк: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `DCRB_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_extensions ref extension extension 82 const 27 100.00 Using index condition; Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms Sending data 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 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.33 ms После последнего запроса: 0.94 ms Память запроса: 0.023 MB Память до запроса: 1.362 MB Выбрано строк: 5
SELECT id, rules
FROM `DCRB_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_viewlevels ALL NULL Индекс не используется NULL NULL 5 100.00 NULL Status Duration starting 0.03 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.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 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.43 ms После последнего запроса: 0.14 ms Память запроса: 0.022 MB Память до запроса: 1.374 MB Выбрано строк: 1
SELECT b.id
FROM DCRB_usergroups AS a
LEFT JOIN DCRB_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 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.21 ms После последнего запроса: 0.26 ms Память запроса: 0.039 MB Память до запроса: 1.396 MB Выбрано строк: 92
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM DCRB_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_extensions ref extension extension 82 const 148 100.00 Using index condition; Using where; Используется filesort Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.70 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 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.87 ms После последнего запроса: 14.46 ms Память запроса: 0.052 MB Память до запроса: 2.049 MB Выбрано строк: 27
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 DCRB_menu AS m
LEFT JOIN DCRB_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 1 100.00 Using index condition; Using where; Используется filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 u426485.m.component_id 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.38 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1073 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.58 ms После последнего запроса: 3.87 ms Память запроса: 0.024 MB Память до запроса: 2.297 MB Выбрано строк: 1
SELECT id, home, template, s.params
FROM DCRB_template_styles as s
LEFT JOIN DCRB_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 2 100.00 NULL 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 u426485.s.template,const 1 100.00 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 11 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33 10 jsn_template_framework_class_loader() Так же, как вызов в строке ниже. 9 spl_autoload_call() JROOT/plugins/system/jsntplframework/jsntplframework.php:187 8 PlgSystemJSNTPLFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/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.49 ms После последнего запроса: 0.42 ms Память запроса: 0.024 MB Память до запроса: 2.326 MB Выбрано строк: 1
SELECT manifest_cache
FROM DCRB_extensions
WHERE element LIKE 'jsn_boot_pro'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_extensions range element_clientid,element_folder_clientid element_clientid 402 NULL 1 100.00 Using index condition Status Duration starting 0.03 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.17 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122 12 JSNTplHelper::getManifestCache() JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217 11 JSNTplHelper::getTemplateVersion() JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35 10 jsn_template_framework_class_loader() Так же, как вызов в строке ниже. 9 spl_autoload_call() JROOT/plugins/system/jsntplframework/jsntplframework.php:187 8 PlgSystemJSNTPLFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/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.56 ms После последнего запроса: 2.96 ms Память запроса: 0.023 MB Память до запроса: 2.353 MB Выбрано строк: 1
SELECT COUNT(*)
FROM DCRB_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 100.00 Using index condition; Using where 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.02 ms statistics 0.21 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1166 10 JSNTplUtils->checkSH404SEF() JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36 9 JSNTPLFramework::initial() JROOT/plugins/system/jsntplframework/jsntplframework.php:191 8 PlgSystemJSNTPLFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/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.55 ms После последнего запроса: 0.42 ms Память запроса: 0.025 MB Память до запроса: 2.378 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `DCRB_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.04 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.20 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 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:1130 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.54 ms После последнего запроса: 0.23 ms Память запроса: 0.005 MB Память до запроса: 2.368 MB
UPDATE `DCRB_extensions`
SET `params` = '{\"mediaversion\":\"7a04c46331adb93e59375d73c30c79ea\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.21 ms updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.01 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 # Вызывающий объект Файл и номер строки 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:1130 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.34 ms После последнего запроса: 0.55 ms Память запроса: 0.025 MB Память до запроса: 2.406 MB Выбрано строк: 1
SELECT *
FROM DCRB_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_languages system NULL Индекс не используется NULL NULL 1 100.00 NULL Status Duration starting 0.03 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.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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 - Время запроса: 1.17 ms После последнего запроса: 2.63 ms Память запроса: 0.031 MB Память до запроса: 2.559 MB Выбрано строк: 40
SELECT `id`,`name`,`rules`,`parent_id`
FROM `DCRB_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djmediatools','com_easybookreloaded','com_fields','com_finder','com_installer','com_jmwascanner','com_joomlaupdate','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_slider','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_assets ALL idx_asset_name Индекс не используется NULL NULL 304 13.49 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.02 ms executing 0.01 ms Sending data 0.64 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 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_content/models/articles.php:115 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:45 13 ContentModelFeatured->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:55 10 ContentViewFeatured->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 - Время запроса: 9.01 ms После последнего запроса: 1.29 ms Память запроса: 0.054 MB Память до запроса: 2.657 MB Выбрано строк: 5
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 DCRB_content AS a
LEFT JOIN DCRB_categories AS c
ON c.id = a.catid
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_by
LEFT JOIN DCRB_users AS uam
ON uam.id = a.modified_by
LEFT JOIN DCRB_categories as parent
ON parent.id = c.parent_id
LEFT JOIN DCRB_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-28 10:25:55')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-28 10:25:55')
ORDER BY a.created DESC , a.created DESC
LIMIT 30, 5id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE v system PRIMARY Индекс не используется NULL NULL 0 0.00 const row not found 1 SIMPLE a ref idx_state,idx_catid,idx_featured_catid idx_featured_catid 1 const 70 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE ua ALL PRIMARY Индекс не используется NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uam ALL PRIMARY Индекс не используется NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 u426485.a.catid 1 100.00 Using index condition; Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 u426485.c.parent_id 1 100.00 Using where Status Duration starting 0.23 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 Opening tables 0.06 ms init 0.12 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.08 ms Creating tmp table 0.14 ms Sorting result 0.01 ms executing 0.01 ms Sending data 6.98 ms Creating sort index 0.73 ms end 0.01 ms removing tmp table 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:126 12 ContentModelFeatured->getItems() JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->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 - Время запроса: 3.13 ms После последнего запроса: 1.43 ms Память запроса: 0.025 MB Память до запроса: 2.825 MB Выбрано строк: 1
SELECT COUNT(*)
FROM DCRB_content AS a
LEFT JOIN DCRB_categories AS c
ON c.id = a.catid
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_by
LEFT JOIN DCRB_users AS uam
ON uam.id = a.modified_by
LEFT JOIN DCRB_categories as parent
ON parent.id = c.parent_id
LEFT JOIN DCRB_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-28 10:25:55')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-28 10:25:55')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE v system PRIMARY Индекс не используется NULL NULL 0 0.00 const row not found 1 SIMPLE a ref idx_state,idx_catid,idx_featured_catid idx_featured_catid 1 const 70 100.00 Using where 1 SIMPLE ua index PRIMARY PRIMARY 4 NULL 1 100.00 Using where; Using index; Using join buffer (Block Nested Loop) 1 SIMPLE uam index PRIMARY PRIMARY 4 NULL 1 100.00 Using where; Using index; Using join buffer (Block Nested Loop) 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 u426485.a.catid 1 100.00 Using index condition; Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 u426485.c.parent_id 1 100.00 Using where; Using index Status Duration starting 0.12 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 Opening tables 0.04 ms init 0.06 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.14 ms preparing 0.06 ms executing 0.01 ms Sending data 2.36 ms end 0.02 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.06 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:57 10 ContentViewFeatured->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.82 ms После последнего запроса: 2.72 ms Память запроса: 0.038 MB Память до запроса: 2.950 MB Выбрано строк: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `DCRB_categories` AS `s`
INNER JOIN `DCRB_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.access IN (1,1)
AND c.published = 1
AND s.id = 2
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 3 100.00 Using index condition; Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:102 10 ContentViewFeatured->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.52 ms После последнего запроса: 0.35 ms Память запроса: 0.037 MB Память до запроса: 2.971 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 DCRB_fields AS a
LEFT JOIN `DCRB_languages` AS l
ON l.lang_code = a.language
LEFT JOIN DCRB_users AS uc
ON uc.id=a.checked_out
LEFT JOIN DCRB_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN DCRB_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `DCRB_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 u426485.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 u426485.a.checked_out 1 100.00 NULL 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 u426485.a.access 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 u426485.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 u426485.a.group_id 1 100.00 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 u426485.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.11 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 Opening tables 0.08 ms init 0.07 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.05 ms Creating tmp table 0.08 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.54 ms Creating sort index 0.03 ms end 0.01 ms removing tmp table 0.10 ms end 0.01 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/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:102 10 ContentViewFeatured->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 После последнего запроса: 12.43 ms Память запроса: 0.028 MB Память до запроса: 3.200 MB Выбрано строк: 10
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM DCRB_modules AS m
LEFT JOIN DCRB_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN DCRB_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 <= '2021-02-28 10:25:55')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-02-28 10:25:55')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m range PRIMARY,published,newsfeeds published 5 NULL 12 100.00 Using index condition; Using where; Используется filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 u426485.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 u426485.m.module,const 1 100.00 Using index condition; Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 0.35 ms end 0.01 ms query end 0.01 ms closing tables 0.01 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/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467 13 JModuleHelper::getModuleList() JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410 12 JModuleHelper::load() JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89 11 JModuleHelper::getModules() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:168 10 JSNTplUtils->countModules() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:498 9 JSNTplTemplateHelper->_prepare() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141 8 JSNTplTemplateHelper::prepare() JROOT/templates/jsn_boot_pro/index.php:18 7 require JROOT/templates/jsn_boot_pro/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.55 ms После последнего запроса: 2.17 ms Память запроса: 0.025 MB Память до запроса: 3.321 MB Выбрано строк: 0
SELECT m.id
FROM DCRB_modules AS m
INNER JOIN DCRB_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_k2_%'
AND (mm.menuid < 0
AND mm.menuid = -101)
AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 22 100.00 Using where 1 SIMPLE mm eq_ref PRIMARY PRIMARY 8 u426485.m.id,const 1 100.00 Using index Status Duration starting 0.08 ms checking permissions 0.01 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.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720 13 JSNTplUtils->checkExt() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761 12 JSNTplUtils->checkK2() JROOT/templates/jsn_boot_pro/template_custom.php:23 11 include_once JROOT/templates/jsn_boot_pro/template_custom.php JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003 10 JSNTplTemplateHelper->_prepareHead() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742 9 JSNTplTemplateHelper->_prepare() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141 8 JSNTplTemplateHelper::prepare() JROOT/templates/jsn_boot_pro/index.php:18 7 require JROOT/templates/jsn_boot_pro/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.63 ms После последнего запроса: 0.11 ms Память запроса: 0.025 MB Память до запроса: 3.330 MB Выбрано строк: 0
SELECT m.id
FROM DCRB_modules AS m
INNER JOIN DCRB_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_k2_%'
AND (mm.menuid = 101 OR mm.menuid = 0 OR (mm.menuid < 0
AND mm.menuid != -101))
AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
GROUP BY m.idid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 22 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 u426485.m.id 1 100.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.08 ms Creating sort index 0.02 ms end 0.01 ms removing tmp table 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741 13 JSNTplUtils->checkExt() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761 12 JSNTplUtils->checkK2() JROOT/templates/jsn_boot_pro/template_custom.php:23 11 include_once JROOT/templates/jsn_boot_pro/template_custom.php JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003 10 JSNTplTemplateHelper->_prepareHead() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742 9 JSNTplTemplateHelper->_prepare() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141 8 JSNTplTemplateHelper::prepare() JROOT/templates/jsn_boot_pro/index.php:18 7 require JROOT/templates/jsn_boot_pro/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.52 ms После последнего запроса: 0.17 ms Память запроса: 0.025 MB Память до запроса: 3.337 MB Выбрано строк: 0
SELECT m.id
FROM DCRB_modules AS m
INNER JOIN DCRB_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_virtuemart_%'
AND (mm.menuid < 0
AND mm.menuid = -101)
AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 22 100.00 Using where 1 SIMPLE mm eq_ref PRIMARY PRIMARY 8 u426485.m.id,const 1 100.00 Using index Status Duration starting 0.07 ms checking permissions 0.01 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.07 ms preparing 0.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720 13 JSNTplUtils->checkExt() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:770 12 JSNTplUtils->checkVM() JROOT/templates/jsn_boot_pro/template_custom.php:28 11 include_once JROOT/templates/jsn_boot_pro/template_custom.php JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003 10 JSNTplTemplateHelper->_prepareHead() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742 9 JSNTplTemplateHelper->_prepare() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141 8 JSNTplTemplateHelper::prepare() JROOT/templates/jsn_boot_pro/index.php:18 7 require JROOT/templates/jsn_boot_pro/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.61 ms После последнего запроса: 0.11 ms Память запроса: 0.025 MB Память до запроса: 3.345 MB Выбрано строк: 0
SELECT m.id
FROM DCRB_modules AS m
INNER JOIN DCRB_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.client_id = 0
AND m.published = 1
AND m.module LIKE 'mod_virtuemart_%'
AND (mm.menuid = 101 OR mm.menuid = 0 OR (mm.menuid < 0
AND mm.menuid != -101))
AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
left", "promo", "promo-right", "content-top", "
left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
GROUP BY m.idid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 22 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 u426485.m.id 1 100.00 Using where; Using index Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Creating tmp table 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.08 ms Creating sort index 0.02 ms end 0.01 ms removing tmp table 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.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741 13 JSNTplUtils->checkExt() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:770 12 JSNTplUtils->checkVM() JROOT/templates/jsn_boot_pro/template_custom.php:28 11 include_once JROOT/templates/jsn_boot_pro/template_custom.php JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003 10 JSNTplTemplateHelper->_prepareHead() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742 9 JSNTplTemplateHelper->_prepare() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141 8 JSNTplTemplateHelper::prepare() JROOT/templates/jsn_boot_pro/index.php:18 7 require JROOT/templates/jsn_boot_pro/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.96 ms После последнего запроса: 1.04 ms Память запроса: 0.029 MB Память до запроса: 3.356 MB Выбрано строк: 112
SHOW TABLES
EXPLAIN не доступен для запроса: SHOW TABLESStatus Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 0.55 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:502 12 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:784 11 JSNTplHelper::checkMegamenuTable() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:25 10 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783 9 JSNTplTemplateMegamenu::megamenuItems() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:118 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.29 ms После последнего запроса: 0.16 ms Память запроса: 0.023 MB Память до запроса: 3.364 MB Выбрано строк: 1
SELECT COUNT(*)
FROM `DCRB_jsn_tplframework_megamenu`
WHERE style_id='17'
AND LOWER(language_code)='ru-ru'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:47 10 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783 9 JSNTplTemplateMegamenu::megamenuItems() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:118 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.26 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 3.371 MB Выбрано строк: 1
SELECT *
FROM `DCRB_jsn_tplframework_megamenu`
WHERE style_id='17'
AND LOWER(language_code)='*'
ORDER BY modified DESCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_jsn_tplframework_megamenu system NULL Индекс не используется NULL NULL 1 100.00 NULL Status Duration starting 0.03 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.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:68 10 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783 9 JSNTplTemplateMegamenu::megamenuItems() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:118 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.80 ms После последнего запроса: 2.86 ms Память запроса: 0.029 MB Память до запроса: 3.426 MB Выбрано строк: 112
SHOW TABLES
EXPLAIN не доступен для запроса: SHOW TABLESStatus Duration starting 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 0.43 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:502 13 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:784 12 JSNTplHelper::checkMegamenuTable() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:25 11 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:872 10 JSNTplTemplateMegamenu::getMenuType() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:146 9 JSNTplTemplateMegamenu::getMenuList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.31 ms После последнего запроса: 0.15 ms Память запроса: 0.023 MB Память до запроса: 3.435 MB Выбрано строк: 1
SELECT COUNT(*)
FROM `DCRB_jsn_tplframework_megamenu`
WHERE style_id='17'
AND LOWER(language_code)='ru-ru'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 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.02 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:47 11 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:872 10 JSNTplTemplateMegamenu::getMenuType() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:146 9 JSNTplTemplateMegamenu::getMenuList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.33 ms После последнего запроса: 0.10 ms Память запроса: 0.025 MB Память до запроса: 3.442 MB Выбрано строк: 1
SELECT *
FROM `DCRB_jsn_tplframework_megamenu`
WHERE style_id='17'
AND LOWER(language_code)='*'
ORDER BY modified DESCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_jsn_tplframework_megamenu system NULL Индекс не используется NULL NULL 1 100.00 NULL Status Duration starting 0.04 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.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:68 11 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:872 10 JSNTplTemplateMegamenu::getMenuType() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:146 9 JSNTplTemplateMegamenu::getMenuList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.81 ms После последнего запроса: 0.09 ms Память запроса: 0.029 MB Память до запроса: 3.445 MB Выбрано строк: 112
SHOW TABLES
EXPLAIN не доступен для запроса: SHOW TABLESStatus Duration starting 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 0.44 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:502 13 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:784 12 JSNTplHelper::checkMegamenuTable() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:25 11 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783 10 JSNTplTemplateMegamenu::megamenuItems() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:147 9 JSNTplTemplateMegamenu::getMenuList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.31 ms После последнего запроса: 0.17 ms Память запроса: 0.023 MB Память до запроса: 3.454 MB Выбрано строк: 1
SELECT COUNT(*)
FROM `DCRB_jsn_tplframework_megamenu`
WHERE style_id='17'
AND LOWER(language_code)='ru-ru'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 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.02 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:47 11 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783 10 JSNTplTemplateMegamenu::megamenuItems() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:147 9 JSNTplTemplateMegamenu::getMenuList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.33 ms После последнего запроса: 0.10 ms Память запроса: 0.027 MB Память до запроса: 3.468 MB Выбрано строк: 1
SELECT *
FROM `DCRB_jsn_tplframework_megamenu`
WHERE style_id='17'
AND LOWER(language_code)='*'
ORDER BY modified DESCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_jsn_tplframework_megamenu system NULL Индекс не используется NULL NULL 1 100.00 NULL Status Duration starting 0.04 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.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/jsntplframework/libraries/joomlashine/megamenu/helpers/megamenu.php:68 11 JSNTplMMHelperMegamenu::getMegamenuItemsByStyleId() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:783 10 JSNTplTemplateMegamenu::megamenuItems() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:147 9 JSNTplTemplateMegamenu::getMenuList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/megamenu.php:120 8 JSNTplTemplateMegamenu::render() JROOT/templates/jsn_boot_pro/index.php:201 7 require JROOT/templates/jsn_boot_pro/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.47 ms После последнего запроса: 7.41 ms Память запроса: 0.034 MB Память до запроса: 3.655 MB Выбрано строк: 6
SELECT *,DCRB_huge_itslider_images.name as imgname,DCRB_huge_itslider_sliders.description as pousetimeDescription
FROM DCRB_huge_itslider_sliders,DCRB_huge_itslider_images
WHERE DCRB_huge_itslider_sliders.id =2
AND DCRB_huge_itslider_sliders.id = DCRB_huge_itslider_images.slider_id
ORDER BY DCRB_huge_itslider_images.ordering descid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_huge_itslider_sliders const PRIMARY,id PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE DCRB_huge_itslider_images ALL NULL Индекс не используется NULL NULL 19 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_slider/helpers/helper.php:26 12 SlidersHelper->get_data() JROOT/components/com_slider/helpers/helper.php:48 11 SlidersHelper->render_html() JROOT/modules/mod_slider/mod_slider.php:23 10 include JROOT/modules/mod_slider/mod_slider.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::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.34 ms После последнего запроса: 0.10 ms Память запроса: 0.029 MB Память до запроса: 3.681 MB Выбрано строк: 37
SELECT *
FROM DCRB_huge_itslider_paramsid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_huge_itslider_params ALL NULL Индекс не используется NULL NULL 37 100.00 NULL Status Duration starting 0.02 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.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_slider/helpers/helper.php:35 12 SlidersHelper->get_dataParams() JROOT/components/com_slider/helpers/helper.php:49 11 SlidersHelper->render_html() JROOT/modules/mod_slider/mod_slider.php:23 10 include JROOT/modules/mod_slider/mod_slider.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::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.37 ms После последнего запроса: 1.38 ms Память запроса: 0.038 MB Память до запроса: 3.770 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 DCRB_fields AS a
LEFT JOIN `DCRB_languages` AS l
ON l.lang_code = a.language
LEFT JOIN DCRB_users AS uc
ON uc.id=a.checked_out
LEFT JOIN DCRB_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN DCRB_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 u426485.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 u426485.a.checked_out 1 100.00 NULL 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 u426485.a.access 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 u426485.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 u426485.a.group_id 1 100.00 Using where Status Duration starting 0.11 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 Opening tables 0.03 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.15 ms preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.50 ms Creating sort index 0.02 ms end 0.01 ms removing tmp table 0.09 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 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/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::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.46 ms После последнего запроса: 0.64 ms Память запроса: 0.033 MB Память до запроса: 3.800 MB Выбрано строк: 4
SELECT *,DCRB_huge_itslider_images.name as imgname,DCRB_huge_itslider_sliders.description as pousetimeDescription
FROM DCRB_huge_itslider_sliders,DCRB_huge_itslider_images
WHERE DCRB_huge_itslider_sliders.id =3
AND DCRB_huge_itslider_sliders.id = DCRB_huge_itslider_images.slider_id
ORDER BY DCRB_huge_itslider_images.ordering descid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_huge_itslider_sliders const PRIMARY,id PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE DCRB_huge_itslider_images ALL NULL Индекс не используется NULL NULL 19 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_slider/helpers/helper.php:26 12 SlidersHelper->get_data() JROOT/components/com_slider/helpers/helper.php:48 11 SlidersHelper->render_html() JROOT/modules/mod_slider/mod_slider.php:23 10 include JROOT/modules/mod_slider/mod_slider.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::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.34 ms После последнего запроса: 0.10 ms Память запроса: 0.029 MB Память до запроса: 3.819 MB Выбрано строк: 37
SELECT *
FROM DCRB_huge_itslider_paramsid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_huge_itslider_params ALL NULL Индекс не используется NULL NULL 37 100.00 NULL Status Duration starting 0.03 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.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_slider/helpers/helper.php:35 12 SlidersHelper->get_dataParams() JROOT/components/com_slider/helpers/helper.php:49 11 SlidersHelper->render_html() JROOT/modules/mod_slider/mod_slider.php:23 10 include JROOT/modules/mod_slider/mod_slider.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::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.47 ms После последнего запроса: 0.65 ms Память запроса: 0.036 MB Память до запроса: 3.917 MB Выбрано строк: 9
SELECT *,DCRB_huge_itslider_images.name as imgname,DCRB_huge_itslider_sliders.description as pousetimeDescription
FROM DCRB_huge_itslider_sliders,DCRB_huge_itslider_images
WHERE DCRB_huge_itslider_sliders.id =1
AND DCRB_huge_itslider_sliders.id = DCRB_huge_itslider_images.slider_id
ORDER BY DCRB_huge_itslider_images.ordering descid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_huge_itslider_sliders const PRIMARY,id PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE DCRB_huge_itslider_images ALL NULL Индекс не используется NULL NULL 19 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 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.04 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_slider/helpers/helper.php:26 12 SlidersHelper->get_data() JROOT/components/com_slider/helpers/helper.php:48 11 SlidersHelper->render_html() JROOT/modules/mod_slider/mod_slider.php:23 10 include JROOT/modules/mod_slider/mod_slider.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::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.34 ms После последнего запроса: 0.12 ms Память запроса: 0.029 MB Память до запроса: 3.952 MB Выбрано строк: 37
SELECT *
FROM DCRB_huge_itslider_paramsid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_huge_itslider_params ALL NULL Индекс не используется NULL NULL 37 100.00 NULL 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 preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_slider/helpers/helper.php:35 12 SlidersHelper->get_dataParams() JROOT/components/com_slider/helpers/helper.php:49 11 SlidersHelper->render_html() JROOT/modules/mod_slider/mod_slider.php:23 10 include JROOT/modules/mod_slider/mod_slider.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::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.43 ms После последнего запроса: 3.31 ms Память запроса: 0.024 MB Память до запроса: 4.132 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 183 OR id = 184id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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.33 ms После последнего запроса: 0.22 ms Память запроса: 0.024 MB Память до запроса: 4.139 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 183 OR id = 185id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition Status Duration starting 0.03 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.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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.32 ms После последнего запроса: 0.21 ms Память запроса: 0.024 MB Память до запроса: 4.146 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 183 OR id = 186id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition 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.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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.31 ms После последнего запроса: 0.18 ms Память запроса: 0.024 MB Память до запроса: 4.153 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 183 OR id = 232id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition 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.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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.32 ms После последнего запроса: 0.34 ms Память запроса: 0.024 MB Память до запроса: 4.160 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 187 OR id = 188id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition 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.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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.32 ms После последнего запроса: 1.02 ms Память запроса: 0.024 MB Память до запроса: 4.169 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 275 OR id = 278id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition 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.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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.31 ms После последнего запроса: 0.17 ms Память запроса: 0.024 MB Память до запроса: 4.176 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 275 OR id = 277id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition 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.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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.31 ms После последнего запроса: 0.17 ms Память запроса: 0.024 MB Память до запроса: 4.183 MB Выбрано строк: 2
SELECT lft, rgt
FROM DCRB_menu
WHERE id = 275 OR id = 279id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE DCRB_menu range PRIMARY PRIMARY 4 NULL 2 100.00 Using index condition 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.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594 12 JSNTplUtils->isLastMenu() JROOT/templates/jsn_boot_pro/html/mod_menu/default.php:76 11 require JROOT/templates/jsn_boot_pro/html/mod_menu/default.php JROOT/modules/mod_menu/mod_menu.php:27 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195 9 JModuleHelper::renderModule() JROOT/libraries/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
27 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
8 × SELECT lft, rgt
FROM DCRB_menu4 × SELECT m.id
FROM DCRB_modules AS m
INNER JOIN DCRB_modules_menu AS mm
ON mm.moduleid = m.id3 × SELECT *
FROM DCRB_huge_itslider_param3 × SELECT *,DCRB_huge_itslider_images.name as imgname,DCRB_huge_itslider_sliders.description as pousetimeDescription
FROM DCRB_huge_itslider_sliders,DCRB_huge_itslider_images3 × SELECT *
FROM `DCRB_jsn_tplframework_megamenu`3 × SELECT COUNT(*)
FROM `DCRB_jsn_tplframework_megamenu`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `DCRB_extensions`1 × SELECT COUNT(*)
FROM DCRB_content AS a
LEFT JOIN DCRB_categories AS c
ON c.id = a.catid
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_by
LEFT JOIN DCRB_users AS uam
ON uam.id = a.modified_by
LEFT JOIN DCRB_categories as parent
ON parent.id = c.parent_id
LEFT JOIN DCRB_content_rating AS v
ON a.id = v.content_id1 × 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 DCRB_fields AS a
LEFT JOIN `DCRB_languages` AS l
ON l.lang_code = a.language
LEFT JOIN DCRB_users AS uc
ON uc.id=a.checked_out
LEFT JOIN DCRB_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN DCRB_fields_groups AS g
ON g.id = a.group_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM DCRB_modules AS m
LEFT JOIN DCRB_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN DCRB_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 DCRB_fields AS a
LEFT JOIN `DCRB_languages` AS l
ON l.lang_code = a.language
LEFT JOIN DCRB_users AS uc
ON uc.id=a.checked_out
LEFT JOIN DCRB_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN DCRB_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `DCRB_fields_categories` AS fc
ON fc.field_id = a.id1 × 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 `DCRB_categories` AS `s`
INNER JOIN `DCRB_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `data`
FROM `DCRB_session`1 × SELECT `session_id`
FROM `DCRB_session`1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `DCRB_assets`1 × SELECT *
FROM DCRB_languages1 × SELECT COUNT(*)
FROM DCRB_extensions1 × SELECT manifest_cache
FROM DCRB_extensions1 × SELECT id, home, template, s.params
FROM DCRB_template_styles as s
LEFT JOIN DCRB_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 DCRB_menu AS m
LEFT JOIN DCRB_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM DCRB_extensions1 × SELECT b.id
FROM DCRB_usergroups AS a
LEFT JOIN DCRB_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `DCRB_viewlevels1 × 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 DCRB_content AS a
LEFT JOIN DCRB_categories AS c
ON c.id = a.catid
LEFT JOIN DCRB_users AS ua
ON ua.id = a.created_by
LEFT JOIN DCRB_users AS uam
ON uam.id = a.modified_by
LEFT JOIN DCRB_categories as parent
ON parent.id = c.parent_id
LEFT JOIN DCRB_content_rating AS v
ON a.id = v.content_id
Прочие SQL-запросы:
3 × SHOW TABLE
1 × INSERT INTO `DCRB_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3965656265616635393336613737393037313737303832613835636363303164', 1, 1614507955, 0, '', 01 × UPDATE `DCRB_extensions`
SET `params` = '{\"mediaversion\":\"7a04c46331adb93e59375d73c30c79ea\"}'