- Акушерство и гинекология (108 ч.)
- Актуальные вопросы акушерства-гинекологии (36 ч.)
- Актуальные вопросы гинекологии детского и подросткового возраста (36 ч.)
- Актуальные вопросы лечебной физкультуры и спортивной медицины (144 ч.)
- Актуальные вопросы УЗИ - диагностики неопухолевых и доброкачественных заболеваний молочных желез (36 ч.)
- Актуальные вопросы УЗИ - диагностики в акушерстве и гинекологии (144 ч.)
- Антенатальные и перинатальные патологии в акушерстве и гинекологии (36 ч.)
- Вопросы оказания медицинской помощи с применением рентгенэндоваскулярных методов диагностики и лечения пациентам с заболеваниями и (или) состояниями сердечнососудистой системы и с сосудистой патологией (36 ч.)
- Вопросы проведения УЗИ - диагностики неопухолевых и доброкачественных заболеваний молочных желез (36 ч.)
- Вопросы частной клинической фармакологии (36 ч.)
- Кольпоскопия(36 ч.)
- Маммология(36 ч.)
- Общие вопросы клинической фармакологии (144 ч.)
- Обеспечение безопасности пациентов и управление рисками при оказании медицинской помощи (36 ч.)
- Оказание акушерской и гинекологической помощи в современных условиях (72 ч.)
- Особенности диагностики, лечения, акушерской тактики и профилактики коронавирусной инфекции COVID-19 при беременности и грудном вскармливании (36 ч.)
- Основные аспекты вакцинации населения от новой коронавирусной инфекции COVID-19 (36 ч.)
- Патологические состояния в акушерстве и гинекологии (36 ч.)
- Патологическое акушерство и гинекология (72 ч.)
- Пороки развития и возрастные изменения молочных желёз (36 ч.)
- Профилактика, обследование и лечение бесплодия в женской консультации (36 ч.)
- Рентгенэндоваскулярные диагностика и лечение в неврологии и нейрохирургии (36 ч.)
- Современные аспекты оказания акушерской и гинекологической помощи (144 ч.)
- Современные аспекты оказания медицинской помощи при неотложных и экстремальных состояниях. Медицина катастроф (36 ч.)
- Современные аспекты рентгенэндоваскулярных диагностики и лечения (144 ч.)
- Современные аспекты экспертизы временной нетрудоспособности и управления качеством в здравоохранении (72 ч.)
- Современные вопросы профилактики, диагностики и лечения коронавирусной инфекции COVID-19 (36 ч.)
- Экспертиза временной нетрудоспособности и управление качеством в здравоохранении (108 ч.)
- Экспертиза временной нетрудоспособности и управление качеством в здравоохранении на современном этапе (72 ч.)
Консоль отладки Joomla!
{
"__default": {
"session": {
"counter": 17,
"timer": {
"start": 1761640467,
"last": 1761640470,
"now": 1761640470
}
},
"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
}
}
}
Время
Память
Время: 2.75 ms / 2.75 ms Память: 0.793 MB / 1.01 MB Application: afterLoad
Время: 25.96 ms / 28.71 ms Память: 1.876 MB / 2.88 MB Application: afterInitialise
Время: 17.65 ms / 46.37 ms Память: 2.319 MB / 5.20 MB Application: afterRoute
Время: 0.30 ms / 46.67 ms Память: 0.021 MB / 5.22 MB Application: beforeRenderComponent com_content
Время: 1.26 ms / 47.93 ms Память: 0.123 MB / 5.35 MB Application: Before Access::preloadComponents (all components)
Время: 1.79 ms / 49.72 ms Память: 0.106 MB / 5.45 MB Application: After Access::preloadComponents (all components)
Время: 0.04 ms / 49.75 ms Память: 0.000 MB / 5.45 MB Application: Before Access::preloadPermissions (com_content)
Время: 1.91 ms / 51.66 ms Память: 0.526 MB / 5.97 MB Application: After Access::preloadPermissions (com_content)
Время: 0.08 ms / 51.74 ms Память: 0.000 MB / 5.95 MB Application: Before Access::getAssetRules (id:194 name:com_content.article.87)
Время: 0.27 ms / 52.02 ms Память: 0.019 MB / 5.96 MB Application: After Access::getAssetRules (id:194 name:com_content.article.87)
Время: 13.31 ms / 65.32 ms Память: 0.865 MB / 6.83 MB Application: afterRenderComponent com_content
Время: 0.72 ms / 66.05 ms Память: 0.025 MB / 6.85 MB Application: afterDispatch
Время: 21.46 ms / 87.51 ms Память: 2.700 MB / 9.55 MB Application: beforeRenderModule mod_favsocial (Мы в социальных сетях)
Время: 0.77 ms / 88.28 ms Память: 0.051 MB / 9.60 MB Application: afterRenderModule mod_favsocial (Мы в социальных сетях)
Время: 0.07 ms / 88.35 ms Память: 0.000 MB / 9.56 MB Application: beforeRenderModule mod_doyandexmetrika (do Yandex Metrika)
Время: 0.97 ms / 89.32 ms Память: 0.063 MB / 9.62 MB Application: afterRenderModule mod_doyandexmetrika (do Yandex Metrika)
Время: 38.51 ms / 127.83 ms Память: 0.100 MB / 9.72 MB Application: afterRender
Всего SQL-запросов: 11.54 ms
10.19 MB (10 684 128 Байт)
22 SQL-запросов зафиксировано 11.54 ms
- Время запроса: 0.20 ms Память запроса: 0.021 MB Память до запроса: 1.545 MB Выбрано строк: 1
SELECT `data`
FROM `zm7l1_session`
WHERE `session_id` = 'uk6rga8edrbq2qhj1vno3sgb60'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734 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:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Время запроса: 0.41 ms После последнего запроса: 0.89 ms Память запроса: 0.027 MB Память до запроса: 1.669 MB Выбрано строк: 47
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zm7l1_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_extensions ref extension extension 82 const 48 Using index condition; Using where Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.23 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.16 ms После последнего запроса: 0.69 ms Память запроса: 0.014 MB Память до запроса: 1.784 MB Выбрано строк: 5
SELECT id, rules
FROM `zm7l1_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_viewlevels ALL NULL Индекс не используется NULL NULL 5 Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.20 ms После последнего запроса: 0.14 ms Память запроса: 0.015 MB Память до запроса: 1.809 MB Выбрано строк: 2
SELECT b.id
FROM zm7l1_usergroups AS a
LEFT JOIN zm7l1_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.85 ms После последнего запроса: 0.22 ms Память запроса: 0.019 MB Память до запроса: 1.847 MB Выбрано строк: 98
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM zm7l1_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_extensions ref extension extension 82 const 134 Using index condition; Using where; Используется filesort Status Duration Starting 0.03 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.61 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 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:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 5.53 ms Память запроса: 0.024 MB Память до запроса: 2.425 MB Выбрано строк: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zm7l1_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 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/kunena/kunena.php:70 7 plgSystemKunena->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.18 ms После последнего запроса: 0.21 ms Память запроса: 0.016 MB Память до запроса: 2.430 MB
UPDATE `zm7l1_extensions`
SET `params` = '{\"mediaversion\":\"a76c12a04dbcc089b16dec3519a9bc9d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN не доступен для запроса: UPDATE `zm7l1_extensions` SET `params` = '{\"mediaversion\":\"a76c12a04dbcc089b16dec3519a9bc9d\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init for update 0.05 ms Updating 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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/kunena/kunena.php:70 7 plgSystemKunena->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.15 ms После последнего запроса: 12.35 ms Память запроса: 0.016 MB Память до запроса: 2.850 MB Выбрано строк: 0
SELECT `state`,`rule_type`
FROM `zm7l1_jhackguard_ip_filters`
WHERE `ip` = '216.73.216.212'
AND `state` = 1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jhackguard/jhackguard.php:358 10 PlgSystemJhackguard->ip_is() JROOT/plugins/system/jhackguard/jhackguard.php:174 9 PlgSystemJhackguard->onAfterInitialise() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 2.43 ms После последнего запроса: 0.78 ms Память запроса: 0.084 MB Память до запроса: 2.960 MB Выбрано строк: 298
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 zm7l1_menu AS m
LEFT JOIN zm7l1_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 305 Using index condition; Using where; Используется filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 idopobr_test.m.component_id 1 Using where Status Duration Starting 0.04 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 2.19 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:76 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:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 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:64 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:491 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:1073 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.22 ms После последнего запроса: 12.58 ms Память запроса: 0.022 MB Память до запроса: 5.045 MB Выбрано строк: 1
SELECT *
FROM zm7l1_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_languages ALL NULL Индекс не используется NULL NULL 1 Using where; Используется filesort Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.02 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.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 13 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 12 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:274 11 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:55 10 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:478 9 plgSystemK2->onAfterRoute() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.29 ms После последнего запроса: 0.73 ms Память запроса: 0.027 MB Память до запроса: 5.157 MB Выбрано строк: 3
SELECT id, home, template, s.params
FROM zm7l1_template_styles as s
LEFT JOIN zm7l1_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 e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template Индекс не используется NULL NULL 5 Using where; Using join buffer (flat, BNL join) Status Duration Starting 0.03 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 20 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 19 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 18 Joomla\CMS\HTML\HTMLHelper::script() Так же, как вызов в строке ниже. 17 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 16 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 15 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 14 JHtmlJquery::framework() Так же, как вызов в строке ниже. 13 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 12 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 11 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:82 10 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:478 9 plgSystemK2->onAfterRoute() Так же, как вызов в строке ниже. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 1.34 ms После последнего запроса: 2.69 ms Память запроса: 0.026 MB Память до запроса: 5.354 MB Выбрано строк: 46
SELECT `id`,`name`,`rules`,`parent_id`
FROM `zm7l1_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_bagallery','com_banners','com_cache','com_categories','com_checkin','com_cmicoursesapp','com_config','com_contact','com_contactus','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jak2filter','com_jhackguard','com_jlsitemap','com_joomlaupdate','com_joomlycallback','com_k2','com_k2import','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_quickdownload','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_assets ALL idx_asset_name Индекс не используется NULL NULL 399 Using where Status Duration Starting 0.05 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.08 ms Optimizing 0.01 ms Statistics 0.16 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.92 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.69 ms После последнего запроса: 0.36 ms Память запроса: 0.036 MB Память до запроса: 5.448 MB Выбрано строк: 299
SELECT `id`,`name`,`rules`,`parent_id`
FROM `zm7l1_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 zm7l1_assets ALL idx_asset_name,idx_parent_id Индекс не используется NULL NULL 399 Using where Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.47 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.64 ms После последнего запроса: 1.76 ms Память запроса: 0.025 MB Память до запроса: 5.989 MB Выбрано строк: 31
SHOW FULL COLUMNS
FROM `zm7l1_content`EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `zm7l1_content`Status Duration Starting 0.02 ms Checking permissions 0.00 ms Closing tables 0.00 ms Opening tables 0.20 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms Checking permissions 0.12 ms Closing tables 0.01 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Removing tmp table 0.07 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.23 ms После последнего запроса: 1.35 ms Память запроса: 0.024 MB Память до запроса: 6.131 MB Выбрано строк: 1
SELECT *
FROM zm7l1_content
WHERE `id` = '87'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE zm7l1_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1459 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.93 ms После последнего запроса: 0.20 ms Память запроса: 0.014 MB Память до запроса: 6.153 MB
UPDATE zm7l1_content
SET `hits` = (`hits` + 1)
WHERE `id` = '87'EXPLAIN не доступен для запроса: UPDATE zm7l1_content SET `hits` = (`hits` + 1) WHERE `id` = '87'Status Duration Starting 0.02 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init for update 0.03 ms Updating 0.04 ms End of update loop 0.01 ms Waiting for query cache lock 0.00 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.75 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1242 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:255 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.46 ms После последнего запроса: 0.67 ms Память запроса: 0.028 MB Память до запроса: 6.221 MB Выбрано строк: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM zm7l1_content AS a
INNER JOIN zm7l1_categories AS c
on c.id = a.catid
LEFT JOIN zm7l1_users AS u
on u.id = a.created_by
LEFT JOIN zm7l1_categories as parent
ON parent.id = c.parent_id
LEFT JOIN zm7l1_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 87
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-10-28 08:34:30')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-10-28 08:34:30')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.11 ms Checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1656 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.29 ms После последнего запроса: 1.28 ms Память запроса: 0.024 MB Память до запроса: 6.326 MB Выбрано строк: 0
SELECT `m`.`tag_id`,`t`.*
FROM `zm7l1_contentitem_tag_map` AS m
INNER JOIN `zm7l1_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 87
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type Индекс не используется NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 idopobr_test.m.tag_id 1 Using where Status Duration Starting 0.03 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.42 ms После последнего запроса: 1.65 ms Память запроса: 0.034 MB Память до запроса: 6.551 MB Выбрано строк: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `zm7l1_categories` AS `s`
INNER JOIN `zm7l1_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,5)
AND c.published = 1
AND s.id = 8
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 ALL cat_idx,idx_access,idx_left_right Индекс не используется NULL NULL 7 Using where; Используется filesort Status Duration Starting 0.08 ms Checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.04 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.06 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 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:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:478 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/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.44 ms После последнего запроса: 0.38 ms Память запроса: 0.032 MB Память до запроса: 6.613 MB Выбрано строк: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM zm7l1_fields AS a
LEFT JOIN `zm7l1_languages` AS l
ON l.lang_code = a.language
LEFT JOIN zm7l1_users AS uc
ON uc.id=a.checked_out
LEFT JOIN zm7l1_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN zm7l1_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN zm7l1_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `zm7l1_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table 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; Используется filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 idopobr_test.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 idopobr_test.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 idopobr_test.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 idopobr_test.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 idopobr_test.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 idopobr_test.a.id 1 Using where; Using index Status Duration Starting 0.10 ms Checking permissions 0.00 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.05 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 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:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:135 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:478 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/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.63 ms После последнего запроса: 25.32 ms Память запроса: 0.020 MB Память до запроса: 9.496 MB Выбрано строк: 8
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zm7l1_modules AS m
LEFT JOIN zm7l1_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zm7l1_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 <= '2025-10-28 08:34:30')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-28 08:34:30')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 440 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 19 Using index condition; Using where; Используется filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 idopobr_test.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 idopobr_test.m.module,const 1 Using index condition; Using where Status Duration Starting 0.07 ms Checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.29 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 13 JDatabaseDriver->loadObjectList() Так же, как вызов в строке ниже. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Время запроса: 0.16 ms После последнего запроса: 36.95 ms Память запроса: 0.014 MB Память до запроса: 9.751 MB Выбрано строк: 0
SELECT `name`,`regex`,`replacement`
FROM `zm7l1_jhackguard_output_filters`
WHERE `state` = 1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Индекс не используется NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Closing tables 0.00 ms Unlocking tables 0.00 ms Closing tables 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Вызывающий объект Файл и номер строки 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jhackguard/jhackguard.php:91 8 PlgSystemJhackguard->onAfterRender() Так же, как вызов в строке ниже. 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:1050 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:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
20 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `zm7l1_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `zm7l1_extensions`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM zm7l1_content AS a
INNER JOIN zm7l1_categories AS c
on c.id = a.catid
LEFT JOIN zm7l1_users AS u
on u.id = a.created_by
LEFT JOIN zm7l1_categories as parent
ON parent.id = c.parent_id
LEFT JOIN zm7l1_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM zm7l1_content1 × SELECT `m`.`tag_id`,`t`.*
FROM `zm7l1_contentitem_tag_map` AS m
INNER JOIN `zm7l1_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM zm7l1_fields AS a
LEFT JOIN `zm7l1_languages` AS l
ON l.lang_code = a.language
LEFT JOIN zm7l1_users AS uc
ON uc.id=a.checked_out
LEFT JOIN zm7l1_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN zm7l1_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN zm7l1_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `zm7l1_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `name`,`regex`,`replacement`
FROM `zm7l1_jhackguard_output_filters`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zm7l1_modules AS m
LEFT JOIN zm7l1_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zm7l1_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 `zm7l1_categories` AS `s`
INNER JOIN `zm7l1_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 id, home, template, s.params
FROM zm7l1_template_styles as s
LEFT JOIN zm7l1_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT b.id
FROM zm7l1_usergroups AS a
LEFT JOIN zm7l1_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `zm7l1_viewlevels1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM zm7l1_extensions1 × SELECT `state`,`rule_type`
FROM `zm7l1_jhackguard_ip_filters`1 × SELECT *
FROM zm7l1_languages1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM zm7l1_menu AS m
LEFT JOIN zm7l1_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `zm7l1_session`
Прочие SQL-запросы:
1 × UPDATE zm7l1_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `zm7l1_content1 × UPDATE `zm7l1_extensions`
SET `params` = '{\"mediaversion\":\"a76c12a04dbcc089b16dec3519a9bc9d\"}'