Версия для слабовидящих
Решаем вместе
Есть предложения по улучшению социальной сферы, повышению эффективности служб занятости или другие вопросы?
Напишите об этом — Минтруд поможет с решением!
Новости
- Просмотров: 463
#МЫВМЕСТЕ – идея, объединившая страну в период пандемии COVID-19
Акцию #МыВместе возобновили из-за ухудшения ситуации с COVID-19.
Штабы общероссийской акции #МыВместе оказывают помощь в доставке еды и лекарств лицам из групп риска.
Если вам нужна помощь волонтеров, вы можете обратиться на горячую линию 8-800-200-34-11.
Если ты хочешь помогать, присоединяйся к команде #МыВместе, регистрируйся http://dobro.ru/event/10103325
Приказ Минздрава России от 21.03.2014 N 125н (ред. от 24.04.2019) "Об утверждении национального календаря профилактических прививок и календаря профилактических прививок по эпидемическим показаниям"
Приказ Министерства здравоохранения Чеченской Республики от 27.12.2018 года № 338 «Об утверждении плана проведения диспансеризации определенных групп взрослого населения в 2019 году» "
Распоряжение Правительства РФ № 1391-р от 27.06.2019 «О проведении Всероссийской диспансеризации взрослого населения»"
Фотогалерея
1. Для участия необходимо перейти по ссылке;
2. В зависимости от того, какой тест Вам необходим, нажать на кнопку «Трек для школьников» или «Трек для взрослых»;
3. После этого Вам необходимо пройти регистрацию на портале Академия доступной среды, заполнив все необходимые поля и подтвердив свой E-mail;
4. Зарегистрировавшись, Вы сможете сами установить логин и пароль для Вашего Личного кабинета, в котором 3 декабря за час до начала теста, который Вы выбрали, появится кнопка доступа «Трек для школьников», или «Трек для взрослых». Выберите необходимый тест и можете начать прохождение! Тест можно будет пройти с 10 часов по московскому времени.
ГБУ «Комплексный центр социального обслуживания населения Урус-Мартановского района»
 |
8(965) 954-38-13 |
 |
|
 |
MINTRUD.CHR |
| |
instagram kcson-um |
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1714086768,
"last": 1714086768,
"now": 1714086768
},
"client": {
"forwarded": "18.222.115.120"
}
},
"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": [
"9"
],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Время
Память
Время: 33.10 ms / 33.10 ms Память: 0.105 MB / 0.22 MB Application: afterLoad
Время: 124.55 ms / 157.65 ms Память: 1.099 MB / 1.32 MB Application: afterInitialise
Время: 18.70 ms / 176.35 ms Память: 0.319 MB / 1.63 MB Application: afterRoute
Время: 9.57 ms / 185.92 ms Память: 0.092 MB / 1.73 MB Application: beforeRenderComponent com_content
Время: 62.64 ms / 248.57 ms Память: 0.490 MB / 2.22 MB Application: afterRenderComponent com_content
Время: 9.33 ms / 257.90 ms Память: 0.015 MB / 2.23 MB Application: afterDispatch
Время: 8.45 ms / 266.34 ms Память: 0.099 MB / 2.33 MB Application: beforeRenderModule mod_menu (Футер меню)
Время: 13.86 ms / 280.21 ms Память: 0.091 MB / 2.42 MB Application: afterRenderModule mod_menu (Футер меню)
Время: 0.25 ms / 280.45 ms Память: 0.000 MB / 2.42 MB Application: beforeRenderModule mod_custom (Телефон)
Время: 2.31 ms / 282.76 ms Память: 0.006 MB / 2.42 MB Application: afterRenderModule mod_custom (Телефон)
Время: 2.59 ms / 285.36 ms Память: 0.005 MB / 2.43 MB Application: beforeRenderModule mod_banners (Хостинг для joomla)
Время: 26.93 ms / 312.29 ms Память: 0.251 MB / 2.68 MB Application: afterRenderModule mod_banners (Хостинг для joomla)
Время: 0.25 ms / 312.54 ms Память: 0.000 MB / 2.67 MB Application: beforeRenderModule mod_scrolltop (Кнопка наверх )
Время: 197.77 ms / 510.31 ms Память: 0.015 MB / 2.69 MB Application: afterRenderModule mod_scrolltop (Кнопка наверх )
Время: 0.21 ms / 510.52 ms Память: 0.000 MB / 2.68 MB Application: beforeRenderModule mod_custom (Министр)
Время: 0.69 ms / 511.21 ms Память: 0.004 MB / 2.69 MB Application: afterRenderModule mod_custom (Министр)
Время: 0.13 ms / 511.34 ms Память: 0.000 MB / 2.68 MB Application: beforeRenderModule mod_custom (Важно прививки)
Время: 0.64 ms / 511.97 ms Память: 0.004 MB / 2.69 MB Application: afterRenderModule mod_custom (Важно прививки)
Время: 0.19 ms / 512.16 ms Память: 0.000 MB / 2.69 MB Application: beforeRenderModule mod_carousel_banner (Carousel Banner)
Время: 12.11 ms / 524.27 ms Память: 0.119 MB / 2.81 MB Application: afterRenderModule mod_carousel_banner (Carousel Banner)
Время: 0.16 ms / 524.43 ms Память: 0.000 MB / 2.79 MB Application: beforeRenderModule mod_custom (Эмблема к 70 летию победы)
Время: 0.65 ms / 525.09 ms Память: 0.004 MB / 2.80 MB Application: afterRenderModule mod_custom (Эмблема к 70 летию победы)
Время: 0.12 ms / 525.21 ms Память: 0.000 MB / 2.79 MB Application: beforeRenderModule mod_custom (1)
Время: 0.62 ms / 525.83 ms Память: 0.004 MB / 2.80 MB Application: afterRenderModule mod_custom (1)
Время: 0.15 ms / 525.98 ms Память: 0.000 MB / 2.80 MB Application: beforeRenderModule mod_banners (МЫВМЕСТЕ)
Время: 6.16 ms / 532.14 ms Память: 0.083 MB / 2.88 MB Application: afterRenderModule mod_banners (МЫВМЕСТЕ)
Время: 0.31 ms / 532.45 ms Память: 0.000 MB / 2.88 MB Application: beforeRenderModule mod_ariimageslider (Фотогалерея)
Время: 25.41 ms / 557.86 ms Память: 0.118 MB / 3.00 MB Application: afterRenderModule mod_ariimageslider (Фотогалерея)
Время: 0.28 ms / 558.14 ms Память: 0.000 MB / 2.97 MB Application: beforeRenderModule mod_banners (Тотальный тест)
Время: 6.76 ms / 564.90 ms Память: 0.090 MB / 3.06 MB Application: afterRenderModule mod_banners (Тотальный тест)
Время: 0.60 ms / 565.49 ms Память: 0.002 MB / 3.07 MB Application: beforeRenderModule mod_flexi_customcode (Обратная связь ПОС)
Время: 99.34 ms / 664.83 ms Память: 0.042 MB / 3.11 MB Application: afterRenderModule mod_flexi_customcode (Обратная связь ПОС)
Время: 0.30 ms / 665.13 ms Память: 0.000 MB / 3.09 MB Application: beforeRenderModule mod_djimageslider (Слайдер)
Время: 5.91 ms / 671.05 ms Память: 0.040 MB / 3.13 MB Application: afterRenderModule mod_djimageslider (Слайдер)
Время: 0.29 ms / 671.34 ms Память: 0.000 MB / 3.12 MB Application: beforeRenderModule mod_menu (Главное меню)
Время: 13.53 ms / 684.87 ms Память: 0.054 MB / 3.17 MB Application: afterRenderModule mod_menu (Главное меню)
Время: 0.31 ms / 685.18 ms Память: 0.000 MB / 3.17 MB Application: beforeRenderModule mod_search (Поиск)
Время: 4.29 ms / 689.48 ms Память: 0.019 MB / 3.19 MB Application: afterRenderModule mod_search (Поиск)
Время: 0.19 ms / 689.67 ms Память: 0.000 MB / 3.18 MB Application: beforeRenderModule mod_wonder_css (Версия для слабовидящих )
Время: 2.92 ms / 692.59 ms Память: 0.010 MB / 3.19 MB Application: afterRenderModule mod_wonder_css (Версия для слабовидящих )
Время: 14.72 ms / 707.31 ms Память: 0.128 MB / 3.32 MB Application: afterRender
Всего SQL-запросов: 55.90 ms
3.95 MB (4,139,676 Байт)
68 SQL-запросов зафиксировано 55.90 ms
20 повторяющийся запрос!
- Время запроса: 8.32 ms Память запроса: 0.011 MB Память до запроса: 0.499 MB Выбрано строк: 0
SELECT `data`
FROM `ko2bc_session`
WHERE `session_id` = '82o356ear8c87bjbt53q4mmpd3'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_session const PRIMARY PRIMARY 766 const 1 Status Duration starting 0.04 ms Waiting for query cache lock 0.01 ms checking query cache for query 1.15 ms checking permissions 0.02 ms Opening tables 0.66 ms After opening tables 1.18 ms System lock 0.71 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.88 ms init 0.46 ms optimizing 0.03 ms statistics 2.30 ms preparing 0.01 ms executing 0.57 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:258 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:748 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Время запроса: 0.47 ms После последнего запроса: 3.55 ms Память запроса: 0.007 MB Память до запроса: 0.536 MB Выбрано строк: 0Повторяющиеся запросы: #27
SELECT `session_id`
FROM `ko2bc_session`
WHERE `session_id` = '82o356ear8c87bjbt53q4mmpd3'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.03 ms init 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Время запроса: 3.46 ms После последнего запроса: 0.26 ms Память запроса: 0.005 MB Память до запроса: 0.543 MB
INSERT INTO `ko2bc_session` (`session_id`, `client_id`, `time`)
VALUES ('82o356ear8c87bjbt53q4mmpd3', 0, '1714086768')EXPLAIN не доступен для запроса: INSERT INTO `ko2bc_session` (`session_id`, `client_id`, `time`) VALUES ('82o356ear8c87bjbt53q4mmpd3', 0, '1714086768')Status Duration starting 0.06 ms checking permissions 0.45 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.20 ms update 1.06 ms Waiting for query cache lock 0.01 ms update 0.02 ms end 0.01 ms query end 1.49 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:208 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Время запроса: 0.19 ms После последнего запроса: 3.78 ms Память запроса: 0.011 MB Память до запроса: 0.596 MB Выбрано строк: 39
SELECT extension_id AS id, element AS "option", params, enabled
FROM ko2bc_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_extensions ref extension extension 82 const 39 Using index condition Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:584 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.12 ms После последнего запроса: 1.67 ms Память запроса: 0.008 MB Память до запроса: 0.630 MB Выбрано строк: 2
SELECT b.id
FROM ko2bc_usergroups AS a
LEFT JOIN ko2bc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:354 8 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:423 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.12 ms После последнего запроса: 0.19 ms Память запроса: 0.008 MB Память до запроса: 0.641 MB Выбрано строк: 5
SELECT id, rules
FROM `ko2bc_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_viewlevels ALL NULL Индекс не используется NULL NULL 5 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1497 8 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:440 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.14 ms После последнего запроса: 0.24 ms Память запроса: 0.007 MB Память до запроса: 0.652 MB Выбрано строк: 53
SELECT folder AS type, element AS name, params
FROM ko2bc_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_extensions ref extension extension 82 const 71 Using index condition; Using where; Используется filesort Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.27 ms После последнего запроса: 28.53 ms Память запроса: 0.011 MB Память до запроса: 0.920 MB Выбрано строк: 1Повторяющиеся запросы: #9
SELECT template
FROM ko2bc_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_home Индекс не используется NULL NULL 6 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:96 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:54 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.17 ms После последнего запроса: 0.23 ms Память запроса: 0.012 MB Память до запроса: 0.931 MB Выбрано строк: 1Повторяющиеся запросы: #8
SELECT template
FROM ko2bc_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_home Индекс не используется NULL NULL 6 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:96 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:54 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 9.09 ms Память запроса: 0.009 MB Память до запроса: 1.069 MB Выбрано строк: 2
SELECT extension, file, type
FROM ko2bc_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_rokcommon_configs ALL NULL Индекс не используется NULL NULL 2 Используется filesort Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:132 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:76 7 plgSystemRokCommon->__construct() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:662 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:663 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.33 ms После последнего запроса: 19.84 ms Память запроса: 0.017 MB Память до запроса: 1.349 MB Выбрано строк: 33
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 ko2bc_menu AS m
LEFT JOIN ko2bc_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 Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 45 Using index condition; Using where; Используется filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 urus.m.component_id 1 Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.03 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:86 14 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 13 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 12 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:133 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:435 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:57 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:196 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:531 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1097 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.27 ms После последнего запроса: 15.12 ms Память запроса: 0.014 MB Память до запроса: 1.622 MB Выбрано строк: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM ko2bc_categories as c
LEFT JOIN (SELECT cat.id as id
FROM ko2bc_categories AS cat JOIN ko2bc_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN ko2bc_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND badcats.id is null
AND s.id=172
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 19 Using index condition; Using temporary; Используется filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 36 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.03 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 11 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 10 JCategories->get() JROOT/components/com_content/router.php:351 9 ContentRouter->parse() JROOT/libraries/cms/router/site.php:395 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:479 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:234 6 JRouter->parse() JROOT/libraries/cms/router/site.php:118 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1098 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.52 ms После последнего запроса: 0.25 ms Память запроса: 0.009 MB Память до запроса: 1.629 MB Выбрано строк: 1
SELECT `alias`,`catid`
FROM `ko2bc_content`
WHERE `id` = 172id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_content const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.04 ms init 0.03 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.02 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.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 10 JDatabaseDriver->loadObject() JROOT/components/com_content/router.php:367 9 ContentRouter->parse() JROOT/libraries/cms/router/site.php:395 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:479 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:234 6 JRouter->parse() JROOT/libraries/cms/router/site.php:118 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1098 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.15 ms После последнего запроса: 1.05 ms Память запроса: 0.011 MB Память до запроса: 1.656 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM ko2bc_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 13 JDatabaseDriver->loadObject() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 10 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:991 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.20 ms После последнего запроса: 0.48 ms Память запроса: 0.007 MB Память до запроса: 1.651 MB
UPDATE `ko2bc_extensions`
SET `params` = '{\"mediaversion\":\"aefeae3cee8d61fd55ff65dc443bc1df\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `ko2bc_extensions` SET `params` = '{\"mediaversion\":\"aefeae3cee8d61fd55ff65dc443bc1df\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.68 ms Updating 0.10 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.07 ms query end 0.07 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:991 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.16 ms После последнего запроса: 2.13 ms Память запроса: 0.008 MB Память до запроса: 1.704 MB Выбрано строк: 2
SELECT *
FROM ko2bc_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_languages ALL NULL Индекс не используется NULL NULL 2 Using where; Используется filesort Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:329 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.72 ms После последнего запроса: 1.37 ms Память запроса: 0.006 MB Память до запроса: 1.718 MB Выбрано строк: 3
SELECT id, home, template, s.params
FROM ko2bc_template_styles as s
LEFT JOIN ko2bc_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 Extra 1 SIMPLE s ALL idx_template Индекс не используется NULL NULL 6 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 urus.s.template,const 1 Using index condition; Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.04 ms init 0.03 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.05 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.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 4 JApplicationSite->getTemplate() JROOT/libraries/cms/application/site.php:165 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.21 ms После последнего запроса: 10.96 ms Память запроса: 0.012 MB Память до запроса: 1.836 MB Выбрано строк: 1
SELECT a.rules
FROM ko2bc_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.02 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 14 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 13 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:384 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:439 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.16 ms После последнего запроса: 1.25 ms Память запроса: 0.012 MB Память до запроса: 1.853 MB Выбрано строк: 2
SELECT b.rules
FROM ko2bc_assets AS a
LEFT JOIN ko2bc_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Используется filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 16 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 15 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 14 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 13 JAccess::check() JROOT/libraries/joomla/user/user.php:393 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:439 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:262 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 7.17 ms После последнего запроса: 1.00 ms Память запроса: 0.015 MB Память до запроса: 1.880 MB Выбрано строк: 30
SHOW FULL COLUMNS
FROM `ko2bc_content`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `ko2bc_content`Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 3.64 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms checking permissions 0.77 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 1.47 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms closing tables 0.01 ms executing 0.01 ms Sending data 0.47 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.13 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 12 JTable->__construct() JROOT/libraries/legacy/table/content.php:31 11 JTableContent->__construct() JROOT/libraries/joomla/table/table.php:305 10 JTable::getInstance() JROOT/components/com_content/models/article.php:264 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.61 ms После последнего запроса: 4.56 ms Память запроса: 0.019 MB Память до запроса: 1.960 MB Выбрано строк: 1
SELECT *
FROM ko2bc_content
WHERE `id` = '172'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_content const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.03 ms init 0.05 ms optimizing 0.02 ms statistics 0.07 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.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1456 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:728 10 JTable->load() JROOT/components/com_content/models/article.php:265 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.03 ms После последнего запроса: 0.43 ms Память запроса: 0.008 MB Память до запроса: 1.977 MB
UPDATE ko2bc_content
SET `hits` = (`hits` + 1)
WHERE `id` = '172'EXPLAIN не доступен для запроса: UPDATE ko2bc_content SET `hits` = (`hits` + 1) WHERE `id` = '172'Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.15 ms Updating 0.08 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.37 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.16 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/table/table.php:1249 10 JTable->hit() JROOT/components/com_content/models/article.php:266 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 2.07 ms После последнего запроса: 2.73 ms Память запроса: 0.017 MB Память до запроса: 2.016 MB Выбрано строк: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM ko2bc_content AS a
LEFT JOIN ko2bc_categories AS c
on c.id = a.catid
LEFT JOIN ko2bc_users AS u
on u.id = a.created_by
LEFT JOIN ko2bc_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ko2bc_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ko2bc_categories AS cat JOIN ko2bc_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 172
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 23:12:48')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 23:12:48')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a const PRIMARY,idx_state PRIMARY 4 const 1 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 1 PRIMARY u const PRIMARY PRIMARY 4 const 1 1 PRIMARY parent const PRIMARY PRIMARY 4 const 1 1 PRIMARY v const PRIMARY PRIMARY 4 const 0 unique row not found 1 PRIMARY <derived2> ref key0 key0 5 const 10 Using where 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 19 Using index condition; Using temporary; Используется filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 36 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.27 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.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.02 ms Waiting for query cache lock 0.01 ms After table lock 0.05 ms init 0.13 ms optimizing 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.08 ms statistics 0.16 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms executing 0.01 ms Creating tmp table 0.02 ms Copying to tmp table 0.36 ms Sorting result 0.02 ms Sending data 0.02 ms removing tmp table 0.01 ms Sending data 0.03 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.02 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.29 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1653 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:159 12 ContentModelArticle->getItem() JROOT/libraries/legacy/view/legacy.php:401 11 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.21 ms После последнего запроса: 2.56 ms Память запроса: 0.016 MB Память до запроса: 2.064 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 ko2bc_categories as c
LEFT JOIN (SELECT cat.id as id
FROM ko2bc_categories AS cat JOIN ko2bc_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN ko2bc_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND badcats.id is null
AND s.id=28
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using temporary; Используется filesort 1 PRIMARY c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 5 Using index condition; Using where 1 PRIMARY <derived2> ref key0 key0 5 urus.c.id 10 Using where 2 DERIVED parent ref cat_idx,idx_left_right cat_idx 202 const 19 Using index condition; Using temporary; Используется filesort 2 DERIVED cat index idx_left_right idx_left_right 8 NULL 36 Using where; Using index; Using join buffer (flat, BNL join) Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.02 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 14 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 13 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 12 JCategories->get() JROOT/components/com_content/helpers/route.php:44 11 ContentHelperRoute::getArticleRoute() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.19 ms После последнего запроса: 1.68 ms Память запроса: 0.015 MB Память до запроса: 2.088 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `ko2bc_contentitem_tag_map` AS m
INNER JOIN `ko2bc_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 172
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ALL PRIMARY,tag_idx,idx_access Индекс не используется NULL NULL 12 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 urus.t.id 6 Using index condition; Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 11 JHelperTags->getItemTags() JROOT/components/com_content/views/article/view.html.php:156 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:690 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:728 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:38 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.99 ms После последнего запроса: 39.18 ms Память запроса: 0.023 MB Память до запроса: 2.256 MB Выбрано строк: 31
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ko2bc_modules AS m
LEFT JOIN ko2bc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ko2bc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-25 23:12:48')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 23:12:48')
AND m.access IN (1,1,5)
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 Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 25 Using index condition; Using where; Используется filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 urus.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 urus.m.module,const 1 Using index condition; Using where Status Duration starting 0.03 ms Waiting for query cache lock 0.02 ms checking query cache for query 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.04 ms init 0.06 ms optimizing 0.05 ms statistics 0.12 ms preparing 0.07 ms executing 0.01 ms Sorting result 0.23 ms Sending data 0.60 ms Waiting for query cache lock 0.01 ms Sending data 0.19 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/module/helper.php:409 11 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:352 10 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 9 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:514 8 JDocumentHtml->countModules() JROOT/templates/rsmetro/index.php:21 7 require JROOT/templates/rsmetro/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:635 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1054 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.57 ms После последнего запроса: 13.45 ms Память запроса: 0.018 MB Память до запроса: 2.405 MB Выбрано строк: 1Повторяющиеся запросы: #2
SELECT `session_id`
FROM `ko2bc_session`
WHERE `session_id` = '82o356ear8c87bjbt53q4mmpd3'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.03 ms init 0.03 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 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.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 23 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 22 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 21 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 20 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 19 JApplicationSite->__construct() JROOT/components/com_rokgallery/router.php:35 18 RokgalleryBuildRoute() JROOT/libraries/cms/component/router/legacy.php:68 17 JComponentRouterLegacy->build() JROOT/libraries/cms/router/site.php:483 16 JRouterSite->buildSefRoute() JROOT/libraries/cms/router/site.php:452 15 JRouterSite->_buildSefRoute() JROOT/libraries/cms/router/router.php:280 14 JRouter->build() JROOT/libraries/cms/router/site.php:134 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_menu/helper.php:118 11 ModMenuHelper::getList() JROOT/modules/mod_menu/mod_menu.php:15 10 include JROOT/modules/mod_menu/mod_menu.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.58 ms После последнего запроса: 13.17 ms Память запроса: 0.016 MB Память до запроса: 2.460 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-25 23:12:48' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.03 ms init 0.06 ms optimizing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.14 ms После последнего запроса: 2.53 ms Память запроса: 0.014 MB Память до запроса: 2.504 MB Выбрано строк: 1
SELECT COUNT(*)
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ALL idx_state Индекс не используется NULL NULL 15 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.52 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.06 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.04 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.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.92 ms После последнего запроса: 0.24 ms Память запроса: 0.014 MB Память до запроса: 2.514 MB Выбрано строк: 4
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 Используется filesort 1 SIMPLE a range idx_state idx_state 1 NULL 13 Using index condition; Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.28 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.12 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.54 ms Память запроса: 0.009 MB Память до запроса: 2.535 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 2EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 2Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.41 ms После последнего запроса: 0.23 ms Память запроса: 0.010 MB Память до запроса: 2.545 MB Выбрано строк: 1Повторяющиеся запросы: #33
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:277 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.17 ms После последнего запроса: 0.18 ms Память запроса: 0.011 MB Память до запроса: 2.555 MB Выбрано строк: 1Повторяющиеся запросы: #32
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/components/com_banners/models/banners.php:284 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 0.24 ms Память запроса: 0.009 MB Память до запроса: 2.566 MB
UPDATE ko2bc_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=2
AND track_date='2024-04-25 23'EXPLAIN не доступен для запроса: UPDATE ko2bc_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=2 AND track_date='2024-04-25 23'Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.11 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:314 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 0.20 ms Память запроса: 0.009 MB Память до запроса: 2.575 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 3EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 3Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms Updating 0.05 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.22 ms Память запроса: 0.010 MB Память до запроса: 2.585 MB Выбрано строк: 1Повторяющиеся запросы: #37
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=3
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:277 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.14 ms После последнего запроса: 0.17 ms Память запроса: 0.011 MB Память до запроса: 2.595 MB Выбрано строк: 1Повторяющиеся запросы: #36
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=3
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/components/com_banners/models/banners.php:284 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 6.78 ms После последнего запроса: 0.23 ms Память запроса: 0.009 MB Память до запроса: 2.605 MB
UPDATE ko2bc_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=3
AND track_date='2024-04-25 23'EXPLAIN не доступен для запроса: UPDATE ko2bc_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=3 AND track_date='2024-04-25 23'Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.12 ms Updating 0.05 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:314 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.35 ms После последнего запроса: 0.25 ms Память запроса: 0.009 MB Память до запроса: 2.615 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 5EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 5Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.05 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.03 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 0.24 ms Память запроса: 0.010 MB Память до запроса: 2.625 MB Выбрано строк: 1Повторяющиеся запросы: #41
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=5
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:277 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.15 ms После последнего запроса: 0.17 ms Память запроса: 0.011 MB Память до запроса: 2.635 MB Выбрано строк: 1Повторяющиеся запросы: #40
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=5
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/components/com_banners/models/banners.php:284 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.23 ms Память запроса: 0.009 MB Память до запроса: 2.645 MB
UPDATE ko2bc_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=5
AND track_date='2024-04-25 23'EXPLAIN не доступен для запроса: UPDATE ko2bc_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=5 AND track_date='2024-04-25 23'Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.10 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:314 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.83 ms После последнего запроса: 0.48 ms Память запроса: 0.009 MB Память до запроса: 2.654 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 7EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 7Status Duration starting 0.16 ms checking permissions 0.27 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.05 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.38 ms После последнего запроса: 0.24 ms Память запроса: 0.010 MB Память до запроса: 2.664 MB Выбрано строк: 1Повторяющиеся запросы: #45
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=7
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:277 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.14 ms После последнего запроса: 0.21 ms Память запроса: 0.011 MB Память до запроса: 2.674 MB Выбрано строк: 1Повторяющиеся запросы: #44
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=7
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/components/com_banners/models/banners.php:284 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 0.25 ms Память запроса: 0.009 MB Память до запроса: 2.684 MB
UPDATE ko2bc_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=7
AND track_date='2024-04-25 23'EXPLAIN не доступен для запроса: UPDATE ko2bc_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=7 AND track_date='2024-04-25 23'Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.10 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:314 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.62 ms После последнего запроса: 205.47 ms Память запроса: 0.016 MB Память до запроса: 2.724 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-25 23:12:48' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.03 ms init 0.07 ms optimizing 0.03 ms executing 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:184 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.67 ms После последнего запроса: 0.72 ms Память запроса: 0.014 MB Память до запроса: 2.742 MB Выбрано строк: 1
SELECT COUNT(*)
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (37)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref idx_state,idx_banner_catid idx_banner_catid 4 const 5 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.05 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.05 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.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_carousel_banner/helper.php:48 11 modCarouselBannerHelper::getList() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.78 ms После последнего запроса: 0.24 ms Память запроса: 0.014 MB Память до запроса: 2.752 MB Выбрано строк: 5
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (37)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 Используется filesort 1 SIMPLE a ref idx_state,idx_banner_catid idx_banner_catid 4 const 5 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.05 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.07 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_carousel_banner/helper.php:48 11 modCarouselBannerHelper::getList() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.57 ms После последнего запроса: 0.56 ms Память запроса: 0.009 MB Память до запроса: 2.775 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 11EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 11Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 0.23 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_carousel_banner/helper.php:49 11 modCarouselBannerHelper::getList() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.33 ms После последнего запроса: 0.21 ms Память запроса: 0.009 MB Память до запроса: 2.785 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 12EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 12Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.05 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_carousel_banner/helper.php:49 11 modCarouselBannerHelper::getList() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.34 ms После последнего запроса: 0.20 ms Память запроса: 0.009 MB Память до запроса: 2.794 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 13EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 13Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms Updating 0.05 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_carousel_banner/helper.php:49 11 modCarouselBannerHelper::getList() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 0.20 ms Память запроса: 0.009 MB Память до запроса: 2.804 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 14EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 14Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_carousel_banner/helper.php:49 11 modCarouselBannerHelper::getList() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.32 ms После последнего запроса: 0.21 ms Память запроса: 0.009 MB Память до запроса: 2.814 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 15EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 15Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_carousel_banner/helper.php:49 11 modCarouselBannerHelper::getList() JROOT/modules/mod_carousel_banner/mod_carousel_banner.php:185 10 include JROOT/modules/mod_carousel_banner/mod_carousel_banner.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.45 ms После последнего запроса: 4.72 ms Память запроса: 0.016 MB Память до запроса: 2.818 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-25 23:12:48' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.02 ms init 0.05 ms optimizing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.54 ms После последнего запроса: 0.67 ms Память запроса: 0.014 MB Память до запроса: 2.836 MB Выбрано строк: 1
SELECT COUNT(*)
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (36)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref idx_state,idx_banner_catid idx_banner_catid 4 const 2 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.05 ms optimizing 0.04 ms statistics 0.08 ms preparing 0.04 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.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.62 ms После последнего запроса: 0.25 ms Память запроса: 0.014 MB Память до запроса: 2.846 MB Выбрано строк: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (36)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 Используется filesort 1 SIMPLE a ref idx_state,idx_banner_catid idx_banner_catid 4 const 2 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.05 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.05 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 0.33 ms Память запроса: 0.009 MB Память до запроса: 2.861 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 9EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 9Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.05 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.46 ms После последнего запроса: 0.23 ms Память запроса: 0.010 MB Память до запроса: 2.871 MB Выбрано строк: 1Повторяющиеся запросы: #60
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=9
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.10 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:277 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.15 ms После последнего запроса: 0.19 ms Память запроса: 0.011 MB Память до запроса: 2.881 MB Выбрано строк: 1Повторяющиеся запросы: #59
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=9
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/components/com_banners/models/banners.php:284 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.40 ms После последнего запроса: 0.23 ms Память запроса: 0.009 MB Память до запроса: 2.892 MB
UPDATE ko2bc_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=9
AND track_date='2024-04-25 23'EXPLAIN не доступен для запроса: UPDATE ko2bc_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=9 AND track_date='2024-04-25 23'Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.11 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:314 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.57 ms После последнего запроса: 27.36 ms Память запроса: 0.016 MB Память до запроса: 2.996 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-25 23:12:48' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE Status Duration starting 0.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.03 ms init 0.06 ms optimizing 0.03 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.64 ms После последнего запроса: 0.77 ms Память запроса: 0.014 MB Память до запроса: 3.014 MB Выбрано строк: 1
SELECT COUNT(*)
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (35)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref idx_state,idx_banner_catid idx_banner_catid 4 const 1 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.05 ms optimizing 0.04 ms statistics 0.14 ms preparing 0.05 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:341 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:290 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:324 14 JModelList->getStart() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.66 ms После последнего запроса: 0.24 ms Память запроса: 0.014 MB Память до запроса: 3.024 MB Выбрано строк: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (35)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cl const PRIMARY PRIMARY 4 const 1 Используется filesort 1 SIMPLE a ref idx_state,idx_banner_catid idx_banner_catid 4 const 1 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.05 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.07 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 13 JModelList->getItems() JROOT/components/com_banners/models/banners.php:203 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:44 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.41 ms После последнего запроса: 0.44 ms Память запроса: 0.010 MB Память до запроса: 3.042 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 8EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 8Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms Updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:242 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.41 ms После последнего запроса: 0.24 ms Память запроса: 0.010 MB Память до запроса: 3.052 MB Выбрано строк: 1Повторяющиеся запросы: #67
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=8
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:277 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.15 ms После последнего запроса: 0.18 ms Память запроса: 0.011 MB Память до запроса: 3.062 MB Выбрано строк: 1Повторяющиеся запросы: #66
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=8
AND track_date='2024-04-25 23'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ko2bc_banner_tracks const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 16 const,const,const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.01 ms checking privileges on cached 0.01 ms checking permissions 0.01 ms sending cached result to clien 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731 13 JDatabaseDriver->loadResult() JROOT/components/com_banners/models/banners.php:284 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 0.24 ms Память запроса: 0.009 MB Память до запроса: 3.073 MB
UPDATE ko2bc_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=8
AND track_date='2024-04-25 23'EXPLAIN не доступен для запроса: UPDATE ko2bc_banner_tracks SET `count` = (`count` + 1) WHERE track_type=1 AND banner_id=8 AND track_date='2024-04-25 23'Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.11 ms Updating 0.04 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:314 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:45 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/cms/module/helper.php:190 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49
29 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
12 × SELECT `count`
FROM ko2bc_banner_tracks4 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid4 × SELECT *
FROM ko2bc_banners4 × SELECT COUNT(*)
FROM ko2bc_banners as a
LEFT JOIN ko2bc_banner_clients AS cl
ON cl.id = a.cid2 × 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 ko2bc_categories as c
LEFT JOIN (SELECT cat.id as id
FROM ko2bc_categories AS cat JOIN ko2bc_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT template
FROM ko2bc_template_styles as s2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM ko2bc_extensions2 × SELECT `session_id`
FROM `ko2bc_session`1 × SELECT *
FROM ko2bc_content1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM ko2bc_content AS a
LEFT JOIN ko2bc_categories AS c
on c.id = a.catid
LEFT JOIN ko2bc_users AS u
on u.id = a.created_by
LEFT JOIN ko2bc_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ko2bc_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ko2bc_categories AS cat JOIN ko2bc_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT `m`.`tag_id`,`t`.*
FROM `ko2bc_contentitem_tag_map` AS m
INNER JOIN `ko2bc_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT b.rules
FROM ko2bc_assets AS a
LEFT JOIN ko2bc_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ko2bc_modules AS m
LEFT JOIN ko2bc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ko2bc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM ko2bc_languages1 × SELECT folder AS type, element AS name, params
FROM ko2bc_extensions1 × SELECT id, rules
FROM `ko2bc_viewlevels1 × SELECT b.id
FROM ko2bc_usergroups AS a
LEFT JOIN ko2bc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT extension, file, type
FROM ko2bc_rokcommon_configs1 × 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 ko2bc_menu AS m
LEFT JOIN ko2bc_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM ko2bc_template_styles as s
LEFT JOIN ko2bc_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `data`
FROM `ko2bc_session`1 × SELECT `alias`,`catid`
FROM `ko2bc_content`1 × SELECT a.rules
FROM ko2bc_assets AS a
Прочие SQL-запросы:
11 × UPDATE ko2bc_banners
SET impmade = (impmade + 1)6 × UPDATE ko2bc_banner_tracks
SET `count` = (`count` + 1)1 × UPDATE ko2bc_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `ko2bc_content1 × UPDATE `ko2bc_extensions`
SET `params` = '{\"mediaversion\":\"aefeae3cee8d61fd55ff65dc443bc1df\"}'1 × INSERT INTO `ko2bc_session` (`session_id`, `client_id`, `time`)
VALUES ('82o356ear8c87bjbt53q4mmpd3', 0, '1714086768'