Настройки отображения
Параметры шрифта:
Выберите шрифт Arial Times New Roman
Интервал между символами (кернинг): Стандартный Средний Большой
Выбор цветовой схемы:
Новости
Челябинский государственный университет приглашает присоединиться к бесплатному проекту института довузовского образования «Воскресный университет».
Консоль отладки Joomla
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1702159283,
"last": 1702159283,
"now": 1702159283
},
"client": {
"forwarded": "3.80.4.147"
},
"token": "NUYOUBzB8zLI9avPrv4vfUR4HjYPQ5LO"
},
"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
}
}
}
Время
Память
Время: 5.45 ms / 5.45 ms Память: 2.443 MB / 2.83 MB Application: afterLoad
Время: 102.54 ms / 107.99 ms Память: 5.101 MB / 7.93 MB Application: afterInitialise
Время: 86.67 ms / 194.66 ms Память: 1.991 MB / 9.92 MB Application: afterRoute
Время: 5.83 ms / 200.49 ms Память: 0.035 MB / 9.95 MB Application: beforeRenderComponent com_content
Время: 2.30 ms / 202.79 ms Память: 0.699 MB / 10.65 MB Application: Before Access::preloadComponents (all components)
Время: 6.04 ms / 208.83 ms Память: 0.061 MB / 10.71 MB Application: After Access::preloadComponents (all components)
Время: 0.05 ms / 208.87 ms Память: -0.004 MB / 10.71 MB Application: Before Access::preloadPermissions (com_content)
Время: 45.59 ms / 254.47 ms Память: 2.023 MB / 12.73 MB Application: After Access::preloadPermissions (com_content)
Время: 0.13 ms / 254.59 ms Память: -0.128 MB / 12.60 MB Application: Before Access::getAssetRules (id:38 name:com_content.category.62)
Время: 0.41 ms / 255.01 ms Память: 0.010 MB / 12.61 MB Application: After Access::getAssetRules (id:38 name:com_content.category.62)
Время: 6.81 ms / 261.82 ms Память: 0.338 MB / 12.95 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Время: 0.06 ms / 261.88 ms Память: 0.007 MB / 12.96 MB Application: After Access::getAssetRules (id:8 name:com_content)
Время: 100.21 ms / 362.08 ms Память: 2.169 MB / 15.13 MB Application: afterRenderComponent com_content
Время: 0.36 ms / 362.44 ms Память: 0.006 MB / 15.13 MB Application: afterDispatch
Время: 23.31 ms / 385.75 ms Память: 1.178 MB / 16.31 MB Application: afterRender
Всего запросов к базе данных: 271.45 ms
16.63 MB (17 441 120 Байт)
28 запросов зарегистрировано 271.45 ms
- Время запроса: 3.71 ms Память запроса: 0.023 MB. Память перед запросом: 4.508 MB Возвращено строк: 0
SELECT `data`
FROM `jupf25_session`
WHERE `session_id` = X'697673356b706a73733262746f38696763716c386b7264373475'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_session const PRIMARY PRIMARY 194 const 1 Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.05 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 4.68 ms После последнего запроса: 0.59 ms Память запроса: 0.020 MB. Память перед запросом: 4.825 MB Возвращено строк: 0
SELECT `session_id`
FROM `jupf25_session`
WHERE `session_id` = X'697673356b706a73733262746f38696763716c386b7264373475'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 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:828 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 4.28 ms После последнего запроса: 0.12 ms Память запроса: 0.004 MB. Память перед запросом: 4.830 MB
INSERT INTO `jupf25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'697673356b706a73733262746f38696763716c386b7264373475', 1, 1702159283, 0, '', 0)EXPLAIN недоступен для: INSERT INTO `jupf25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'697673356b706a73733262746f38696763716c386b7264373475', 1, 1702159283, 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.00 ms init 0.01 ms update 0.18 ms Waiting for query cache lock 0.00 ms update 0.00 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms logging slow query 0.00 ms cleaning up 0.00 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:828 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 4.59 ms После последнего запроса: 2.18 ms Память запроса: 0.025 MB. Память перед запросом: 4.979 MB Возвращено строк: 46
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jupf25_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_extensions ref extension extension 82 const 46 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 ms System lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.25 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 5.39 ms После последнего запроса: 0.95 ms Память запроса: 0.021 MB. Память перед запросом: 5.314 MB Возвращено строк: 4
SELECT id, rules
FROM `jupf25_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_viewlevels ALL NULL INDEX KEY не используется NULL NULL 4 Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 4.87 ms После последнего запроса: 0.11 ms Память запроса: 0.021 MB. Память перед запросом: 5.326 MB Возвращено строк: 1
SELECT b.id
FROM jupf25_usergroups AS a
LEFT JOIN jupf25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms System lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 6.26 ms После последнего запроса: 0.27 ms Память запроса: 0.030 MB. Память перед запросом: 5.348 MB Возвращено строк: 105
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jupf25_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_extensions ref extension extension 82 const 151 Using where; Используется сортировка файлов Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.48 ms Sending data 0.30 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 59.85 ms После последнего запроса: 15.66 ms Память запроса: 0.238 MB. Память перед запросом: 7.958 MB Возвращено строк: 134
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 jupf25_menu AS m
LEFT JOIN jupf25_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 258 Using where; Используется сортировка файлов 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 gb_new88.m.component_id 1 Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms System lock 0.02 ms init 0.06 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.91 ms Sending data 32.55 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 8.72 ms logging slow query 0.01 ms cleaning up 0.01 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Такой же, как вызов в строке ниже 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php: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:417 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:533 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:1141 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:49 - Время запроса: 4.82 ms После последнего запроса: 6.16 ms Память запроса: 0.025 MB. Память перед запросом: 9.257 MB Возвращено строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jupf25_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Такой же, как вызов в строке ниже 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:49 - Время запроса: 3.37 ms После последнего запроса: 0.20 ms Память запроса: 0.006 MB. Память перед запросом: 9.250 MB
UPDATE `jupf25_extensions`
SET `params` = '{\"mediaversion\":\"7e64b4a429e5c16613fcc7910b64f420\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN недоступен для: UPDATE `jupf25_extensions` SET `params` = '{\"mediaversion\":\"7e64b4a429e5c16613fcc7910b64f420\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.10 ms Updating 0.09 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jcomments/jcomments.php:111 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:49 - Время запроса: 3.96 ms После последнего запроса: 1.08 ms Память запроса: 0.032 MB. Память перед запросом: 9.599 MB Возвращено строк: 91
SELECT *
FROM `jupf25_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_jcomments_settings ref PRIMARY PRIMARY 214 const,const 91 Using where Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms System lock 0.02 ms init 0.04 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.03 ms executing 0.00 ms Sending data 0.21 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_jcomments/classes/config.php:140 14 JCommentsCfg::_load() Такой же, как вызов в строке ниже 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/components/com_jcomments/classes/config.php:159 11 JCommentsCfg->load() JROOT/components/com_jcomments/classes/config.php:47 10 JCommentsCfg::getInstance() JROOT/components/com_jcomments/helpers/system.php:39 9 JCommentsSystemPluginHelper::getCSS() JROOT/plugins/system/jcomments/jcomments.php:139 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:49 - Время запроса: 4.67 ms После последнего запроса: 0.29 ms Память запроса: 0.021 MB. Память перед запросом: 9.604 MB Возвращено строк: 4
SELECT id, home, template, s.params
FROM jupf25_template_styles as s
LEFT JOIN jupf25_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home INDEX KEY не используется NULL NULL 8 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 gb_new88.s.template,const 1 Using where Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms System lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.00 ms Sending data 0.17 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/components/com_jcomments/helpers/system.php:46 9 JCommentsSystemPluginHelper::getCSS() JROOT/plugins/system/jcomments/jcomments.php:139 8 plgSystemJComments->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:49 - Время запроса: 5.12 ms После последнего запроса: 1.71 ms Память запроса: 0.020 MB. Память перед запросом: 9.933 MB Возвращено строк: 1
SELECT *
FROM jupf25_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_languages ALL NULL INDEX KEY не используется NULL NULL 1 Using where; Используется сортировка файлов Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.08 ms Sending data 0.06 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 5.77 ms После последнего запроса: 2.92 ms Память запроса: 0.029 MB. Память перед запросом: 10.657 MB Возвращено строк: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jupf25_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_jcomments','com_joomgallery','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijopolls','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_productfinder','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_assets range idx_asset_name idx_asset_name 202 NULL 46 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.10 ms optimizing 0.01 ms statistics 0.26 ms preparing 0.02 ms executing 0.00 ms Sending data 0.86 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 42.87 ms После последнего запроса: 0.26 ms Память запроса: 0.326 MB. Память перед запросом: 10.710 MB Возвращено строк: 2242
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jupf25_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jupf25_assets ALL idx_asset_name,idx_parent_id INDEX KEY не используется NULL NULL 2542 Using where Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms System lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sending data 10.77 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 15.26 ms logging slow query 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:49 - Время запроса: 5.13 ms После последнего запроса: 3.97 ms Память запроса: 0.026 MB. Память перед запросом: 12.912 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 `jupf25_categories` AS `s`
INNER JOIN `jupf25_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 = 62
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_left_right idx_left_right 4 NULL 53 Using where Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.01 ms Sending data 0.56 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 34.12 ms После последнего запроса: 1.03 ms Память запроса: 0.060 MB. Память перед запросом: 12.961 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, 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 jupf25_content AS a
LEFT JOIN jupf25_categories AS c
ON c.id = a.catid
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_by
LEFT JOIN jupf25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jupf25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jupf25_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 62
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 22:01:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 22:01:23')
ORDER BY a.ordering, a.created
LIMIT 21, 3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Используется сортировка файлов 1 SIMPLE a ref idx_state,idx_catid idx_state 1 const 613 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gb_new88.a.created_by 1 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 gb_new88.a.modified_by 1 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 gb_new88.a.id 1 Status Duration starting 0.26 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.05 ms System lock 0.01 ms init 0.09 ms optimizing 0.03 ms statistics 0.35 ms preparing 0.04 ms executing 0.00 ms Sorting result 23.54 ms Sending data 0.83 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms logging slow query 0.00 ms cleaning up 0.01 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:194 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:49 - Время запроса: 6.40 ms После последнего запроса: 0.90 ms Память запроса: 0.024 MB. Память перед запросом: 13.334 MB Возвращено строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jupf25_contentitem_tag_map` AS m
INNER JOIN `jupf25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 2183
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX KEY не используется NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gb_new88.m.tag_id 1 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms System lock 0.02 ms init 0.07 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.03 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 4.78 ms После последнего запроса: 0.23 ms Память запроса: 0.024 MB. Память перед запросом: 13.352 MB Возвращено строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jupf25_contentitem_tag_map` AS m
INNER JOIN `jupf25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 2182
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX KEY не используется NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gb_new88.m.tag_id 1 Using where Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms System lock 0.01 ms init 0.07 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms executing 0.00 ms Sending data 0.07 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 4.22 ms После последнего запроса: 0.24 ms Память запроса: 0.024 MB. Память перед запросом: 13.369 MB Возвращено строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jupf25_contentitem_tag_map` AS m
INNER JOIN `jupf25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 2178
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX KEY не используется NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gb_new88.m.tag_id 1 Using where Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms System lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 8.27 ms После последнего запроса: 0.49 ms Память запроса: 0.024 MB. Память перед запросом: 13.378 MB Возвращено строк: 1
SELECT COUNT(*)
FROM jupf25_content AS a
LEFT JOIN jupf25_categories AS c
ON c.id = a.catid
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_by
LEFT JOIN jupf25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jupf25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jupf25_content_rating AS v
ON a.id = v.content_id
WHERE c.published = 1
AND a.state = 1
AND a.catid = 62
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 22:01:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 22:01:23')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE a ref idx_state,idx_catid idx_state 1 const 613 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gb_new88.a.created_by 1 Using index 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 gb_new88.a.modified_by 1 Using index 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 gb_new88.a.id 1 Using index Status Duration starting 0.17 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.06 ms System lock 0.02 ms init 0.07 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.05 ms executing 0.01 ms Sending data 3.70 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms logging slow query 0.00 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:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 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:49 - Время запроса: 4.49 ms После последнего запроса: 0.28 ms Память запроса: 0.022 MB. Память перед запросом: 13.381 MB Возвращено строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jupf25_contentitem_tag_map` AS m
INNER JOIN `jupf25_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 62
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type INDEX KEY не используется NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 gb_new88.m.tag_id 1 Using where Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms System lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 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:49 - Время запроса: 5.31 ms После последнего запроса: 2.63 ms Память запроса: 0.027 MB. Память перед запросом: 14.046 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 `jupf25_categories` AS `s`
INNER JOIN `jupf25_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 = 62
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 53 Using where Status Duration starting 0.16 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.06 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.01 ms Sending data 0.35 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/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:49 - Время запроса: 5.16 ms После последнего запроса: 0.24 ms Память запроса: 0.025 MB. Память перед запросом: 14.067 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 jupf25_fields AS a
LEFT JOIN `jupf25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jupf25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jupf25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jupf25_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jupf25_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 (62,0,63))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 gb_new88.a.language 1 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 gb_new88.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 gb_new88.a.access 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gb_new88.a.created_user_id 1 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 gb_new88.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 gb_new88.a.id 1 Using where; Using index; Distinct 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.06 ms System lock 0.01 ms init 0.07 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.18 ms executing 0.00 ms Copying to tmp table 0.04 ms Sorting result 0.04 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/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:49 - Время запроса: 3.35 ms После последнего запроса: 1.59 ms Память запроса: 0.023 MB. Память перед запросом: 14.432 MB Возвращено строк: 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `jupf25_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 62id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE contact ref idx_state idx_state 1 const 1 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.02 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 logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/plugins/content/contact/contact.php:125 14 PlgContentContact->getContactData() JROOT/plugins/content/contact/contact.php:66 13 PlgContentContact->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/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:49 - Время запроса: 5.08 ms После последнего запроса: 3.03 ms Память запроса: 0.026 MB. Память перед запросом: 14.782 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 jupf25_fields AS a
LEFT JOIN `jupf25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jupf25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jupf25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jupf25_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 gb_new88.a.language 1 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 gb_new88.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 gb_new88.a.access 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gb_new88.a.created_user_id 1 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 gb_new88.a.group_id 1 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.01 ms Opening tables 0.06 ms System lock 0.01 ms init 0.09 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.05 ms Creating tmp table 0.18 ms executing 0.00 ms Copying to tmp table 0.06 ms Sorting result 0.03 ms Sending data 0.03 ms end 0.00 ms removing tmp table 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 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:49 - Время запроса: 4.45 ms После последнего запроса: 0.47 ms Память запроса: 0.027 MB. Память перед запросом: 14.802 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 jupf25_fields AS a
LEFT JOIN `jupf25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jupf25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jupf25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jupf25_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jupf25_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (62,0,63))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Используется сортировка файлов 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 gb_new88.a.language 1 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 gb_new88.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 gb_new88.a.access 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 gb_new88.a.created_user_id 1 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 gb_new88.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 gb_new88.a.id 1 Using where; Using index; Distinct Status Duration starting 0.15 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.06 ms System lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.13 ms preparing 0.03 ms Creating tmp table 0.17 ms executing 0.00 ms Copying to tmp table 0.05 ms Sorting result 0.03 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 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:49 - Время запроса: 16.45 ms После последнего запроса: 5.29 ms Память запроса: 0.058 MB. Память перед запросом: 15.176 MB Возвращено строк: 31
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jupf25_modules AS m
LEFT JOIN jupf25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jupf25_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-12-09 22:01:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-09 22:01:23')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 375 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 34 Using where; Используется сортировка файлов 1 SIMPLE mm ref PRIMARY PRIMARY 4 gb_new88.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 gb_new88.m.module,const 1 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.05 ms System lock 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.04 ms executing 0.00 ms Sorting result 0.30 ms Sending data 0.76 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms logging slow query 0.00 ms cleaning up 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() Такой же, как вызов в строке ниже 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/accessibility/index.php:118 7 require JROOT/templates/accessibility/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 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:49
21 типов запросов зарегистрировано (отсортировано по вхождениям)
Запросы типа SELECT:
4 × SELECT `m`.`tag_id`,`t`.*
FROM `jupf25_contentitem_tag_map` AS m
INNER JOIN `jupf25_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jupf25_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jupf25_extensions`2 × 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 jupf25_fields AS a
LEFT JOIN `jupf25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jupf25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jupf25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jupf25_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jupf25_fields_categories` AS fc
ON fc.field_id = a.id2 × 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 `jupf25_categories` AS `s`
INNER JOIN `jupf25_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `data`
FROM `jupf25_session`1 × 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 jupf25_fields AS a
LEFT JOIN `jupf25_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jupf25_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jupf25_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jupf25_fields_groups AS g
ON g.id = a.group_id1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `jupf25_contact_details` AS `contact`1 × SELECT COUNT(*)
FROM jupf25_content AS a
LEFT JOIN jupf25_categories AS c
ON c.id = a.catid
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_by
LEFT JOIN jupf25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jupf25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jupf25_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, 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 jupf25_content AS a
LEFT JOIN jupf25_categories AS c
ON c.id = a.catid
LEFT JOIN jupf25_users AS ua
ON ua.id = a.created_by
LEFT JOIN jupf25_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jupf25_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jupf25_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM jupf25_languages1 × SELECT `session_id`
FROM `jupf25_session`1 × SELECT id, home, template, s.params
FROM jupf25_template_styles as s
LEFT JOIN jupf25_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM `jupf25_jcomments_settings`1 × 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 jupf25_menu AS m
LEFT JOIN jupf25_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jupf25_extensions1 × SELECT b.id
FROM jupf25_usergroups AS a
LEFT JOIN jupf25_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jupf25_viewlevels1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jupf25_modules AS m
LEFT JOIN jupf25_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jupf25_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
Запросы типа OTHER:
1 × INSERT INTO `jupf25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'697673356b706a73733262746f38696763716c386b7264373475', 1, 1702159283, 0, '', 01 × UPDATE `jupf25_extensions`
SET `params` = '{\"mediaversion\":\"7e64b4a429e5c16613fcc7910b64f420\"}'