Проект "Региональный ресурсный центр. Объединяем усилия для укрепления некоммерческого сектора" (01.12.2022 – 30.11.2023)
Подробнее...
Мастерская НКО - 2023
26 сентября в Региональном центре по связям с общественностью была проведена Мастерская НКО – 2023. В этом году мероприятие проводится 6-й раз!
На мероприятие прибыло много заинтересованных людей, было прослушано большое количество выступлений.
- Подробнее...
- 27.09.2023
Конкурс студенческих работ завершен!
Завершен конкурс студенческих работ. На стратегической сессии победивших студентов наградили грамотами и подарками.
- Подробнее...
- 23.09.2023
Стратегическая сессия
21 сентября в ОмГУ им. Ф.М. Достоевского была проведена стратегическая сессия.
Главная идея мероприятия – заинтересовать будущих журналистов, политологов и PR-щиков деятельностью НКО. Им необходимо познать некоммерческий сектор, внести свой вклад в социальную сферу.
- Подробнее...
- 22.09.2023
Семинар по подготовке грантовой заявки
Большое внимание было уделено логике проекта, типичным ошибкам, критериям оценки. Особенно информационной открытости организации, многие НКО теряют на этом баллы. А также были проведены индивидуальные консультации. Спикеры: Зинаида Тикунова, Наталья Иордан.
- Подробнее...
- 21.09.2023
Брошюра «Становление и развитие некоммерческого сектора, формирование гражданского общества в Омской области. 1994-2001 годы»
В издании представлена история формирования третьего сектора в Омске и Омской области с 1994 по 2001 годы; прослеживаются основные этапы его развития, организации партнерского взаимодействия с органами власти и бизнесом; рассматривается участие омских общественников в становлении российского гражданского общества. Значительное внимание уделяется созданию и работе структур для поддержки деятельности некоммерческих организаций — Общественной палаты Омской области, Ресурсного центра для омских НКО, Совета НКО, которые не только способствовали развитию отдельных организаций, но и обеспечивали коллегиальную проектную работу; рассматривается их взаимодействие с Сибирским Центром Поддержки Общественных Инициатив.
- Подробнее...
- 29.07.2023
Главная
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1696423309,
"last": 1696423309,
"now": 1696423309
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Время
Память
Время: 4.90 ms / 4.90 ms Память: 0.190 MB / 0.41 MB Application: afterLoad
Время: 26.03 ms / 30.93 ms Память: 1.488 MB / 1.90 MB Application: afterInitialise
Время: 5.79 ms / 36.73 ms Память: 0.378 MB / 2.28 MB Application: afterRoute
Время: 4.26 ms / 40.98 ms Память: 0.163 MB / 2.44 MB Application: beforeRenderComponent com_content
Время: 2.81 ms / 43.79 ms Память: 0.248 MB / 2.69 MB Application: Before JAccess::preloadComponents (all components)
Время: 1.88 ms / 45.67 ms Память: 0.084 MB / 2.77 MB Application: After JAccess::preloadComponents (all components)
Время: 0.06 ms / 45.73 ms Память: 0.000 MB / 2.77 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Время: 0.32 ms / 46.05 ms Память: 0.018 MB / 2.78 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Время: 35.23 ms / 81.29 ms Память: 0.848 MB / 3.63 MB Application: afterRenderComponent com_content
Время: 1.09 ms / 82.37 ms Память: 0.022 MB / 3.65 MB Application: afterDispatch
Время: 5.33 ms / 87.70 ms Память: 0.128 MB / 3.78 MB Application: beforeRenderModule mod_menu (Меню в футере)
Время: 3.79 ms / 91.49 ms Память: 0.099 MB / 3.88 MB Application: afterRenderModule mod_menu (Меню в футере)
Время: 0.11 ms / 91.60 ms Память: 0.000 MB / 3.87 MB Application: beforeRenderModule mod_articles_news (Логотипы клиентов)
Время: 8.44 ms / 100.04 ms Память: 0.257 MB / 4.13 MB Application: afterRenderModule mod_articles_news (Логотипы клиентов)
Время: 0.19 ms / 100.23 ms Память: 0.000 MB / 3.99 MB Application: beforeRenderModule mod_articles_latest (Видео)
Время: 8.85 ms / 109.08 ms Память: 0.171 MB / 4.16 MB Application: afterRenderModule mod_articles_latest (Видео)
Время: 0.17 ms / 109.25 ms Память: 0.000 MB / 4.07 MB Application: beforeRenderModule mod_articles_latest (Фотоальбом)
Время: 3.59 ms / 112.84 ms Память: 0.154 MB / 4.22 MB Application: afterRenderModule mod_articles_latest (Фотоальбом)
Время: 0.15 ms / 112.99 ms Память: 0.000 MB / 4.14 MB Application: beforeRenderModule mod_menu (Издания-меню)
Время: 1.21 ms / 114.19 ms Память: 0.044 MB / 4.18 MB Application: afterRenderModule mod_menu (Издания-меню)
Время: 0.10 ms / 114.29 ms Память: 0.000 MB / 4.18 MB Application: beforeRenderModule mod_search (Поиск)
Время: 1.44 ms / 115.73 ms Память: 0.029 MB / 4.21 MB Application: afterRenderModule mod_search (Поиск)
Время: 0.11 ms / 115.84 ms Память: 0.000 MB / 4.20 MB Application: beforeRenderModule mod_articles_news (Новости на главной)
Время: 47.98 ms / 163.81 ms Память: 0.351 MB / 4.55 MB Application: afterRenderModule mod_articles_news (Новости на главной)
Время: 0.32 ms / 164.13 ms Память: 0.000 MB / 4.38 MB Application: beforeRenderModule mod_articles_news (Баннер на главной)
Время: 7.73 ms / 171.87 ms Память: 0.075 MB / 4.45 MB Application: afterRenderModule mod_articles_news (Баннер на главной)
Время: 0.19 ms / 172.06 ms Память: 0.000 MB / 4.41 MB Application: beforeRenderModule mod_custom (Контакты в шапке)
Время: 0.68 ms / 172.74 ms Память: 0.013 MB / 4.42 MB Application: afterRenderModule mod_custom (Контакты в шапке)
Время: 0.11 ms / 172.85 ms Память: 0.000 MB / 4.42 MB Application: beforeRenderModule mod_menu (Main Menu)
Время: 2.00 ms / 174.86 ms Память: 0.084 MB / 4.50 MB Application: afterRenderModule mod_menu (Main Menu)
Время: 28.46 ms / 203.31 ms Память: 0.083 MB / 4.59 MB Application: afterRender
Всего SQL-запросов: 40.41 ms
5.35 MB (5 613 088 Байт)
37 SQL-запросов зафиксировано 40.41 ms
- Время запроса: 0.57 ms Память запроса: 0.008 MB Память до запроса: 0.904 MB
DELETE
FROM `tyfh6_session`
WHERE `time` < '1696422409'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE tyfh6_session NULL range time time 59 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.28 ms init 0.01 ms System lock 0.03 ms updating 0.10 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:822 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:413 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Время запроса: 0.15 ms После последнего запроса: 0.36 ms Память запроса: 0.020 MB Память до запроса: 0.927 MB Выбрано строк: 0
SELECT `data`
FROM `tyfh6_session`
WHERE `session_id` = '1dcd8f5cda04b7ee020a6557a7b01428'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_session NULL const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Так же, как вызов в строке ниже. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:82 10 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:648 9 JSession->_start() JROOT/libraries/joomla/session/session.php:608 8 JSession->start() JROOT/libraries/joomla/session/session.php:486 7 JSession->get() JROOT/libraries/joomla/session/session.php:443 6 JSession->isNew() JROOT/libraries/cms/application/cms.php:829 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:413 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Время запроса: 0.12 ms После последнего запроса: 0.62 ms Память запроса: 0.012 MB Память до запроса: 0.980 MB Выбрано строк: 0
SELECT `session_id`
FROM `tyfh6_session`
WHERE `session_id` = '1dcd8f5cda04b7ee020a6557a7b01428'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_session NULL const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:831 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:413 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Время запроса: 0.29 ms После последнего запроса: 0.19 ms Память запроса: 0.009 MB Память до запроса: 0.995 MB
INSERT INTO `tyfh6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('1dcd8f5cda04b7ee020a6557a7b01428', 1, '1696423309', 0, '', 0)EXPLAIN не доступен для запроса: INSERT INTO `tyfh6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('1dcd8f5cda04b7ee020a6557a7b01428', 1, '1696423309', 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms update 0.10 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:216 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:831 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:413 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Время запроса: 1.19 ms После последнего запроса: 2.28 ms Память запроса: 0.019 MB Память до запроса: 1.194 MB Выбрано строк: 34
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tyfh6_extensions`
WHERE `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_extensions NULL ref extension extension 82 const 34 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.44 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.32 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:447 9 JComponentHelper::{closure}() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:455 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:111 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:593 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.69 ms После последнего запроса: 1.19 ms Память запроса: 0.014 MB Память до запроса: 1.280 MB Выбрано строк: 5
SELECT id, rules
FROM `tyfh6_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_viewlevels NULL ALL NULL Индекс не используется NULL NULL 5 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.35 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1486 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:1061 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:309 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.80 ms После последнего запроса: 0.18 ms Память запроса: 0.015 MB Память до запроса: 1.304 MB Выбрано строк: 2
SELECT b.id
FROM tyfh6_usergroups AS a
LEFT JOIN tyfh6_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.40 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:978 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:1093 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:309 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.58 ms После последнего запроса: 0.42 ms Память запроса: 0.020 MB Память до запроса: 1.342 MB Выбрано строк: 62
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM tyfh6_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_extensions NULL ref extension extension 82 const 78 0.60 Using index condition; Using where; Используется filesort Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.36 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:327 9 JPluginHelper::{closure}() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/plugin/helper.php:332 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 6.75 ms Память запроса: 0.016 MB Память до запроса: 1.865 MB Выбрано строк: 1
SELECT template
FROM tyfh6_template_styles
WHERE `client_id`=0
AND `home`=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_template_styles NULL ALL idx_home Индекс не используется NULL NULL 5 20.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.24 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 11 JDatabaseDriver->loadResult() JROOT/plugins/system/bagallery/bagallery.php:43 10 plgSystemBagallery->checkOverride() JROOT/plugins/system/bagallery/bagallery.php:26 9 plgSystemBagallery->onAfterInitialise() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:684 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:685 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.83 ms После последнего запроса: 1.33 ms Память запроса: 0.031 MB Память до запроса: 1.974 MB Выбрано строк: 22
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 tyfh6_menu AS m
LEFT JOIN tyfh6_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 32 3.33 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.m.component_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.25 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.32 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:88 17 JMenuSite->{closure}() Так же, как вызов в строке ниже. 16 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 15 JCacheControllerCallback->get() JROOT/libraries/cms/menu/site.php:96 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:129 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:444 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:59 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:198 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:549 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:402 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1145 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:795 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.25 ms После последнего запроса: 4.62 ms Память запроса: 0.020 MB Память до запроса: 2.302 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tyfh6_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 14 JDatabaseDriver->loadObject() JROOT/libraries/cms/library/helper.php:166 13 JLibraryHelper::{closure}() Так же, как вызов в строке ниже. 12 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:174 10 JLibraryHelper::loadLibrary() JROOT/libraries/cms/library/helper.php:42 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:89 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:270 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:760 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1023 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.24 ms После последнего запроса: 0.28 ms Память запроса: 0.012 MB Память до запроса: 2.303 MB
UPDATE `tyfh6_extensions`
SET `params` = '{\"mediaversion\":\"aeb1060eca73b7ca7c450da534ebcf50\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE tyfh6_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.04 ms updating 0.06 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:116 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:321 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:280 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:760 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1023 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.76 ms После последнего запроса: 0.70 ms Память запроса: 0.014 MB Память до запроса: 2.394 MB Выбрано строк: 1
SELECT *
FROM tyfh6_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_languages NULL ALL NULL Индекс не используется NULL NULL 2 50.00 Using where; Используется filesort Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.41 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:148 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:327 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.55 ms После последнего запроса: 0.44 ms Память запроса: 0.010 MB Память до запроса: 2.422 MB Выбрано строк: 3
SELECT id, home, template, s.params
FROM tyfh6_template_styles as s
LEFT JOIN tyfh6_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template Индекс не используется NULL NULL 5 20.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 omskngo_ngo2.s.template,const 1 4.56 Using index condition; Using where Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.00 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:485 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.39 ms После последнего запроса: 3.72 ms Память запроса: 0.029 MB Память до запроса: 2.692 MB Выбрано строк: 32
SELECT `id`,`name`,`rules`,`parent_id`
FROM `tyfh6_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_bagallery','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_assets NULL range idx_asset_name idx_asset_name 202 NULL 35 100.00 Using index condition Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.42 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.30 ms preparing 0.02 ms executing 0.00 ms Sending data 0.32 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:427 19 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:211 18 JAccess::preload() JROOT/libraries/joomla/access/access.php:529 17 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 16 JAccess::check() JROOT/libraries/joomla/user/user.php:393 15 JUser->authorise() JROOT/components/com_content/models/articles.php:113 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:42 13 ContentModelFeatured->populateState() JROOT/libraries/legacy/model/legacy.php:434 12 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:54 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.85 ms После последнего запроса: 1.49 ms Память запроса: 0.032 MB Память до запроса: 2.820 MB Выбрано строк: 2
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
INNER JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 12:41:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 12:41:49')
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 DESC
LIMIT 4id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fp NULL ALL PRIMARY Индекс не используется NULL NULL 2 100.00 Using temporary; Используется filesort 1 SIMPLE a NULL eq_ref PRIMARY,idx_access,idx_state,idx_catid PRIMARY 4 omskngo_ngo2.fp.content_id 1 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.modified_by 1 100.00 Using where 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 omskngo_ngo2.a.catid 1 10.00 Using where 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.c.parent_id 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where Status Duration starting 0.19 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.77 ms init 0.09 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms Creating tmp table 0.07 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.31 ms Creating sort index 0.06 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 16 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 15 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 14 JModelList->getItems() JROOT/components/com_content/models/articles.php:536 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:100 12 ContentModelFeatured->getItems() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:55 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.39 ms После последнего запроса: 1.31 ms Память запроса: 0.021 MB Память до запроса: 2.934 MB Выбрано строк: 1
SELECT COUNT(*)
FROM tyfh6_content AS a
INNER JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 12:41:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 12:41:49')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE fp NULL index PRIMARY PRIMARY 4 NULL 2 100.00 Using index 1 SIMPLE a NULL eq_ref PRIMARY,idx_access,idx_state,idx_catid PRIMARY 4 omskngo_ngo2.fp.content_id 1 16.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE c NULL eq_ref PRIMARY,idx_access PRIMARY 4 omskngo_ngo2.a.catid 1 10.00 Using where 1 SIMPLE parent NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.c.parent_id 1 100.00 Using where; Using index 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where; Using index Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:334 14 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:281 13 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:231 12 JModelList->getPagination() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.11 ms После последнего запроса: 4.72 ms Память запроса: 0.034 MB Память до запроса: 3.113 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 tyfh6_categories as c
LEFT JOIN tyfh6_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 s.id=8
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right Индекс не используется NULL NULL 12 41.66 Using where Status Duration starting 0.20 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.21 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.12 ms Creating sort index 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 21 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 20 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 19 JCategories->get() JROOT/administrator/components/com_fields/models/fields.php:197 18 FieldsModelFields->getListQuery() JROOT/libraries/legacy/model/list.php:132 17 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:186 16 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:98 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 2.65 ms После последнего запроса: 0.72 ms Память запроса: 0.032 MB Память до запроса: 3.152 MB Выбрано строк: 1
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM tyfh6_fields AS a
LEFT JOIN `tyfh6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tyfh6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tyfh6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tyfh6_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tyfh6_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL idx_state,idx_access,idx_context Индекс не используется NULL NULL 4 100.00 Using where; Using temporary; Используется filesort 1 SIMPLE l NULL ALL idx_langcode Индекс не используется NULL NULL 2 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 62.50 Using where; Using index Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.94 ms init 0.14 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.16 ms preparing 0.17 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.51 ms Creating sort index 0.07 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.09 ms freeing items 0.05 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 18 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:326 17 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 16 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:98 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.41 ms После последнего запроса: 0.83 ms Память запроса: 0.023 MB Память до запроса: 3.261 MB Выбрано строк: 1
SELECT `field_id`,`value`
FROM `tyfh6_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '428'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.21 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:703 16 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:156 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:98 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.36 ms После последнего запроса: 11.58 ms Память запроса: 0.023 MB Память до запроса: 3.530 MB Выбрано строк: 1
SELECT `field_id`,`value`
FROM `tyfh6_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '250'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:703 16 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:156 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/featured/view.html.php:98 10 ContentViewFeatured->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:389 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:364 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:265 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.33 ms После последнего запроса: 12.40 ms Память запроса: 0.022 MB Память до запроса: 3.728 MB Выбрано строк: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM tyfh6_modules AS m
LEFT JOIN tyfh6_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN tyfh6_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 <= '2023-10-04 12:41:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-04 12:41:49')
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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY,published,newsfeeds published 1 const 14 3.85 Using index condition; Using where; Используется filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 omskngo_ngo2.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 omskngo_ngo2.m.id 1 40.00 Using where; Using index Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.48 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.35 ms end 0.01 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 14 JDatabaseDriver->loadObjectList() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 12 JCacheControllerCallback->get() JROOT/libraries/cms/module/helper.php:424 11 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:360 10 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 9 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:576 8 JDocumentHtml->countModules() JROOT/templates/ngo/index.php:99 7 require JROOT/templates/ngo/index.php JROOT/libraries/joomla/document/html.php:653 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:715 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:530 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1102 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.67 ms После последнего запроса: 6.31 ms Память запроса: 0.032 MB Память до запроса: 3.928 MB Выбрано строк: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
LEFT JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (10)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 12:41:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 12:41:49')
ORDER BY a.publish_up DESC
LIMIT 40id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using temporary; Используется filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 9 16.00 Using where 1 SIMPLE fp NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where; Using index 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL ALL PRIMARY Индекс не используется NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.22 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.11 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.12 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.46 ms Creating sort index 0.11 ms end 0.00 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.01 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 13 JModelList->getItems() JROOT/components/com_content/models/articles.php:536 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_news/helper.php:94 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.55 ms После последнего запроса: 1.95 ms Память запроса: 0.037 MB Память до запроса: 4.093 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 tyfh6_categories as c
LEFT JOIN tyfh6_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 s.id=10
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right Индекс не используется NULL NULL 12 41.66 Using where Status Duration starting 0.11 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 22 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 21 JCategories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 18 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 17 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 16 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 15 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_articles_news/helper.php:107 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.55 ms После последнего запроса: 0.83 ms Память запроса: 0.037 MB Память до запроса: 4.130 MB Выбрано строк: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM tyfh6_fields AS a
LEFT JOIN `tyfh6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tyfh6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tyfh6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tyfh6_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tyfh6_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_articles_news.content'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_context 766 const 1 100.00 Using where; Используется filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 omskngo_ngo2.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 62.50 Using where; Using index Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.05 ms Sorting result 0.02 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 24 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 23 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:326 22 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 21 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 20 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 19 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 18 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 15 JHtmlContent::prepare() Так же, как вызов в строке ниже. 14 call_user_func_array() JROOT/libraries/cms/html/html.php:233 13 JHtml::call() JROOT/libraries/cms/html/html.php:140 12 JHtml::_() JROOT/modules/mod_articles_news/helper.php:117 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 2.96 ms После последнего запроса: 2.94 ms Память запроса: 0.032 MB Память до запроса: 4.041 MB Выбрано строк: 3
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
LEFT JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (13)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 12:41:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 12:41:49')
ORDER BY a.created DESC
LIMIT 3id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using temporary; Используется filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 16 16.00 Using where 1 SIMPLE fp NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where; Using index 1 SIMPLE ua NULL ALL PRIMARY Индекс не используется NULL NULL 3 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL ALL PRIMARY Индекс не используется NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.34 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.17 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.27 ms preparing 0.25 ms Creating tmp table 0.12 ms Sorting result 0.01 ms executing 0.00 ms Sending data 1.10 ms Creating sort index 0.15 ms end 0.01 ms query end 0.01 ms removing tmp table 0.07 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.06 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 13 JModelList->getItems() JROOT/components/com_content/models/articles.php:536 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:116 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.45 ms После последнего запроса: 2.75 ms Память запроса: 0.037 MB Память до запроса: 4.152 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 tyfh6_categories as c
LEFT JOIN tyfh6_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 s.id=13
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right Индекс не используется NULL NULL 12 41.66 Using where Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 22 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 21 JCategories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 18 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 17 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 16 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 15 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_articles_latest/helper.php:128 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.65 ms После последнего запроса: 2.36 ms Память запроса: 0.032 MB Память до запроса: 4.108 MB Выбрано строк: 3
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
LEFT JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (12)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 12:41:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 12:41:49')
ORDER BY a.created DESC
LIMIT 3id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid idx_catid 4 const 4 16.00 Using index condition; Using where 1 SIMPLE fp NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where; Using index 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.07 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.15 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 13 JModelList->getItems() JROOT/components/com_content/models/articles.php:536 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_latest/helper.php:116 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.37 ms После последнего запроса: 1.15 ms Память запроса: 0.037 MB Память до запроса: 4.219 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 tyfh6_categories as c
LEFT JOIN tyfh6_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 s.id=12
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right Индекс не используется NULL NULL 12 41.66 Using where Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:304 22 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 21 JCategories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Так же, как вызов в строке ниже. 19 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 18 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 17 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 16 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 15 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_articles_latest/helper.php:128 11 ModArticlesLatestHelper::getList() JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 10 include JROOT/modules/mod_articles_latest/mod_articles_latest.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 12.44 ms После последнего запроса: 4.39 ms Память запроса: 0.041 MB Память до запроса: 4.237 MB Выбрано строк: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
LEFT JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.featured = 0
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 12:41:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 12:41:49')
ORDER BY a.publish_up DESC
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Using temporary; Используется filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 5 const,const 436 16.00 Using where 1 SIMPLE fp NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where; Using index 1 SIMPLE ua NULL ALL PRIMARY Индекс не используется NULL NULL 3 100.00 Using where; Using join buffer (Block Nested Loop) 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL ALL PRIMARY Индекс не используется NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) Status Duration starting 0.14 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.15 ms Creating tmp table 0.07 ms Sorting result 0.01 ms executing 0.00 ms Sending data 11.06 ms Creating sort index 0.39 ms end 0.00 ms query end 0.01 ms removing tmp table 0.20 ms query end 0.00 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 13 JModelList->getItems() JROOT/components/com_content/models/articles.php:536 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_news/helper.php:94 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.25 ms После последнего запроса: 4.22 ms Память запроса: 0.026 MB Память до запроса: 4.420 MB Выбрано строк: 1
SELECT `field_id`,`value`
FROM `tyfh6_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '485'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:703 18 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:156 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 16 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 12 JApplicationBase->triggerEvent() JROOT/modules/mod_articles_news/helper.php:127 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.46 ms После последнего запроса: 6.71 ms Память запроса: 0.026 MB Память до запроса: 4.452 MB Выбрано строк: 1
SELECT `field_id`,`value`
FROM `tyfh6_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '487'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:703 18 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:156 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 16 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 12 JApplicationBase->triggerEvent() JROOT/modules/mod_articles_news/helper.php:127 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.53 ms После последнего запроса: 5.63 ms Память запроса: 0.026 MB Память до запроса: 4.484 MB Выбрано строк: 1
SELECT `field_id`,`value`
FROM `tyfh6_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '486'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.05 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:703 18 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:156 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 16 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 12 JApplicationBase->triggerEvent() JROOT/modules/mod_articles_news/helper.php:127 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 5.41 ms Память запроса: 0.026 MB Память до запроса: 4.516 MB Выбрано строк: 1
SELECT `field_id`,`value`
FROM `tyfh6_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '484'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:703 18 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:156 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 16 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 12 JApplicationBase->triggerEvent() JROOT/modules/mod_articles_news/helper.php:127 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.52 ms После последнего запроса: 5.32 ms Память запроса: 0.026 MB Память до запроса: 4.548 MB Выбрано строк: 1
SELECT `field_id`,`value`
FROM `tyfh6_fields_values`
WHERE `field_id` IN (1)
AND `item_id` = '483'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_fields_values NULL ref idx_field_id,idx_item_id idx_item_id 766 const 1 100.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.03 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:703 18 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:156 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 16 PlgSystemFields->onContentPrepare() Так же, как вызов в строке ниже. 15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 12 JApplicationBase->triggerEvent() JROOT/modules/mod_articles_news/helper.php:127 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 1.26 ms После последнего запроса: 6.63 ms Память запроса: 0.031 MB Память до запроса: 4.420 MB Выбрано строк: 1
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
LEFT JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.featured = 1
AND a.catid IN (8)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 12:41:49')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 12:41:49')
ORDER BY a.publish_up DESC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Используется filesort 1 SIMPLE a NULL ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 5 const,const 2 16.00 Using index condition; Using where 1 SIMPLE fp NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where; Using index 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.created_by 1 100.00 Using where 1 SIMPLE uam NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.modified_by 1 100.00 Using where 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 SIMPLE v NULL eq_ref PRIMARY PRIMARY 4 omskngo_ngo2.a.id 1 100.00 Using where Status Duration starting 0.43 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.12 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.15 ms end 0.00 ms query end 0.01 ms closing tables 0.05 ms freeing items 0.04 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 14 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 13 JModelList->getItems() JROOT/components/com_content/models/articles.php:536 12 ContentModelArticles->getItems() JROOT/modules/mod_articles_news/helper.php:94 11 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15 10 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/libraries/cms/module/helper.php:198 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:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Время запроса: 0.59 ms После последнего запроса: 9.30 ms Память запроса: 0.024 MB Память до запроса: 4.506 MB Выбрано строк: 32
SELECT id, url, title, lightboxUrl, form_id
FROM tyfh6_bagallery_itemsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tyfh6_bagallery_items NULL ALL NULL Индекс не используется NULL NULL 32 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.31 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 16 JDatabaseDriver->loadObjectList() JROOT/components/com_bagallery/helpers/bagallery.php:159 15 bagalleryHelper::checkImage() JROOT/components/com_bagallery/helpers/bagallery.php:30 14 bagalleryHelper::addStyle() JROOT/plugins/system/bagallery/bagallery.php:71 13 plgSystemBagallery->onBeforeCompileHead() Так же, как вызов в строке ниже. 12 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 9 JApplicationBase->triggerEvent() JROOT/libraries/joomla/document/renderer/html/head.php:63 8 JDocumentRendererHtmlHead->fetchHead() JROOT/libraries/joomla/document/renderer/html/head.php:34 7 JDocumentRendererHtmlHead->render() JROOT/libraries/joomla/document/html.php:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1116 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49
22 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
7 × SELECT `field_id`,`value`
FROM `tyfh6_fields_values`5 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
LEFT JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id4 × 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 tyfh6_categories as c
LEFT JOIN tyfh6_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tyfh6_extensions`2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM tyfh6_fields AS a
LEFT JOIN `tyfh6_languages` AS l
ON l.lang_code = a.language
LEFT JOIN tyfh6_users AS uc
ON uc.id=a.checked_out
LEFT JOIN tyfh6_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN tyfh6_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `tyfh6_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT COUNT(*)
FROM tyfh6_content AS a
INNER JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM tyfh6_content AS a
INNER JOIN tyfh6_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN tyfh6_categories AS c
ON c.id = a.catid
LEFT JOIN tyfh6_users AS ua
ON ua.id = a.created_by
LEFT JOIN tyfh6_users AS uam
ON uam.id = a.modified_by
LEFT JOIN tyfh6_categories as parent
ON parent.id = c.parent_id
LEFT JOIN tyfh6_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM tyfh6_modules AS m
LEFT JOIN tyfh6_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN tyfh6_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id, url, title, lightboxUrl, form_id
FROM tyfh6_bagallery_item1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `tyfh6_assets`1 × SELECT id, home, template, s.params
FROM tyfh6_template_styles as s
LEFT JOIN tyfh6_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT b.id
FROM tyfh6_usergroups AS a
LEFT JOIN tyfh6_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `tyfh6_viewlevels1 × SELECT `session_id`
FROM `tyfh6_session`1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM tyfh6_extensions1 × SELECT template
FROM tyfh6_template_styles1 × SELECT *
FROM tyfh6_languages1 × 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 tyfh6_menu AS m
LEFT JOIN tyfh6_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `tyfh6_session`
Прочие SQL-запросы:
1 × UPDATE `tyfh6_extensions`
SET `params` = '{\"mediaversion\":\"aeb1060eca73b7ca7c450da534ebcf50\"}'1 × INSERT INTO `tyfh6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('1dcd8f5cda04b7ee020a6557a7b01428', 1, '1696423309', 0, '', 01 × DELETE
FROM `tyfh6_session`