Время запроса: 0.31 ms Память запроса: 0.023 MB. Память перед запросом: 1.247 MB Возвращено строк: 0
SELECT `data`
FROM `k0nc_session`
WHERE `session_id` = X'3430316237663231323233366463623334373537663038356662326231613861'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k0nc_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.13 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| executing | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php: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 |
Время запроса: 0.10 ms После последнего запроса: 0.46 ms Память запроса: 0.020 MB. Память перед запросом: 1.262 MB Возвращено строк: 0
SELECT `session_id`
FROM `k0nc_session`
WHERE `session_id` = X'3430316237663231323233366463623334373537663038356662326231613861'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k0nc_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| executing | 0.00 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 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 |
Время запроса: 0.20 ms После последнего запроса: 0.10 ms Память запроса: 0.004 MB. Память перед запросом: 1.268 MB
INSERT INTO `k0nc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3430316237663231323233366463623334373537663038356662326231613861', 1, 1714400009, 0, '', 0)
EXPLAIN недоступен для: INSERT INTO `k0nc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3430316237663231323233366463623334373537663038356662326231613861', 1, 1714400009, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| update | 0.08 ms |
| end | 0.00 ms |
| query end | 0.05 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 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 |
Время запроса: 0.31 ms После последнего запроса: 2.19 ms Память запроса: 0.021 MB. Память перед запросом: 1.419 MB Возвращено строк: 5
SELECT id, rules
FROM `k0nc_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k0nc_viewlevels | NULL | ALL | NULL | INDEX KEY не используется | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.16 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.00 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 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 |
Время запроса: 0.51 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB. Память перед запросом: 1.431 MB Возвращено строк: 2
SELECT b.id
FROM k0nc_usergroups AS a
LEFT JOIN k0nc_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.30 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.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 |
Время запроса: 0.53 ms После последнего запроса: 4.91 ms Память запроса: 0.021 MB. Память перед запросом: 1.946 MB Возвращено строк: 1
SELECT lft,rgt
FROM k0nc_categories
WHERE id=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k0nc_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.27 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.04 ms |
| preparing | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 9 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_flexicontent/defineconstants.php:100 |
| 8 | require_once JROOT/administrator/components/com_flexicontent/defineconstants.php | JROOT/plugins/system/flexisystem/flexisystem.php:19 |
| 7 | require_once JROOT/plugins/system/flexisystem/flexisystem.php | JROOT/libraries/src/Plugin/PluginHelper.php:251 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Время запроса: 0.72 ms После последнего запроса: 13.15 ms Память запроса: 0.006 MB. Память перед запросом: 2.461 MB
UPDATE `k0nc_extensions`
SET `params` = '{\"mediaversion\":\"06fab4d3e495c80d28b5eb6c6b593a0a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | k0nc_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.20 ms |
| init | 0.02 ms |
| System lock | 0.19 ms |
| updating | 0.08 ms |
| end | 0.01 ms |
| query end | 0.06 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 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/flexisystem/flexisystem.php:251 |
| 8 | plgSystemFlexisystem->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 |
Время запроса: 0.62 ms После последнего запроса: 6.71 ms Память запроса: 0.023 MB. Память перед запросом: 2.826 MB Возвращено строк: 3
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM k0nc_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'g5_hydrogen'
ORDER BY s.id
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | const | 3 | 77.78 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.21 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.14 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46 |
| 14 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50 |
| 13 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:304 |
| 12 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104 |
| 11 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91 |
| 10 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:246 |
| 9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:57 |
| 8 | plgSystemGantry5->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 |
Время запроса: 1.29 ms После последнего запроса: 20.57 ms Память запроса: 0.029 MB. Память перед запросом: 3.219 MB Возвращено строк: 36
SELECT `id`,`name`,`rules`,`parent_id`
FROM `k0nc_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_flexicontent','com_gantry5','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k0nc_assets | NULL | ALL | idx_asset_name | INDEX KEY не используется | NULL | NULL | 135 | 27.41 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.28 ms |
| init | 0.06 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.18 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.50 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 19 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 18 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 17 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 16 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 15 | Joomla\CMS\User\User->authorise() | JROOT/components/com_flexicontent/models/flexicontent.php:223 |
| 14 | FlexicontentModelFlexicontent->_buildQuery() | JROOT/components/com_flexicontent/models/flexicontent.php:139 |
| 13 | FlexicontentModelFlexicontent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 2.30 ms После последнего запроса: 0.88 ms Память запроса: 0.041 MB. Память перед запросом: 3.301 MB Возвращено строк: 5
SELECT c.*, u.name as author,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid )
FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i
ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty
ON i.type_id = ty.id JOIN k0nc_categories AS cc
ON cc.id = rel.catid
WHERE cc.published = 1
AND c.id = cc.id
AND (i .language = 'ru-RU' OR i.language = '*')
AND ( i.state IN (1, -5) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ty.access IN (0,1,1,5)
AND cc.access IN (0,1,1,5)
AND i.access IN (0,1,1,5) ) AS assigneditems
FROM k0nc_categories AS c
LEFT JOIN k0nc_users AS u
ON u.id = c.created_user_id
WHERE c.published = 1
AND c.extension="com_content"
AND c.parent_id = 1
AND c.access IN (0,1,1,5)
ORDER BY c.lft ASC, c.title
LIMIT 0, 100
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where; Используется сортировка файлов |
| 1 | PRIMARY | u | NULL | eq_ref | PRIMARY | PRIMARY | 4 | keuees_konc.c.created_user_id | 1 | 100.00 | Using where |
| 2 | DEPENDENT SUBQUERY | cc | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | keuees_konc.c.id | 1 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | rel | NULL | ref | PRIMARY,catid,itemid | catid | 4 | keuees_konc.c.id | 9 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | i | NULL | eq_ref | PRIMARY,state,access,language,type_id | PRIMARY | 4 | keuees_konc.rel.itemid | 1 | 16.00 | Using where |
| 2 | DEPENDENT SUBQUERY | ty | NULL | eq_ref | PRIMARY,access | PRIMARY | 4 | keuees_konc.i.type_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.19 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.59 ms |
| init | 0.13 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.13 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.18 ms |
| preparing | 0.05 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.25 ms |
| executing | 0.00 ms |
| Sending data | 0.15 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| executing | 0.00 ms |
| Sending data | 0.12 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.03 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.07 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_flexicontent/models/flexicontent.php:139 |
| 13 | FlexicontentModelFlexicontent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 0.97 ms После последнего запроса: 0.23 ms Память запроса: 0.023 MB. Память перед запросом: 3.352 MB Возвращено строк: 0
SELECT c.*,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid )
FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i
ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty
ON i.type_id = ty.id JOIN k0nc_categories AS cc
ON cc.id = rel.catid
WHERE cc.published = 1
AND c.id = cc.id
AND (i .language = 'ru-RU' OR i.language = '*')
AND ( i.state IN (1, -5) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ty.access IN (0,1,1,5)
AND cc.access IN (0,1,1,5)
AND i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id )
FROM k0nc_categories AS sc
WHERE c.id = sc.parent_id
AND sc.published = 1
AND sc.access IN (0,1,1,5) ) AS assignedcats
FROM k0nc_categories AS c
WHERE c.published = 1
AND c.extension="com_content"
AND c.parent_id = 2
AND c.access IN (0,1,1,5)
ORDER BY c.lft ASC, c.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where; Используется сортировка файлов |
| 3 | DEPENDENT SUBQUERY | sc | NULL | ALL | idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | cc | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | keuees_konc.c.id | 1 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | rel | NULL | ref | PRIMARY,catid,itemid | catid | 4 | keuees_konc.c.id | 9 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | i | NULL | eq_ref | PRIMARY,state,access,language,type_id | PRIMARY | 4 | keuees_konc.rel.itemid | 1 | 16.00 | Using where |
| 2 | DEPENDENT SUBQUERY | ty | NULL | eq_ref | PRIMARY,access | PRIMARY | 4 | keuees_konc.i.type_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.13 ms |
| init | 0.10 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.06 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/models/flexicontent.php:449 |
| 14 | FlexicontentModelFlexicontent->_getsubs() | JROOT/components/com_flexicontent/models/flexicontent.php:147 |
| 13 | FlexicontentModelFlexicontent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 0.82 ms После последнего запроса: 0.10 ms Память запроса: 0.023 MB. Память перед запросом: 3.361 MB Возвращено строк: 0
SELECT c.*,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid )
FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i
ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty
ON i.type_id = ty.id JOIN k0nc_categories AS cc
ON cc.id = rel.catid
WHERE cc.published = 1
AND c.id = cc.id
AND (i .language = 'ru-RU' OR i.language = '*')
AND ( i.state IN (1, -5) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ty.access IN (0,1,1,5)
AND cc.access IN (0,1,1,5)
AND i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id )
FROM k0nc_categories AS sc
WHERE c.id = sc.parent_id
AND sc.published = 1
AND sc.access IN (0,1,1,5) ) AS assignedcats
FROM k0nc_categories AS c
WHERE c.published = 1
AND c.extension="com_content"
AND c.parent_id = 8
AND c.access IN (0,1,1,5)
ORDER BY c.lft ASC, c.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where; Используется сортировка файлов |
| 3 | DEPENDENT SUBQUERY | sc | NULL | ALL | idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | cc | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | keuees_konc.c.id | 1 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | rel | NULL | ref | PRIMARY,catid,itemid | catid | 4 | keuees_konc.c.id | 9 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | i | NULL | eq_ref | PRIMARY,state,access,language,type_id | PRIMARY | 4 | keuees_konc.rel.itemid | 1 | 16.00 | Using where |
| 2 | DEPENDENT SUBQUERY | ty | NULL | eq_ref | PRIMARY,access | PRIMARY | 4 | keuees_konc.i.type_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.08 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.16 ms |
| preparing | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/models/flexicontent.php:449 |
| 14 | FlexicontentModelFlexicontent->_getsubs() | JROOT/components/com_flexicontent/models/flexicontent.php:147 |
| 13 | FlexicontentModelFlexicontent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 0.76 ms После последнего запроса: 0.12 ms Память запроса: 0.023 MB. Память перед запросом: 3.369 MB Возвращено строк: 0
SELECT c.*,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid )
FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i
ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty
ON i.type_id = ty.id JOIN k0nc_categories AS cc
ON cc.id = rel.catid
WHERE cc.published = 1
AND c.id = cc.id
AND (i .language = 'ru-RU' OR i.language = '*')
AND ( i.state IN (1, -5) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ty.access IN (0,1,1,5)
AND cc.access IN (0,1,1,5)
AND i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id )
FROM k0nc_categories AS sc
WHERE c.id = sc.parent_id
AND sc.published = 1
AND sc.access IN (0,1,1,5) ) AS assignedcats
FROM k0nc_categories AS c
WHERE c.published = 1
AND c.extension="com_content"
AND c.parent_id = 9
AND c.access IN (0,1,1,5)
ORDER BY c.lft ASC, c.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where; Используется сортировка файлов |
| 3 | DEPENDENT SUBQUERY | sc | NULL | ALL | idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | cc | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | keuees_konc.c.id | 1 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | rel | NULL | ref | PRIMARY,catid,itemid | catid | 4 | keuees_konc.c.id | 9 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | i | NULL | eq_ref | PRIMARY,state,access,language,type_id | PRIMARY | 4 | keuees_konc.rel.itemid | 1 | 16.00 | Using where |
| 2 | DEPENDENT SUBQUERY | ty | NULL | eq_ref | PRIMARY,access | PRIMARY | 4 | keuees_konc.i.type_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.08 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/models/flexicontent.php:449 |
| 14 | FlexicontentModelFlexicontent->_getsubs() | JROOT/components/com_flexicontent/models/flexicontent.php:147 |
| 13 | FlexicontentModelFlexicontent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 0.75 ms После последнего запроса: 0.07 ms Память запроса: 0.023 MB. Память перед запросом: 3.378 MB Возвращено строк: 0
SELECT c.*,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid )
FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i
ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty
ON i.type_id = ty.id JOIN k0nc_categories AS cc
ON cc.id = rel.catid
WHERE cc.published = 1
AND c.id = cc.id
AND (i .language = 'ru-RU' OR i.language = '*')
AND ( i.state IN (1, -5) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ty.access IN (0,1,1,5)
AND cc.access IN (0,1,1,5)
AND i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id )
FROM k0nc_categories AS sc
WHERE c.id = sc.parent_id
AND sc.published = 1
AND sc.access IN (0,1,1,5) ) AS assignedcats
FROM k0nc_categories AS c
WHERE c.published = 1
AND c.extension="com_content"
AND c.parent_id = 10
AND c.access IN (0,1,1,5)
ORDER BY c.lft ASC, c.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where; Используется сортировка файлов |
| 3 | DEPENDENT SUBQUERY | sc | NULL | ALL | idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | cc | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | keuees_konc.c.id | 1 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | rel | NULL | ref | PRIMARY,catid,itemid | catid | 4 | keuees_konc.c.id | 9 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | i | NULL | eq_ref | PRIMARY,state,access,language,type_id | PRIMARY | 4 | keuees_konc.rel.itemid | 1 | 16.00 | Using where |
| 2 | DEPENDENT SUBQUERY | ty | NULL | eq_ref | PRIMARY,access | PRIMARY | 4 | keuees_konc.i.type_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.14 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.08 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.15 ms |
| preparing | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/models/flexicontent.php:449 |
| 14 | FlexicontentModelFlexicontent->_getsubs() | JROOT/components/com_flexicontent/models/flexicontent.php:147 |
| 13 | FlexicontentModelFlexicontent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 0.76 ms После последнего запроса: 0.10 ms Память запроса: 0.023 MB. Память перед запросом: 3.386 MB Возвращено строк: 0
SELECT c.*,
CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid )
FROM k0nc_flexicontent_cats_item_relations AS rel JOIN k0nc_flexicontent_items_tmp AS i
ON rel.itemid = i.id JOIN k0nc_flexicontent_types AS ty
ON i.type_id = ty.id JOIN k0nc_categories AS cc
ON cc.id = rel.catid
WHERE cc.published = 1
AND c.id = cc.id
AND (i .language = 'ru-RU' OR i.language = '*')
AND ( i.state IN (1, -5) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0
AND i.created_by != 0 ) )
AND ty.access IN (0,1,1,5)
AND cc.access IN (0,1,1,5)
AND i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id )
FROM k0nc_categories AS sc
WHERE c.id = sc.parent_id
AND sc.published = 1
AND sc.access IN (0,1,1,5) ) AS assignedcats
FROM k0nc_categories AS c
WHERE c.published = 1
AND c.extension="com_content"
AND c.parent_id = 11
AND c.access IN (0,1,1,5)
ORDER BY c.lft ASC, c.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | cat_idx,idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where; Используется сортировка файлов |
| 3 | DEPENDENT SUBQUERY | sc | NULL | ALL | idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | cc | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | keuees_konc.c.id | 1 | 10.00 | Using where |
| 2 | DEPENDENT SUBQUERY | rel | NULL | ref | PRIMARY,catid,itemid | catid | 4 | keuees_konc.c.id | 9 | 100.00 | Using where; Using index |
| 2 | DEPENDENT SUBQUERY | i | NULL | eq_ref | PRIMARY,state,access,language,type_id | PRIMARY | 4 | keuees_konc.rel.itemid | 1 | 16.00 | Using where |
| 2 | DEPENDENT SUBQUERY | ty | NULL | eq_ref | PRIMARY,access | PRIMARY | 4 | keuees_konc.i.type_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.15 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.08 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_flexicontent/models/flexicontent.php:449 |
| 14 | FlexicontentModelFlexicontent->_getsubs() | JROOT/components/com_flexicontent/models/flexicontent.php:147 |
| 13 | FlexicontentModelFlexicontent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 0.23 ms После последнего запроса: 0.09 ms Память запроса: 0.023 MB. Память перед запросом: 3.391 MB Возвращено строк: 5
SELECT c.id
FROM k0nc_categories AS c
WHERE c.published = 1
AND c.extension="com_content"
AND c.parent_id = 1
AND c.access IN (0,1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access | INDEX KEY не используется | NULL | NULL | 10 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367 |
| 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/components/com_flexicontent/models/flexicontent.php:326 |
| 13 | FlexicontentModelFlexicontent->getTotal() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_flexicontent/views/flexicontent/view.html.php:55 |
| 11 | FlexicontentViewFlexicontent->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 10 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_flexicontent/controller.php:1361 |
| 8 | FlexicontentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_flexicontent/flexicontent.php:265 |
| 6 | require_once JROOT/components/com_flexicontent/flexicontent.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 |
Время запроса: 0.46 ms После последнего запроса: 18.85 ms Память запроса: 0.035 MB. Память перед запросом: 4.061 MB Возвращено строк: 2
SELECT a.menutype
FROM k0nc_menu_types AS a
WHERE a.client_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ALL | NULL | INDEX KEY не используется | NULL | NULL | 2 | 50.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.18 ms |
| init | 0.01 ms |
| System lock | 0.01 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.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 44 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 43 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_menus/helpers/menus.php:154 |
| 42 | MenusHelper::getMenuTypes() | JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71 |
| 41 | Gantry\Framework\Menu->getMenus() | JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115 |
| 40 | Gantry\Component\Menu\AbstractMenu->instance() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
| 39 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/04/044a99fc4afe831c278d59c760d3754c5501b763e076cbe22b2d3adc478ef54e.php:32 |
| 38 | __TwigTemplate_abe408e5806812acde8de3b2ddae4f06b7d350277865e863347db8c8323e8a4c->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/bf/bfc721f933e8dbc421175ff417c73c9dd70c1417a9d21048f4317f536124a923.php:71 |
| 35 | __TwigTemplate_b03bdd93e11c8f0a454a4c4a94f59b6567b38a90017902ebb1e0af97d9e07690->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/e8/e8a7820de124bf69728a19f34f61992fdc1c43ab0fd0542c209abc8d6843c2cf.php:47 |
| 20 | __TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/8d/8da9c74876eba78eb8aef4f7a95e3838449d7ef48c73532b8526c5268febf94d.php:35 |
| 17 | __TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/81/8185070b0fb05aa12b3d83b5556f245a99ef880efa5e9468dd59cadefccbcfb3.php:35 |
| 14 | __TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:23 |
| 7 | require JROOT/templates/g5_hydrogen/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 |
Время запроса: 1.98 ms После последнего запроса: 11.29 ms Память запроса: 0.038 MB. Память перед запросом: 4.568 MB Возвращено строк: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM k0nc_modules AS m
LEFT JOIN k0nc_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN k0nc_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-29 14:13:29')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-29 14:13:29')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 117 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | PRIMARY,published,newsfeeds | INDEX KEY не используется | NULL | NULL | 32 | 3.12 | Using where; Используется сортировка файлов |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | keuees_konc.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | keuees_konc.m.id | 1 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.30 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.12 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.07 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 ms |
| # | Вызывающий объект | Файл и номер строки |
|---|
| 52 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 51 | JDatabaseDriver->loadObjectList() | Такой же, как вызов в строке ниже |
| 50 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 49 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 48 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 47 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 46 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233 |
| 45 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704 |
| 44 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/8a/8aa5ed13afe614290bdbe5802a199e9e06543065eb1031106ac09341b9555df7.php:43 |
| 43 | __TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216 |
| 42 | Twig\Template->displayBlock() | JROOT/cache/gantry5/g5_hydrogen/twig/2b/2b7057a53c7fae43dedb18c6597d67a67503946ea7f781a45fc50e72ff8abdec.php:73 |
| 41 | __TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 40 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 39 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/8a/8aa5ed13afe614290bdbe5802a199e9e06543065eb1031106ac09341b9555df7.php:35 |
| 38 | __TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 37 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 36 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/47/47363a3d3a79d6d5090c614f67325a2ea4e4ddd366b811676d5468c5cdb53c60.php:53 |
| 35 | __TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 34 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 33 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
| 32 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 31 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 30 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 29 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:769 |
| 28 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:668 |
| 27 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:595 |
| 26 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:581 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:424 |
| 22 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702 |
| 21 | Twig\Template->getAttribute() | JROOT/cache/gantry5/g5_hydrogen/twig/e8/e8a7820de124bf69728a19f34f61992fdc1c43ab0fd0542c209abc8d6843c2cf.php:47 |
| 20 | __TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 19 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 18 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/8d/8da9c74876eba78eb8aef4f7a95e3838449d7ef48c73532b8526c5268febf94d.php:35 |
| 17 | __TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 16 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 15 | Twig\Template->display() | JROOT/cache/gantry5/g5_hydrogen/twig/81/8185070b0fb05aa12b3d83b5556f245a99ef880efa5e9468dd59cadefccbcfb3.php:35 |
| 14 | __TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455 |
| 13 | Twig\Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422 |
| 12 | Twig\Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434 |
| 11 | Twig\Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47 |
| 10 | Twig\TemplateWrapper->render() | JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384 |
| 9 | Twig\Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/g5_hydrogen/index.php:23 |
| 7 | require JROOT/templates/g5_hydrogen/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 |
