- Автор: Лілія Ярославівна
- Категорія: МО вчителів початкових класів
- Опубліковано: 31 грудня 2021
- Перегляди: 193
МО вчителів початкових класів
- Автор: Іванна Романівна
- Категорія: МО вчителів початкових класів
- Опубліковано: 30 грудня 2021
- Перегляди: 263
Вітаємо нашу колегу, вчителя початкової школи - Серман Оксану Богданівну з успішним проходженням сертифікації.
- Автор: Лілія Ярославівна
- Категорія: МО вчителів початкових класів
- Опубліковано: 11 червня 2021
- Перегляди: 214
Початкова школа позаду. Та не лише для четвертокласників, але і для їхніх батьків. Протягом усього навчання поряд з вами, діти, були батьки та вчителі. Вони жили вашими радощами і негараздами.
- Автор: Лілія Ярославівна
- Категорія: МО вчителів початкових класів
- Опубліковано: 11 червня 2021
- Перегляди: 255
Ось і промайнуло 4 роки навчання у початковій школі. Попереду літо і багато цікавих подорожей, знайомств і незабутніх вражень.Останнім заняттям у школярів 4-В класу була квест-гра "Добре тому жити, хто вміє дружити".
- Автор: Лілія Ярославівна
- Категорія: МО вчителів початкових класів
- Опубліковано: 03 червня 2021
- Перегляди: 268
Учні 3-Г класу узагальнили здобуті знання за допомогою гри "Хто зверху?". Час провели весело та цікаво.
- Автор: Лілія Ярославівна
- Категорія: МО вчителів початкових класів
- Опубліковано: 02 червня 2021
- Перегляди: 229
Наближаються літні канікули, тож учні 4-Г класу Калуського ліцею №3 вирішили обговорити питання екології у нашому місті.
Консоль налагодження Joomla
{ "__default": { "session": { "counter": 1, "timer": { "start": 1710841218, "last": 1710841218, "now": 1710841218 }, "client": { "forwarded": "34.230.84.106" }, "token": "ugBvD28YuNtKKFbnElebczsBFjpohTme" }, "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 } } }
Час
Пам'ять
32 запитів для зареєстрованих користувачів 40.62 ms
- Витрачений час на запит: 0.93 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 4.897 MB Повернуто рядків: 0
SELECT `data`
FROM `e0lsd_session`
WHERE `session_id` = X'6571387361346161387139337363696c346f716d376163743430'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.02 ms Opening tables 0.44 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms executing 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Такий самий, як і виклик у нижньому рядку. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:59 - Витрачений час на запит: 0.30 ms Після останнього запиту: 3.09 ms Запит пам'яті: 0.013 MB пам'ять до запиту: 5.072 MB Повернуто рядків: 0
SELECT `session_id`
FROM `e0lsd_session`
WHERE `session_id` = X'6571387361346161387139337363696c346f716d376163743430'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:59 - Витрачений час на запит: 0.55 ms Після останнього запиту: 0.30 ms Запит пам'яті: 0.010 MB пам'ять до запиту: 5.090 MB
INSERT INTO `e0lsd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6571387361346161387139337363696c346f716d376163743430', 1, 1710841218, 0, '', 0)EXPLAIN не можливий для запиту: INSERT INTO `e0lsd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6571387361346161387139337363696c346f716d376163743430', 1, 1710841218, 0, '', 0)Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.24 ms end 0.01 ms query end 0.08 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:856 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:59 - Витрачений час на запит: 1.29 ms Після останнього запиту: 6.18 ms Запит пам'яті: 0.020 MB пам'ять до запиту: 5.431 MB Повернуто рядків: 36
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `e0lsd_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_extensions NULL ref extension extension 82 const 38 1.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.34 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.45 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Такий самий, як і виклик у нижньому рядку. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.57 ms Після останнього запиту: 4.95 ms Запит пам'яті: 0.015 MB пам'ять до запиту: 5.731 MB Повернуто рядків: 4
SELECT id, rules
FROM `e0lsd_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_viewlevels NULL ALL NULL ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 4 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.24 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.71 ms Після останнього запиту: 0.28 ms Запит пам'яті: 0.015 MB пам'ять до запиту: 5.756 MB Повернуто рядків: 1
SELECT b.id
FROM e0lsd_usergroups AS a
LEFT JOIN e0lsd_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 100.00 Using where; Using index Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 1.89 ms Після останнього запиту: 1.53 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 5.859 MB Повернуто рядків: 79
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM e0lsd_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_extensions NULL ref extension extension 82 const 130 0.40 Using index condition; Using where; Використовуючи filesort Status Duration starting 0.08 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.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 1.42 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Такий самий, як і виклик у нижньому рядку. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.52 ms Після останнього запиту: 25.86 ms Запит пам'яті: 0.024 MB пам'ять до запиту: 7.624 MB Повернуто рядків: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `e0lsd_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 16 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Такий самий, як і виклик у нижньому рядку. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 13 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 12 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 11 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ytshortcodes/ytshortcodes.php:36 7 plgSystemYtshortcodes->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.36 ms Після останнього запиту: 0.31 ms Запит пам'яті: 0.016 MB пам'ять до запиту: 7.631 MB
UPDATE `e0lsd_extensions`
SET `params` = '{\"mediaversion\":\"582d76cf3e505c984e69f2cc444491bb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE e0lsd_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.06 ms updating 0.09 ms end 0.01 ms query end 0.06 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 12 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 11 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 10 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 9 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 8 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/ytshortcodes/ytshortcodes.php:36 7 plgSystemYtshortcodes->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 2.70 ms Після останнього запиту: 26.84 ms Запит пам'яті: 0.046 MB пам'ять до запиту: 10.283 MB Повернуто рядків: 115
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 e0lsd_menu AS m
LEFT JOIN e0lsd_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 range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 124 10.00 Using index condition; Using where; Використовуючи filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 kk03.m.component_id 1 100.00 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.35 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.55 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Такий самий, як і виклик у нижньому рядку. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:445 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:561 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1169 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.68 ms Після останнього запиту: 13.27 ms Запит пам'яті: 0.014 MB пам'ять до запиту: 11.885 MB Повернуто рядків: 1
SELECT *
FROM e0lsd_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_languages NULL ALL NULL ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where; Використовуючи filesort Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.29 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.56 ms Після останнього запиту: 0.46 ms Запит пам'яті: 0.010 MB пам'ять до запиту: 11.919 MB Повернуто рядків: 2
SELECT id, home, template, s.params
FROM e0lsd_template_styles as s
LEFT JOIN e0lsd_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 e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 3 1.67 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 kk03.e.element 1 66.67 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 1.21 ms Після останнього запиту: 10.74 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 13.141 MB Повернуто рядків: 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `e0lsd_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_ckeditor','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_nextend_installer','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_assets NULL range idx_asset_name idx_asset_name 202 NULL 37 100.00 Using index condition Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.05 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.01 ms executing 0.00 ms Sending data 0.45 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 2.02 ms Після останнього запиту: 1.10 ms Запит пам'яті: 0.079 MB пам'ять до запиту: 13.225 MB Повернуто рядків: 1352
SELECT `id`,`name`,`rules`,`parent_id`
FROM `e0lsd_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_assets NULL ALL idx_asset_name,idx_parent_id ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1456 20.57 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 1.53 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 1.70 ms Після останнього запиту: 7.61 ms Запит пам'яті: 0.030 MB пам'ять до запиту: 15.302 MB Повернуто рядків: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `e0lsd_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `e0lsd_categories` AS `s`
INNER JOIN `e0lsd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 129
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Використовуючи filesort 1 PRIMARY c NULL ALL cat_idx,idx_left_right ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 201 35.99 Using where 2 DEPENDENT SUBQUERY i NULL ref idx_state,idx_catid idx_catid 4 kk03.c.id 13 61.30 Using index condition; Using where Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.44 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms Creating sort index 0.23 ms executing 0.01 ms Sending data 0.03 ms executing 0.00 ms Sending data 0.06 ms executing 0.01 ms Sending data 0.29 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 11.65 ms Після останнього запиту: 3.27 ms Запит пам'яті: 0.039 MB пам'ять до запиту: 15.646 MB Повернуто рядків: 6
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM e0lsd_content AS a
LEFT JOIN e0lsd_categories AS c
ON c.id = a.catid
LEFT JOIN e0lsd_users AS ua
ON ua.id = a.created_by
LEFT JOIN e0lsd_users AS uam
ON uam.id = a.modified_by
LEFT JOIN e0lsd_categories as parent
ON parent.id = c.parent_id
LEFT JOIN e0lsd_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 129 OR a.catid IN ( SELECT sub.id
FROM e0lsd_categories as sub
INNER JOIN e0lsd_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 129
AND sub.level <= this.level + 1))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-19 09:40:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-19 09:40:19')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 6id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c NULL ALL PRIMARY,idx_access ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 201 10.00 Using where; Using temporary; Використовуючи filesort 1 PRIMARY a NULL ref idx_access,idx_state,idx_catid idx_catid 4 kk03.c.id 13 7.73 Using index condition; Using where 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 kk03.a.created_by 1 100.00 Using where 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 kk03.a.modified_by 1 100.00 Using where 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 kk03.c.parent_id 1 100.00 Using where 1 PRIMARY v NULL ALL PRIMARY ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 2 SUBQUERY this NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 2 SUBQUERY sub NULL ALL PRIMARY,idx_left_right ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 201 3.87 Using where Status Duration starting 0.19 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.00 ms checking permissions 0.01 ms Opening tables 0.37 ms init 0.10 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.05 ms Creating tmp table 0.11 ms Sorting result 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.16 ms executing 0.01 ms Sending data 9.89 ms Creating sort index 0.18 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms removing tmp table 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:189 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.74 ms Після останнього запиту: 2.47 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 15.974 MB Повернуто рядків: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1199
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kk03.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.33 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.04 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.29 ms Після останнього запиту: 0.41 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 16.016 MB Повернуто рядків: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1197
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kk03.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 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.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.29 ms Після останнього запиту: 0.40 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 16.059 MB Повернуто рядків: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1113
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kk03.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.28 ms Після останнього запиту: 0.38 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 16.101 MB Повернуто рядків: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1112
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kk03.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.29 ms Після останнього запиту: 0.40 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 16.143 MB Повернуто рядків: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1104
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kk03.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 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.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.28 ms Після останнього запиту: 0.38 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 16.185 MB Повернуто рядків: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1102
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kk03.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 15 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 5.84 ms Після останнього запиту: 1.49 ms Запит пам'яті: 0.024 MB пам'ять до запиту: 16.359 MB Повернуто рядків: 1
SELECT COUNT(*)
FROM e0lsd_content AS a
LEFT JOIN e0lsd_categories AS c
ON c.id = a.catid
LEFT JOIN e0lsd_users AS ua
ON ua.id = a.created_by
LEFT JOIN e0lsd_users AS uam
ON uam.id = a.modified_by
LEFT JOIN e0lsd_categories as parent
ON parent.id = c.parent_id
LEFT JOIN e0lsd_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 129 OR a.catid IN ( SELECT sub.id
FROM e0lsd_categories as sub
INNER JOIN e0lsd_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 129
AND sub.level <= this.level + 1))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-19 09:40:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-19 09:40:19')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c NULL ALL PRIMARY,idx_access ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 201 10.00 Using where 1 PRIMARY a NULL ref idx_access,idx_state,idx_catid idx_catid 4 kk03.c.id 13 7.73 Using index condition; Using where 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 kk03.a.created_by 1 100.00 Using where; Using index 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 kk03.a.modified_by 1 100.00 Using where; Using index 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 kk03.c.parent_id 1 100.00 Using where; Using index 1 PRIMARY v NULL eq_ref PRIMARY PRIMARY 4 kk03.a.id 1 100.00 Using where; Using index 2 SUBQUERY this NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 2 SUBQUERY sub NULL ALL PRIMARY,idx_left_right ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 201 3.87 Using where Status Duration starting 0.10 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.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.03 ms executing 0.01 ms Sending data 0.19 ms executing 0.01 ms Sending data 4.99 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms removing tmp table 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Виклик Номер файлу та рядка 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:284 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:234 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.34 ms Після останнього запиту: 0.53 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 16.371 MB Повернуто рядків: 0
SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 129
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kk03.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.76 ms Після останнього запиту: 7.35 ms Запит пам'яті: 0.034 MB пам'ять до запиту: 17.167 MB Повернуто рядків: 3
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 `e0lsd_categories` AS `s`
INNER JOIN `e0lsd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 129
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 201 35.99 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.24 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:135 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:189 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 1.23 ms Після останнього запиту: 0.41 ms Запит пам'яті: 0.032 MB пам'ять до запиту: 17.214 MB Повернуто рядків: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM e0lsd_fields AS a
LEFT JOIN `e0lsd_languages` AS l
ON l.lang_code = a.language
LEFT JOIN e0lsd_users AS uc
ON uc.id=a.checked_out
LEFT JOIN e0lsd_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN e0lsd_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN e0lsd_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `e0lsd_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 (129,0,117))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Використовуючи filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 kk03.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 kk03.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 kk03.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 kk03.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 kk03.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 kk03.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.09 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.48 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.17 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:189 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 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/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.32 ms Після останнього запиту: 115.96 ms Запит пам'яті: 0.017 MB пам'ять до запиту: 22.761 MB Повернуто рядків: 1
SELECT template_style_id
FROM e0lsd_menu
WHERE id = 823id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 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:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:121 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:31 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/sj_teen/includes/frame_inc.php:37 8 include_once JROOT/templates/sj_teen/includes/frame_inc.php JROOT/templates/sj_teen/index.php:25 7 require JROOT/templates/sj_teen/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.26 ms Після останнього запиту: 0.11 ms Запит пам'яті: 0.017 MB пам'ять до запиту: 22.778 MB Повернуто рядків: 1
SELECT id
FROM e0lsd_template_styles
WHERE home = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id_home 1 const 2 33.33 Using where; Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 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:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:125 10 YtFrameworkTemplate->isOverrideTemplate() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:31 9 YtFrameworkTemplate->YtFrameworkTemplate() JROOT/templates/sj_teen/includes/frame_inc.php:37 8 include_once JROOT/templates/sj_teen/includes/frame_inc.php JROOT/templates/sj_teen/index.php:25 7 require JROOT/templates/sj_teen/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 1.19 ms Після останнього запиту: 2.09 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 22.954 MB Повернуто рядків: 8
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM e0lsd_modules AS m
LEFT JOIN e0lsd_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN e0lsd_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-03-19 09:40:19')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-19 09:40:19')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 823 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 range PRIMARY,published,newsfeeds published 6 NULL 17 1.60 Using index condition; Using where; Використовуючи filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 kk03.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 kk03.m.id 24 40.00 Using where; Using index Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.36 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.41 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Такий самий, як і виклик у нижньому рядку. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:188 11 YtFrameworkRenderXML->getBlocks() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:115 10 YtFrameworkRenderXML->getTagBody() JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49 9 YtFrameworkRenderXML->YtFrameworkRenderXML() JROOT/templates/sj_teen/includes/frame_inc.php:80 8 include_once JROOT/templates/sj_teen/includes/frame_inc.php JROOT/templates/sj_teen/index.php:25 7 require JROOT/templates/sj_teen/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.22 ms Після останнього запиту: 4.43 ms Запит пам'яті: 0.014 MB пам'ять до запиту: 23.453 MB Повернуто рядків: 1Дублі запитів: #31
SELECT home
FROM e0lsd_menu
WHERE id=823id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:110 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_teen/index.php:52 7 require JROOT/templates/sj_teen/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.20 ms Після останнього запиту: 0.08 ms Запит пам'яті: 0.014 MB пам'ять до запиту: 23.467 MB Повернуто рядків: 1Дублі запитів: #30
SELECT home
FROM e0lsd_menu
WHERE id=823id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/includes/site/lib/yt_template.php:111 8 YtFrameworkTemplate->isHomePage() JROOT/templates/sj_teen/index.php:52 7 require JROOT/templates/sj_teen/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1126 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62 - Витрачений час на запит: 0.43 ms Після останнього запиту: 29.81 ms Запит пам'яті: 0.015 MB пам'ять до запиту: 24.047 MB Повернуто рядків: 1
SELECT template
FROM e0lsd_template_styles
WHERE home = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e0lsd_template_styles NULL ref idx_client_id,idx_client_id_home idx_client_id 1 const 2 33.33 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Виклик Номер файлу та рядка 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/yt/yt.php:207 9 plgSystemYt->nameOfSJTemplate() JROOT/plugins/system/yt/yt.php:111 8 plgSystemYt->onBeforeRender() Такий самий, як і виклик у нижньому рядку. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1130 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:62
23 типи запитів: зареєстрований, відсортований за знайденим
Вибірка таблиць:
7 × SELECT `m`.`tag_id`,`t`.*
FROM `e0lsd_contentitem_tag_map` AS m
INNER JOIN `e0lsd_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `e0lsd_assets`2 × SELECT home
FROM e0lsd_menu2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `e0lsd_extensions`1 × 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 `e0lsd_categories` AS `s`
INNER JOIN `e0lsd_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT COUNT(*)
FROM e0lsd_content AS a
LEFT JOIN e0lsd_categories AS c
ON c.id = a.catid
LEFT JOIN e0lsd_users AS ua
ON ua.id = a.created_by
LEFT JOIN e0lsd_users AS uam
ON uam.id = a.modified_by
LEFT JOIN e0lsd_categories as parent
ON parent.id = c.parent_id
LEFT JOIN e0lsd_content_rating AS v
ON a.id = v.content_id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM e0lsd_fields AS a
LEFT JOIN `e0lsd_languages` AS l
ON l.lang_code = a.language
LEFT JOIN e0lsd_users AS uc
ON uc.id=a.checked_out
LEFT JOIN e0lsd_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN e0lsd_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN e0lsd_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `e0lsd_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT id
FROM e0lsd_template_styles1 × SELECT template
FROM e0lsd_template_styles1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM e0lsd_modules AS m
LEFT JOIN e0lsd_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN e0lsd_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT template_style_id
FROM e0lsd_menu1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `e0lsd_content` AS `i`1 × SELECT b.id
FROM e0lsd_usergroups AS a
LEFT JOIN e0lsd_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `e0lsd_viewlevels1 × SELECT `session_id`
FROM `e0lsd_session`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM e0lsd_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM e0lsd_menu AS m
LEFT JOIN e0lsd_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `e0lsd_session`1 × SELECT id, home, template, s.params
FROM e0lsd_template_styles as s
LEFT JOIN e0lsd_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM e0lsd_languages1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM e0lsd_content AS a
LEFT JOIN e0lsd_categories AS c
ON c.id = a.catid
LEFT JOIN e0lsd_users AS ua
ON ua.id = a.created_by
LEFT JOIN e0lsd_users AS uam
ON uam.id = a.modified_by
LEFT JOIN e0lsd_categories as parent
ON parent.id = c.parent_id
LEFT JOIN e0lsd_content_rating AS v
ON a.id = v.content_id
Інші таблиці:
1 × UPDATE `e0lsd_extensions`
SET `params` = '{\"mediaversion\":\"582d76cf3e505c984e69f2cc444491bb\"}'1 × INSERT INTO `e0lsd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6571387361346161387139337363696c346f716d376163743430', 1, 1710841218, 0, '', 0