Версия для слабовидящих
Решаем вместе
Есть предложения по улучшению социальной сферы, повышению эффективности служб занятости или другие вопросы?
Напишите об этом — Минтруд поможет с решением!
Новости
Сегодня в ГБУ"КЦСОН Урус-Мартановского района прошло совещание под руководством директора.
В ходе совещания были затронуты вопросы качества предоставляемых услуг подопечным учреждения.
Заведующие отделениями выступили с отчётами о выполняемой работе.
Так же обсудили важность соблюдения трудовой дисциплины.
Дорогие друзья! В рамках исполнения поручения Главы Чеченской Республики, Героя России Рамзана Ахматовича Кадырова (@kadyrov_95) по улучшению качества предоставляемых социальных услуг гражданам пожилого возраста и инвалидам работники специализированного социально-медицинского отделения ГБУ "КЦСОН" Урус_Мартановского района
В рамках исполнения своих должностных обязанностей работники ГБУ КЦСОН Урус-Мартановского района посетили своих подопечных и оказали им необходимую помошь.
В ГБУ КЦСОН Урус-Мартановского района прошло мероприятие приуроченное ко Дню пожилых людей. На праздник были приглашены пожилые люди из числа граждан, находящихся на социальном обслуживании в ГБУ КЦСОН Урус-Мартановского района
От всей души поздравляю Вас с Днем Конституции Чеченской Республики!
23 марта 2003 года - самое важное политическое событие в истории нашего народа. В этот день по инициативе первого Президента Чеченской Республики, Героя России Ахмат-Хаджи Кадырова была принята Конституция нашей республики, положившая начало государственности чеченского общества и определившая судьбу чеченской нации в многонациональной семье народов России.
Приказ Минздрава России от 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": 1714106418,
"last": 1714106418,
"now": 1714106418
},
"client": {
"forwarded": "3.135.205.164"
}
},
"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
}
}
}
Время
Память
Время: 264.63 ms / 264.63 ms Память: 0.105 MB / 0.22 MB Application: afterLoad
Время: 662.15 ms / 926.77 ms Память: 1.099 MB / 1.32 MB Application: afterInitialise
Время: 10.71 ms / 937.48 ms Память: 0.250 MB / 1.57 MB Application: afterRoute
Время: 79.55 ms / 1017.03 ms Память: 0.106 MB / 1.67 MB Application: beforeRenderComponent com_content
Время: 642.63 ms / 1659.66 ms Память: 0.751 MB / 2.42 MB Application: afterRenderComponent com_content
Время: 7.64 ms / 1667.30 ms Память: 0.013 MB / 2.44 MB Application: afterDispatch
Время: 31.71 ms / 1699.01 ms Память: 0.087 MB / 2.52 MB Application: beforeRenderModule mod_menu (Футер меню)
Время: 37.89 ms / 1736.90 ms Память: 0.107 MB / 2.63 MB Application: afterRenderModule mod_menu (Футер меню)
Время: 0.31 ms / 1737.21 ms Память: 0.000 MB / 2.63 MB Application: beforeRenderModule mod_custom (Телефон)
Время: 2.55 ms / 1739.76 ms Память: 0.006 MB / 2.63 MB Application: afterRenderModule mod_custom (Телефон)
Время: 1.10 ms / 1740.86 ms Память: 0.005 MB / 2.64 MB Application: beforeRenderModule mod_banners (Хостинг для joomla)
Время: 49.66 ms / 1790.52 ms Память: 0.238 MB / 2.88 MB Application: afterRenderModule mod_banners (Хостинг для joomla)
Время: 0.24 ms / 1790.76 ms Память: 0.000 MB / 2.87 MB Application: beforeRenderModule mod_scrolltop (Кнопка наверх )
Время: 254.50 ms / 2045.26 ms Память: 0.015 MB / 2.88 MB Application: afterRenderModule mod_scrolltop (Кнопка наверх )
Время: 0.18 ms / 2045.44 ms Память: 0.000 MB / 2.88 MB Application: beforeRenderModule mod_custom (Министр)
Время: 0.57 ms / 2046.02 ms Память: 0.004 MB / 2.88 MB Application: afterRenderModule mod_custom (Министр)
Время: 0.12 ms / 2046.13 ms Память: 0.000 MB / 2.88 MB Application: beforeRenderModule mod_custom (Важно прививки)
Время: 0.59 ms / 2046.73 ms Память: 0.004 MB / 2.88 MB Application: afterRenderModule mod_custom (Важно прививки)
Время: 0.21 ms / 2046.94 ms Память: 0.000 MB / 2.88 MB Application: beforeRenderModule mod_carousel_banner (Carousel Banner)
Время: 42.76 ms / 2089.70 ms Память: 0.119 MB / 3.00 MB Application: afterRenderModule mod_carousel_banner (Carousel Banner)
Время: 0.21 ms / 2089.91 ms Память: 0.000 MB / 2.99 MB Application: beforeRenderModule mod_custom (Эмблема к 70 летию победы)
Время: 0.82 ms / 2090.73 ms Память: 0.004 MB / 2.99 MB Application: afterRenderModule mod_custom (Эмблема к 70 летию победы)
Время: 0.13 ms / 2090.86 ms Память: 0.000 MB / 2.99 MB Application: beforeRenderModule mod_custom (1)
Время: 0.67 ms / 2091.53 ms Память: 0.004 MB / 2.99 MB Application: afterRenderModule mod_custom (1)
Время: 0.15 ms / 2091.68 ms Память: 0.000 MB / 2.99 MB Application: beforeRenderModule mod_banners (МЫВМЕСТЕ)
Время: 7.67 ms / 2099.36 ms Память: 0.084 MB / 3.08 MB Application: afterRenderModule mod_banners (МЫВМЕСТЕ)
Время: 0.32 ms / 2099.68 ms Память: 0.000 MB / 3.08 MB Application: beforeRenderModule mod_ariimageslider (Фотогалерея)
Время: 158.74 ms / 2258.41 ms Память: 0.118 MB / 3.19 MB Application: afterRenderModule mod_ariimageslider (Фотогалерея)
Время: 0.37 ms / 2258.78 ms Память: 0.000 MB / 3.17 MB Application: beforeRenderModule mod_banners (Тотальный тест)
Время: 8.59 ms / 2267.37 ms Память: 0.089 MB / 3.26 MB Application: afterRenderModule mod_banners (Тотальный тест)
Время: 0.65 ms / 2268.02 ms Память: 0.002 MB / 3.26 MB Application: beforeRenderModule mod_flexi_customcode (Обратная связь ПОС)
Время: 124.14 ms / 2392.16 ms Память: 0.042 MB / 3.30 MB Application: afterRenderModule mod_flexi_customcode (Обратная связь ПОС)
Время: 0.35 ms / 2392.51 ms Память: 0.000 MB / 3.28 MB Application: beforeRenderModule mod_djimageslider (Слайдер)
Время: 7.51 ms / 2400.02 ms Память: 0.040 MB / 3.32 MB Application: afterRenderModule mod_djimageslider (Слайдер)
Время: 0.36 ms / 2400.38 ms Память: 0.000 MB / 3.31 MB Application: beforeRenderModule mod_menu (Главное меню)
Время: 26.32 ms / 2426.71 ms Память: 0.054 MB / 3.37 MB Application: afterRenderModule mod_menu (Главное меню)
Время: 0.38 ms / 2427.09 ms Память: 0.000 MB / 3.37 MB Application: beforeRenderModule mod_search (Поиск)
Время: 12.52 ms / 2439.61 ms Память: 0.018 MB / 3.38 MB Application: afterRenderModule mod_search (Поиск)
Время: 0.17 ms / 2439.78 ms Память: 0.000 MB / 3.38 MB Application: beforeRenderModule mod_wonder_css (Версия для слабовидящих )
Время: 4.36 ms / 2444.14 ms Память: 0.010 MB / 3.39 MB Application: afterRenderModule mod_wonder_css (Версия для слабовидящих )
Время: 46.08 ms / 2490.22 ms Память: 0.141 MB / 3.53 MB Application: afterRender
Всего SQL-запросов: 245.60 ms
4.23 MB (4,433,940 Байт)
72 SQL-запросов зафиксировано 245.60 ms
20 повторяющийся запрос!
- Время запроса: 27.03 ms Память запроса: 0.011 MB Память до запроса: 0.499 MB Выбрано строк: 0
SELECT `data`
FROM `ko2bc_session`
WHERE `session_id` = '9ns34ljffvkhetugqhik1esb66'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.05 ms Waiting for query cache lock 0.01 ms checking query cache for query 1.15 ms checking permissions 0.02 ms Opening tables 2.17 ms After opening tables 3.32 ms System lock 0.83 ms Table lock 0.02 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 5.10 ms init 0.48 ms optimizing 0.03 ms statistics 9.90 ms preparing 0.03 ms executing 3.54 ms end 0.04 ms query end 0.09 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 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.68 ms После последнего запроса: 17.76 ms Память запроса: 0.007 MB Память до запроса: 0.536 MB Выбрано строк: 0Повторяющиеся запросы: #31
SELECT `session_id`
FROM `ko2bc_session`
WHERE `session_id` = '9ns34ljffvkhetugqhik1esb66'
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.04 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.08 ms init 0.03 ms optimizing 0.02 ms statistics 0.07 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.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 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 - Время запроса: 86.45 ms После последнего запроса: 0.38 ms Память запроса: 0.005 MB Память до запроса: 0.543 MB
INSERT INTO `ko2bc_session` (`session_id`, `client_id`, `time`)
VALUES ('9ns34ljffvkhetugqhik1esb66', 0, '1714106418')EXPLAIN не доступен для запроса: INSERT INTO `ko2bc_session` (`session_id`, `client_id`, `time`) VALUES ('9ns34ljffvkhetugqhik1esb66', 0, '1714106418')Status Duration starting 0.09 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 init 37.11 ms update 6.67 ms Waiting for query cache lock 0.03 ms update 0.02 ms end 0.01 ms query end 42.30 ms closing tables 0.04 ms freeing items 0.01 ms updating status 0.36 ms cleaning up 0.02 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 - Время запроса: 1.07 ms После последнего запроса: 4.38 ms Память запроса: 0.011 MB Память до запроса: 0.595 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.04 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.03 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.01 ms Sending data 0.30 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.03 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 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.25 ms После последнего запроса: 2.60 ms Память запроса: 0.008 MB Память до запроса: 0.629 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.05 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.15 ms После последнего запроса: 0.31 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 - Время запроса: 3.32 ms После последнего запроса: 0.38 ms Память запроса: 0.007 MB Память до запроса: 0.651 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.02 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.20 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.03 ms init 0.05 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.04 ms executing 0.01 ms Sorting result 2.10 ms Sending data 0.34 ms end 0.02 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.03 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 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 - Время запроса: 6.33 ms После последнего запроса: 105.57 ms Память запроса: 0.011 MB Память до запроса: 0.919 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.04 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.22 ms После последнего запроса: 0.43 ms Память запроса: 0.012 MB Память до запроса: 0.930 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.04 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 - Время запроса: 16.12 ms После последнего запроса: 48.41 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.05 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 - Время запроса: 1.59 ms После последнего запроса: 69.48 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.04 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.11 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.05 ms optimizing 0.04 ms statistics 0.09 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.28 ms Sending data 0.24 ms Waiting for query cache lock 0.01 ms Sending data 0.22 ms end 0.01 ms query end 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.03 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 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.88 ms После последнего запроса: 11.42 ms Память запроса: 0.011 MB Память до запроса: 1.587 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.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.02 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.28 ms preparing 0.03 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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 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 - Время запроса: 21.56 ms После последнего запроса: 24.43 ms Память запроса: 0.007 MB Память до запроса: 1.589 MB
UPDATE `ko2bc_extensions`
SET `params` = '{\"mediaversion\":\"e6ad058151054ae6f6a4264a69addb18\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `ko2bc_extensions` SET `params` = '{\"mediaversion\":\"e6ad058151054ae6f6a4264a69addb18\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.10 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 init 1.90 ms Updating 19.12 ms end 0.02 ms Waiting for query cache lock 0.01 ms end 0.06 ms query end 0.08 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 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 - Время запроса: 1.11 ms После последнего запроса: 6.71 ms Память запроса: 0.008 MB Память до запроса: 1.649 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.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.07 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 - Время запроса: 10.85 ms После последнего запроса: 4.95 ms Память запроса: 0.006 MB Память до запроса: 1.662 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.03 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.03 ms After opening tables 0.01 ms System lock 0.02 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.04 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.04 ms executing 0.01 ms Sending data 0.12 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.02 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.31 ms После последнего запроса: 48.92 ms Память запроса: 0.014 MB Память до запроса: 1.856 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.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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 17 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 16 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:384 15 JUser->authorise() JROOT/components/com_content/models/category.php:137 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:439 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.17 ms После последнего запроса: 1.30 ms Память запроса: 0.015 MB Память до запроса: 1.875 MB Выбрано строк: 3
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.category.28')
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 ALL idx_lft_rgt Индекс не используется NULL NULL 437 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 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 18 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 17 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 16 JAccess::check() JROOT/libraries/joomla/user/user.php:393 15 JUser->authorise() JROOT/components/com_content/models/category.php:137 14 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:439 13 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:114 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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 - Время запроса: 26.16 ms После последнего запроса: 29.57 ms Память запроса: 0.018 MB Память до запроса: 1.914 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,COUNT(i.`id`) AS numitems
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)
LEFT JOIN `ko2bc_content` AS i
ON i.`catid` = c.id
AND i.state = 1
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 i ref idx_state,idx_catid idx_catid 4 urus.c.id 4 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.04 ms Waiting for query cache lock 0.01 ms checking query cache for query 1.84 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 Opening tables 0.04 ms After opening tables 0.02 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.05 ms init 0.58 ms optimizing 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.09 ms statistics 0.23 ms preparing 0.08 ms executing 0.01 ms Creating tmp table 6.69 ms Copying to tmp table 0.19 ms executing 0.01 ms Creating tmp table 0.03 ms Copying to tmp table 0.37 ms Sorting result 0.03 ms Sending data 0.03 ms removing tmp table 0.02 ms Sending data 2.77 ms Sorting result 0.06 ms Sending data 0.06 ms end 0.01 ms removing tmp table 0.99 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.03 ms freeing items 11.29 ms updating status 0.03 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.03 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 16 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 15 JCategories->get() JROOT/components/com_content/models/category.php:346 14 ContentModelCategory->getCategory() JROOT/components/com_content/models/category.php:223 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.20 ms После последнего запроса: 2.23 ms Память запроса: 0.017 MB Память до запроса: 1.959 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.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.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1541 21 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 20 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 19 JAccess::check() JROOT/libraries/joomla/user/user.php:393 18 JUser->authorise() JROOT/components/com_content/models/articles.php:449 17 ContentModelArticles->getListQuery() JROOT/libraries/legacy/model/list.php:129 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:181 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:537 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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 - Время запроса: 5.96 ms После последнего запроса: 0.65 ms Память запроса: 0.034 MB Память до запроса: 1.978 MB Выбрано строк: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM ko2bc_content AS a
LEFT JOIN ko2bc_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ko2bc_categories AS c
ON c.id = a.catid
LEFT JOIN ko2bc_users AS ua
ON ua.id = a.created_by
LEFT JOIN ko2bc_users AS uam
ON uam.id = a.modified_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 != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 28
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 04:40:18')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 04:40:18')
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 35, 5id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 Using temporary; Используется filesort 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 47 Using where 1 PRIMARY fp eq_ref PRIMARY PRIMARY 4 urus.a.id 1 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 urus.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 urus.a.modified_by 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 urus.a.id 1 Using where 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.35 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 Opening tables 0.06 ms After opening tables 0.02 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.06 ms init 0.19 ms optimizing 0.01 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.11 ms statistics 0.14 ms preparing 0.06 ms executing 0.01 ms Creating tmp table 0.52 ms Copying to tmp table 0.11 ms executing 0.01 ms Creating tmp table 0.02 ms Copying to tmp table 0.35 ms Sorting result 0.03 ms Sending data 0.02 ms removing tmp table 0.01 ms Sending data 2.67 ms Sorting result 0.20 ms Sending data 0.22 ms Waiting for query cache lock 0.01 ms Sending data 0.17 ms end 0.01 ms removing tmp table 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.02 ms freeing items 0.03 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 1.36 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:312 16 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:185 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:537 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.44 ms После последнего запроса: 2.45 ms Память запроса: 0.017 MB Память до запроса: 2.083 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` = 144
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.11 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 15 JHelperTags->getItemTags() JROOT/components/com_content/models/articles.php:665 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.17 ms После последнего запроса: 0.93 ms Память запроса: 0.017 MB Память до запроса: 2.106 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` = 143
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.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 15 JHelperTags->getItemTags() JROOT/components/com_content/models/articles.php:665 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.17 ms После последнего запроса: 0.92 ms Память запроса: 0.017 MB Память до запроса: 2.128 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` = 131
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.02 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 15 JHelperTags->getItemTags() JROOT/components/com_content/models/articles.php:665 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.43 ms Память запроса: 0.017 MB Память до запроса: 2.151 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` = 124
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.03 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 15 JHelperTags->getItemTags() JROOT/components/com_content/models/articles.php:665 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.17 ms После последнего запроса: 0.91 ms Память запроса: 0.018 MB Память до запроса: 2.173 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` = 117
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.02 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 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 15 JHelperTags->getItemTags() JROOT/components/com_content/models/articles.php:665 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:245 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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 - Время запроса: 2.02 ms После последнего запроса: 20.03 ms Память запроса: 0.014 MB Память до запроса: 2.195 MB Выбрано строк: 1
SELECT COUNT(*)
FROM ko2bc_content AS a
LEFT JOIN ko2bc_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ko2bc_categories AS c
ON c.id = a.catid
LEFT JOIN ko2bc_users AS ua
ON ua.id = a.created_by
LEFT JOIN ko2bc_users AS uam
ON uam.id = a.modified_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 != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 28
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 04:40:18')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 04:40:18')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 47 Using where 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.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.17 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 Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.01 ms After table lock 0.01 ms Waiting for query cache lock 0.01 ms After table lock 0.05 ms init 0.10 ms optimizing 0.01 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.09 ms statistics 0.13 ms preparing 0.04 ms executing 0.01 ms Sending data 0.07 ms executing 0.01 ms Creating tmp table 0.02 ms Copying to tmp table 0.34 ms Sorting result 0.02 ms Sending data 0.02 ms removing tmp table 0.01 ms Sending data 0.30 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 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 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:235 14 JModelList->getPagination() JROOT/components/com_content/models/category.php:257 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:401 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.18 ms После последнего запроса: 0.77 ms Память запроса: 0.015 MB Память до запроса: 2.199 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.category'
AND `m`.`content_item_id` = 28
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.02 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:426 12 JHelperTags->getItemTags() JROOT/libraries/legacy/view/category.php:217 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->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.28 ms После последнего запроса: 473.03 ms Память запроса: 0.022 MB Память до запроса: 2.432 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.04 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.02 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1692 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 22 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 21 JCategories->get() JROOT/components/com_content/helpers/route.php:44 20 ContentHelperRoute::getArticleRoute() JROOT/layouts/joomla/content/blog_style_default_item_title.php:24 19 include JROOT/layouts/joomla/content/blog_style_default_item_title.php JROOT/libraries/cms/layout/file.php:121 18 JLayoutFile->render() JROOT/libraries/cms/layout/helper.php:72 17 JLayoutHelper::render() JROOT/templates/rsmetro/html/com_content/category/blog_item.php:22 16 include JROOT/templates/rsmetro/html/com_content/category/blog_item.php JROOT/libraries/legacy/view/legacy.php:670 15 JViewLegacy->loadTemplate() JROOT/templates/rsmetro/html/com_content/category/blog.php:84 14 include JROOT/templates/rsmetro/html/com_content/category/blog.php JROOT/libraries/legacy/view/legacy.php:670 13 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209 12 JViewLegacy->display() JROOT/libraries/legacy/view/category.php:233 11 JViewCategory->display() JROOT/components/com_content/views/category/view.html.php:258 10 ContentViewCategory->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 - Время запроса: 2.38 ms После последнего запроса: 56.16 ms Память запроса: 0.012 MB Память до запроса: 2.460 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-26 04:40:18')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 04:40:18')
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.05 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.14 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.02 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.05 ms init 0.07 ms optimizing 0.06 ms statistics 0.14 ms preparing 0.07 ms executing 0.01 ms Sorting result 0.25 ms Sending data 0.77 ms Waiting for query cache lock 0.01 ms Sending data 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms updating status 0.01 ms Waiting for query cache lock 0.01 ms updating status 0.03 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 - Время запроса: 1.13 ms После последнего запроса: 27.81 ms Память запроса: 0.015 MB Память до запроса: 2.597 MB
DELETE
FROM `ko2bc_session`
WHERE `time` < '1714097419'EXPLAIN не доступен для запроса: DELETE FROM `ko2bc_session` WHERE `time` < '1714097419'Status Duration starting 0.07 ms checking permissions 0.03 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 init 0.08 ms updating 0.29 ms end 0.02 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 0.30 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:765 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.51 ms После последнего запроса: 0.33 ms Память запроса: 0.018 MB Память до запроса: 2.614 MB Выбрано строк: 1Повторяющиеся запросы: #2
SELECT `session_id`
FROM `ko2bc_session`
WHERE `session_id` = '9ns34ljffvkhetugqhik1esb66'
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.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.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.04 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.75 ms После последнего запроса: 24.85 ms Память запроса: 0.016 MB Память до запроса: 2.668 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-26 04:40:18' >= '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.04 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.09 ms checking permissions 0.02 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.05 ms init 0.07 ms optimizing 0.04 ms executing 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 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.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.81 ms После последнего запроса: 4.21 ms Память запроса: 0.014 MB Память до запроса: 2.700 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.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.12 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 init 0.07 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.73 ms После последнего запроса: 0.26 ms Память запроса: 0.014 MB Память до запроса: 2.709 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.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.06 ms preparing 0.06 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.39 ms После последнего запроса: 0.58 ms Память запроса: 0.009 MB Память до запроса: 2.731 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 2EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 2Status 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.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.06 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.741 MB Выбрано строк: 0Повторяющиеся запросы: #37
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2024-04-26 04'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.03 ms init 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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.751 MB Выбрано строк: 0Повторяющиеся запросы: #36
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2024-04-26 04'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.36 ms После последнего запроса: 0.25 ms Память запроса: 0.009 MB Память до запроса: 2.761 MB
INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 2, '2024-04-26 04')EXPLAIN не доступен для запроса: INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 2, '2024-04-26 04')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.01 ms update 0.07 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 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: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.33 ms После последнего запроса: 0.19 ms Память запроса: 0.009 MB Память до запроса: 2.771 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.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.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.40 ms После последнего запроса: 0.21 ms Память запроса: 0.010 MB Память до запроса: 2.781 MB Выбрано строк: 0Повторяющиеся запросы: #41
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=3
AND track_date='2024-04-26 04'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.03 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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.790 MB Выбрано строк: 0Повторяющиеся запросы: #40
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=3
AND track_date='2024-04-26 04'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.33 ms После последнего запроса: 0.24 ms Память запроса: 0.009 MB Память до запроса: 2.801 MB
INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 3, '2024-04-26 04')EXPLAIN не доступен для запроса: INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 3, '2024-04-26 04')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.01 ms update 0.06 ms Waiting for query cache lock 0.01 ms update 0.02 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.19 ms Память запроса: 0.009 MB Память до запроса: 2.810 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.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.820 MB Выбрано строк: 0Повторяющиеся запросы: #45
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=5
AND track_date='2024-04-26 04'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.03 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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.830 MB Выбрано строк: 0Повторяющиеся запросы: #44
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=5
AND track_date='2024-04-26 04'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.31 ms После последнего запроса: 0.24 ms Память запроса: 0.009 MB Память до запроса: 2.840 MB
INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 5, '2024-04-26 04')EXPLAIN не доступен для запроса: INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 5, '2024-04-26 04')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.02 ms update 0.06 ms Waiting for query cache lock 0.01 ms update 0.02 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.31 ms После последнего запроса: 0.18 ms Память запроса: 0.009 MB Память до запроса: 2.850 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 7EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 7Status 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.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.20 ms Память запроса: 0.010 MB Память до запроса: 2.860 MB Выбрано строк: 0Повторяющиеся запросы: #49
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=7
AND track_date='2024-04-26 04'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.03 ms init 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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.16 ms Память запроса: 0.011 MB Память до запроса: 2.869 MB Выбрано строк: 0Повторяющиеся запросы: #48
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=7
AND track_date='2024-04-26 04'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.29 ms После последнего запроса: 0.21 ms Память запроса: 0.009 MB Память до запроса: 2.880 MB
INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 7, '2024-04-26 04')EXPLAIN не доступен для запроса: INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 7, '2024-04-26 04')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.01 ms update 0.05 ms Waiting for query cache lock 0.01 ms update 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.59 ms После последнего запроса: 291.72 ms Память запроса: 0.016 MB Память до запроса: 2.919 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-26 04:40:18' >= '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.05 ms init 0.08 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.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_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.62 ms После последнего запроса: 0.61 ms Память запроса: 0.014 MB Память до запроса: 2.938 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.01 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.06 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 - Время запроса: 6.34 ms После последнего запроса: 0.21 ms Память запроса: 0.014 MB Память до запроса: 2.947 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.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.04 ms statistics 0.07 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.06 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_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 - Время запроса: 2.84 ms После последнего запроса: 0.56 ms Память запроса: 0.009 MB Память до запроса: 2.970 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 11EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 11Status Duration starting 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 init 0.06 ms Updating 0.07 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 2.44 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 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.38 ms После последнего запроса: 0.23 ms Память запроса: 0.009 MB Память до запроса: 2.980 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 12EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 12Status 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.05 ms Updating 0.06 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.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_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.31 ms После последнего запроса: 0.19 ms Память запроса: 0.009 MB Память до запроса: 2.990 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 13EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 13Status 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_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.19 ms Память запроса: 0.009 MB Память до запроса: 2.999 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.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.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.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.55 ms После последнего запроса: 0.19 ms Память запроса: 0.009 MB Память до запроса: 3.009 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.27 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.68 ms После последнего запроса: 25.49 ms Память запроса: 0.016 MB Память до запроса: 3.013 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-26 04:40:18' >= '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.05 ms init 0.06 ms optimizing 0.04 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.02 ms Waiting for query cache lock 0.01 ms updating status 0.01 ms storing result in query cache 0.02 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.62 ms После последнего запроса: 0.72 ms Память запроса: 0.014 MB Память до запроса: 3.032 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.01 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.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.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 - Время запроса: 1.69 ms После последнего запроса: 0.23 ms Память запроса: 0.014 MB Память до запроса: 3.041 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.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 1.08 ms optimizing 0.04 ms statistics 0.08 ms preparing 0.06 ms executing 0.01 ms Sorting result 0.06 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.37 ms После последнего запроса: 0.34 ms Память запроса: 0.009 MB Память до запроса: 3.057 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.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.40 ms После последнего запроса: 0.27 ms Память запроса: 0.010 MB Память до запроса: 3.067 MB Выбрано строк: 0Повторяющиеся запросы: #64
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=9
AND track_date='2024-04-26 04'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.03 ms init 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.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 Память до запроса: 3.076 MB Выбрано строк: 0Повторяющиеся запросы: #63
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=9
AND track_date='2024-04-26 04'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.35 ms После последнего запроса: 0.25 ms Память запроса: 0.009 MB Память до запроса: 3.088 MB
INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 9, '2024-04-26 04')EXPLAIN не доступен для запроса: INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 9, '2024-04-26 04')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.01 ms update 0.07 ms Waiting for query cache lock 0.01 ms update 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.73 ms После последнего запроса: 160.97 ms Память запроса: 0.016 MB Память до запроса: 3.192 MB Выбрано строк: 0
SELECT *
FROM ko2bc_banners
WHERE '2024-04-26 04:40:18' >= '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.04 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.09 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.05 ms init 0.07 ms optimizing 0.03 ms executing 0.06 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.92 ms После последнего запроса: 0.92 ms Память запроса: 0.014 MB Память до запроса: 3.210 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.03 ms Waiting for query cache lock 0.01 ms checking query cache for query 0.12 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.02 ms init 0.07 ms optimizing 0.05 ms statistics 0.17 ms preparing 0.06 ms executing 0.01 ms Sending data 0.06 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 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.89 ms После последнего запроса: 0.39 ms Память запроса: 0.014 MB Память до запроса: 3.220 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.14 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 init 0.08 ms optimizing 0.05 ms statistics 0.15 ms preparing 0.06 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.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_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.54 ms После последнего запроса: 0.48 ms Память запроса: 0.009 MB Память до запроса: 3.238 MB
UPDATE ko2bc_banners
SET impmade = (impmade + 1)
WHERE id = 8EXPLAIN не доступен для запроса: UPDATE ko2bc_banners SET impmade = (impmade + 1) WHERE id = 8Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.06 ms Updating 0.08 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.02 ms query end 0.08 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_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 После последнего запроса: 0.29 ms Память запроса: 0.010 MB Память до запроса: 3.248 MB Выбрано строк: 0Повторяющиеся запросы: #71
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=8
AND track_date='2024-04-26 04'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.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.05 ms init 0.02 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.01 ms executing 0.03 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.21 ms Память запроса: 0.011 MB Память до запроса: 3.257 MB Выбрано строк: 0Повторяющиеся запросы: #70
SELECT `count`
FROM ko2bc_banner_tracks
WHERE track_type=1
AND banner_id=8
AND track_date='2024-04-26 04'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.46 ms После последнего запроса: 0.28 ms Память запроса: 0.009 MB Память до запроса: 3.268 MB
INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 8, '2024-04-26 04')EXPLAIN не доступен для запроса: INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`) VALUES (1, 1, 8, '2024-04-26 04')Status Duration starting 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 init 0.02 ms update 0.10 ms Waiting for query cache lock 0.01 ms update 0.02 ms end 0.01 ms query end 0.05 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
33 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
12 × SELECT `count`
FROM ko2bc_banner_tracks6 × SELECT `m`.`tag_id`,`t`.*
FROM `ko2bc_contentitem_tag_map` AS m
INNER JOIN `ko2bc_tags` AS t
ON `m`.`tag_id` = `t`.`id`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.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 b.rules
FROM ko2bc_assets AS a
LEFT JOIN ko2bc_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.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 COUNT(*)
FROM ko2bc_content AS a
LEFT JOIN ko2bc_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ko2bc_categories AS c
ON c.id = a.catid
LEFT JOIN ko2bc_users AS ua
ON ua.id = a.created_by
LEFT JOIN ko2bc_users AS uam
ON uam.id = a.modified_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 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.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 a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM ko2bc_content AS a
LEFT JOIN ko2bc_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN ko2bc_categories AS c
ON c.id = a.catid
LEFT JOIN ko2bc_users AS ua
ON ua.id = a.created_by
LEFT JOIN ko2bc_users AS uam
ON uam.id = a.modified_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 a.rules
FROM ko2bc_assets AS a1 × 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 `data`
FROM `ko2bc_session`1 × 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 *
FROM ko2bc_languages1 × 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,COUNT(i.`id`) AS numitems
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
Прочие SQL-запросы:
11 × UPDATE ko2bc_banners
SET impmade = (impmade + 1)1 × INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 7, '2024-04-26 04'1 × INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 9, '2024-04-26 04'1 × INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 8, '2024-04-26 04'1 × INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 5, '2024-04-26 04'1 × INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 2, '2024-04-26 04'1 × UPDATE `ko2bc_extensions`
SET `params` = '{\"mediaversion\":\"e6ad058151054ae6f6a4264a69addb18\"}'1 × DELETE
FROM `ko2bc_session`1 × INSERT INTO `ko2bc_session` (`session_id`, `client_id`, `time`)
VALUES ('9ns34ljffvkhetugqhik1esb66', 0, '1714106418'1 × INSERT INTO ko2bc_banner_tracks (`count`,`track_type`,`banner_id`,`track_date`)
VALUES (1, 1, 3, '2024-04-26 04'