{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1660227653,
                "last": 1660227653,
                "now": 1660227653
            },
            "token": "4gx3LAoUb3keXiUMDgBIyUI27vEWrjaX"
        },
        "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
        },
        "js_id_currency_orig": "1",
        "js_id_currency": "1"
    }
}

Время

Память

42 запросов зарегистрировано 29.60 ms

1. Время запроса: 0.32 ms Память запроса: 0.023 MB. Память перед запросом: 4.184 MB Возвращено строк: 0

   SELECT `data`
   
     FROM `lzhkd_session`
   
     WHERE `session_id` = X'3765313439653566613263303335383834633436643262393037393737646565'

   План запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lzhkd_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Профиль

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   executing	0.01 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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

2. Время запроса: 0.17 ms После последнего запроса: 1.15 ms Память запроса: 0.020 MB. Память перед запросом: 4.279 MB Возвращено строк: 0

   SELECT `session_id`
   
     FROM `lzhkd_session`
   
     WHERE `session_id` = X'3765313439653566613263303335383834633436643262393037393737646565' 
     LIMIT 1

   План запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lzhkd_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Профиль

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.02 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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

3. Время запроса: 0.28 ms После последнего запроса: 0.07 ms Память запроса: 0.004 MB. Память перед запросом: 4.284 MB

   INSERT INTO `lzhkd_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3765313439653566613263303335383834633436643262393037393737646565', 1, 1660227653, 0, '', 0)

   План запросов (Explain)

   EXPLAIN недоступен для: INSERT INTO `lzhkd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3765313439653566613263303335383834633436643262393037393737646565', 1, 1660227653, 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.13 ms
   Waiting for query cache lock	0.00 ms
   update	0.00 ms
   end	0.00 ms
   query end	0.04 ms
   closing tables	0.02 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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

4. Время запроса: 0.27 ms После последнего запроса: 5.39 ms Память запроса: 0.021 MB. Память перед запросом: 4.844 MB Возвращено строк: 5

   SELECT id, rules
   
     FROM `lzhkd_viewlevels`

   План запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lzhkd_viewlevels	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	5	100.00	NULL

   Профиль

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.07 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.02 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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

5. Время запроса: 0.35 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB. Память перед запросом: 4.856 MB Возвращено строк: 2

   SELECT b.id
   
     FROM lzhkd_usergroups AS a
   
     LEFT JOIN lzhkd_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   План запросов (Explain)

   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.05 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.13 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.03 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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

6. Время запроса: 0.41 ms После последнего запроса: 11.58 ms Память запроса: 0.022 MB. Память перед запросом: 6.261 MB Возвращено строк: 1
   Повторяющиеся запросы: #7

   SELECT template
   
     FROM lzhkd_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   План запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	INDEX KEY не используется	NULL	NULL	59	9.66	Using where

   Профиль

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.08 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php: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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

7. Время запроса: 0.17 ms После последнего запроса: 0.07 ms Память запроса: 0.023 MB. Память перед запросом: 6.268 MB Возвращено строк: 1
   Повторяющиеся запросы: #6

   SELECT template
   
     FROM lzhkd_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   План запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	INDEX KEY не используется	NULL	NULL	59	9.66	Using where

   Профиль

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php: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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

8. Время запроса: 0.32 ms После последнего запроса: 3.02 ms Память запроса: 0.021 MB. Память перед запросом: 6.573 MB Возвращено строк: 2

   SELECT extension, file, type
   
     FROM lzhkd_rokcommon_configs
   
     ORDER BY priority

   План запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	lzhkd_rokcommon_configs	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	100.00	Используется сортировка файлов

   Профиль

   Status	Duration
   starting	0.05 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.02 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.09 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
   8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php: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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

9. Время запроса: 1.03 ms После последнего запроса: 32.36 ms Память запроса: 0.026 MB. Память перед запросом: 9.191 MB Возвращено строк: 18

   SHOW FULL COLUMNS 
     FROM `lzhkd_extensions`

   План запросов (Explain)

   EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `lzhkd_extensions`

   Профиль

   Status	Duration
   starting	0.05 ms
   checking permissions	0.03 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.01 ms
   preparing	0.01 ms
   executing	0.02 ms
   Opening tables	0.05 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   Sending data	0.05 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.00 ms
   removing tmp table	0.25 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
   13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
   12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
   11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
   10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
   9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
   8	plgSystemRokSprocket->onAfterInitialise()	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:668
   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

   [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

   ---

10. Время запроса: 0.31 ms После последнего запроса: 0.55 ms Память запроса: 0.021 MB. Память перед запросом: 9.234 MB Возвращено строк: 1

    SELECT `extension_id`
    
      FROM `lzhkd_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Профиль

    Status	Duration
    starting	0.05 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.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
    8	plgSystemRokSprocket->onAfterInitialise()	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:668
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

11. Время запроса: 0.16 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB. Память перед запросом: 9.241 MB Возвращено строк: 1
    Повторяющиеся запросы: #13

    SELECT *
    
      FROM lzhkd_extensions
    
      WHERE `extension_id` = '10242'

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.03 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:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	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:668
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

12. Время запроса: 0.18 ms После последнего запроса: 0.06 ms Память запроса: 0.021 MB. Память перед запросом: 9.245 MB Возвращено строк: 1

    SELECT `extension_id`
    
      FROM `lzhkd_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Профиль

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 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:1740
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
    8	plgSystemRokSprocket->onAfterInitialise()	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:668
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

13. Время запроса: 0.14 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB. Память перед запросом: 9.251 MB Возвращено строк: 1
    Повторяющиеся запросы: #11

    SELECT *
    
      FROM lzhkd_extensions
    
      WHERE `extension_id` = '10242'

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    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.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	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:668
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

14. Время запроса: 0.71 ms После последнего запроса: 50.50 ms Память запроса: 0.027 MB. Память перед запросом: 14.617 MB Возвращено строк: 47

    SELECT s.id, s.template, s.home, s.title AS long_title, s.params
    
      FROM lzhkd_template_styles AS s
    
      WHERE s.client_id = 0 
      AND s.template = 'rt_notio'
    
      ORDER BY s.id

    План запросов (Explain)

    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	47	96.61	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.26 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69
    14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63
    13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301
    12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99
    11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86
    10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:315
    9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:108
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

15. Время запроса: 0.69 ms После последнего запроса: 5.94 ms Память запроса: 0.007 MB. Память перед запросом: 15.155 MB

    UPDATE `lzhkd_extensions`
    
      SET `params` = '{\"mediaversion\":\"6061a942e2cf4d3bb0a9715dfc5019f4\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	lzhkd_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.11 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.16 ms
    updating	0.09 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.05 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:337
    10	NRFramework\Functions::isFeed()	JROOT/plugins/system/convertforms/convertforms.php:457
    9	PlgSystemConvertForms->getHelper()	JROOT/plugins/system/convertforms/convertforms.php:101
    8	PlgSystemConvertForms->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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

16. Время запроса: 1.37 ms После последнего запроса: 8.71 ms Память запроса: 0.029 MB. Память перед запросом: 15.921 MB Возвращено строк: 44

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `lzhkd_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_joomlaupdate','com_jshopping','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_quickform','com_redirect','com_roksprocket','com_rstbox','com_search','com_tags','com_templates','com_users','com_wrapper','com_xmap')

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	45	100.00	Using index condition

    Профиль

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.13 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.20 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.53 ms
    end	0.00 ms
    query end	0.03 ms
    closing tables	0.04 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_content/models/category.php:139
    14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

17. Время запроса: 1.09 ms После последнего запроса: 0.19 ms Память запроса: 0.088 MB. Память перед запросом: 15.977 MB Возвращено строк: 570

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `lzhkd_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_assets	NULL	ALL	idx_asset_name,idx_parent_id	INDEX KEY не используется	NULL	NULL	901	20.35	Using where

    Профиль

    Status	Duration
    starting	0.04 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.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.82 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    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_content/models/category.php:139
    14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

18. Время запроса: 1.23 ms После последнего запроса: 2.49 ms Память запроса: 0.026 MB. Память перед запросом: 16.516 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,(
    SELECT COUNT(i.`id`)
    
      FROM `lzhkd_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `lzhkd_categories` AS `s`
    
      INNER JOIN `lzhkd_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id = 94
    
      ORDER BY c.lft

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется сортировка файлов
    1	PRIMARY	c	NULL	ALL	cat_idx,idx_left_right	INDEX KEY не используется	NULL	NULL	250	36.46	Using where
    2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	a315920_425S2.c.id	1	100.00	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.14 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.37 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    14	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

19. Время запроса: 2.36 ms После последнего запроса: 2.02 ms Память запроса: 0.026 MB. Память перед запросом: 16.679 MB Возвращено строк: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM lzhkd_content AS a
    
      LEFT JOIN lzhkd_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN lzhkd_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN lzhkd_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN lzhkd_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN lzhkd_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 94 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-11 14:20:53') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-11 14:20:53')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 1

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Используется сортировка файлов
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	16.00	Using index condition; Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.modified_by	1	100.00	Using where
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.id	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.29 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.07 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	1.40 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

20. Время запроса: 0.43 ms После последнего запроса: 1.20 ms Память запроса: 0.025 MB. Память перед запросом: 16.801 MB Возвращено строк: 1

    SELECT COUNT(*)
    
      FROM lzhkd_content AS a
    
      LEFT JOIN lzhkd_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN lzhkd_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN lzhkd_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN lzhkd_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN lzhkd_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 94 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-08-11 14:20:53') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-08-11 14:20:53')

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	16.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.created_by	1	100.00	Using where; Using index
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.id	1	100.00	Using where; Using index

    Профиль

    Status	Duration
    starting	0.08 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.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
    16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
    15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

21. Время запроса: 0.35 ms После последнего запроса: 1.65 ms Память запроса: 0.023 MB. Память перед запросом: 16.997 MB Возвращено строк: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `lzhkd_contentitem_tag_map` AS m 
    
      INNER JOIN `lzhkd_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 94 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	INDEX KEY не используется	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	a315920_425S2.m.tag_id	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

22. Время запроса: 0.95 ms После последнего запроса: 12.18 ms Память запроса: 0.027 MB. Память перед запросом: 17.912 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 `lzhkd_categories` AS `s`
    
      INNER JOIN `lzhkd_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 = 94
    
      ORDER BY c.lft

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется сортировка файлов
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	INDEX KEY не используется	NULL	NULL	250	36.75	Using where

    Профиль

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.16 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.34 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

23. Время запроса: 1.35 ms После последнего запроса: 0.14 ms Память запроса: 0.025 MB. Память перед запросом: 17.929 MB Возвращено строк: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM lzhkd_fields AS a
    
      LEFT JOIN `lzhkd_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lzhkd_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lzhkd_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lzhkd_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lzhkd_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `lzhkd_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 (94,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 ASC

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Используется сортировка файлов
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	a315920_425S2.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	a315920_425S2.a.id	1	100.00	Using where; Using index; Distinct

    Профиль

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    Creating tmp table	0.08 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.34 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.23 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

24. Время запроса: 3.84 ms После последнего запроса: 4.97 ms Память запроса: 0.224 MB. Память перед запросом: 18.347 MB Возвращено строк: 184

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM lzhkd_modules AS m
    
      LEFT JOIN lzhkd_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN lzhkd_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 <= '2022-08-11 14:20:53') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-08-11 14:20:53') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 327 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    План запросов (Explain)

    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	230	1.46	Using where; Используется сортировка файлов
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	a315920_425S2.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	a315920_425S2.m.id	1	40.00	Using where; Using index

    Профиль

    Status	Duration
    starting	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	3.34 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.06 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
    16	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/plugins/content/loadmodule/loadmodule.php:200
    15	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:120
    14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

25. Время запроса: 1.00 ms После последнего запроса: 8.39 ms Память запроса: 0.061 MB. Память перед запросом: 19.083 MB Возвращено строк: 16

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM lzhkd_roksprocket_items as i
    
      WHERE i.module_id = '683' 
      AND i.provider = 'simple'
    
      ORDER BY i.
      order

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	idx_module,idx_module_order	idx_module_order	137	const	16	10.00	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.54 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    30	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
    29	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    28	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    27	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    26	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    25	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    24	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    23	ModRokSprocket->_realGetData()	Такой же, как вызов в строке ниже
    22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:78
    20	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    19	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    18	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:215
    15	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:120
    14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

26. Время запроса: 0.35 ms После последнего запроса: 1.75 ms Память запроса: 0.062 MB. Память перед запросом: 19.258 MB Возвращено строк: 16

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM lzhkd_roksprocket_items as i
    
      WHERE i.module_id = '683' 
      AND i.provider = 'simple'

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	idx_module,idx_module_order	idx_module	137	const	16	10.00	Using where

    Профиль

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
    30	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
    29	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    28	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    27	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    26	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    25	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    24	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    23	ModRokSprocket->_realGetData()	Такой же, как вызов в строке ниже
    22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:78
    20	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    19	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    18	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:215
    15	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:120
    14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

27. Время запроса: 0.42 ms После последнего запроса: 19.71 ms Память запроса: 0.024 MB. Память перед запросом: 19.608 MB Возвращено строк: 1

    SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
    
      FROM `lzhkd_contact_details` AS `contact`
    
      WHERE contact.published = 1 
      AND contact.user_id = 891

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	contact	NULL	ref	idx_state	idx_state	1	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:125
    15	PlgContentContact->getContactData()	JROOT/plugins/content/contact/contact.php:66
    14	PlgContentContact->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

28. Время запроса: 1.03 ms После последнего запроса: 1.71 ms Память запроса: 0.027 MB. Память перед запросом: 19.736 MB Возвращено строк: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM lzhkd_fields AS a
    
      LEFT JOIN `lzhkd_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lzhkd_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lzhkd_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lzhkd_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lzhkd_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_content.categories' 
      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 ASC

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Используется сортировка файлов
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	a315920_425S2.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.group_id	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.11 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    Creating tmp table	0.07 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.24 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.23 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:19
    15	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

29. Время запроса: 0.71 ms После последнего запроса: 0.38 ms Память запроса: 0.027 MB. Память перед запросом: 19.750 MB Возвращено строк: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM lzhkd_fields AS a
    
      LEFT JOIN `lzhkd_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lzhkd_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lzhkd_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lzhkd_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lzhkd_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `lzhkd_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.categories' 
      AND (fc.category_id IS NULL OR fc.category_id IN (94,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 ASC

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Используется сортировка файлов
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	a315920_425S2.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	a315920_425S2.a.id	1	100.00	Using where; Using index; Distinct

    Профиль

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.15 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.08 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    19	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
    18	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:22
    15	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    11	ContentViewCategory->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

30. Время запроса: 0.26 ms После последнего запроса: 5.95 ms Память запроса: 0.020 MB. Память перед запросом: 19.812 MB Возвращено строк: 2

    SELECT `id`
    
      FROM `lzhkd_rstbox`
    
      WHERE `published` = 1 
      AND `testmode` = 0

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_rstbox	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	50.00	Using where

    Профиль

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.02 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.05 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    9	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41
    8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	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/SiteApplication.php:199
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

31. Время запроса: 0.16 ms После последнего запроса: 1.05 ms Память запроса: 0.021 MB. Память перед запросом: 19.886 MB Возвращено строк: 1

    SELECT *
    
      FROM `lzhkd_rstbox`
    
      WHERE `id` = 1

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_rstbox	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.02 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.03 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rstbox/EngageBox/Box.php:226
    9	EngageBox\Box::get()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:51
    8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	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/SiteApplication.php:199
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

32. Время запроса: 0.40 ms После последнего запроса: 6.37 ms Память запроса: 0.021 MB. Память перед запросом: 20.153 MB Возвращено строк: 1

    SELECT *
    
      FROM `lzhkd_rstbox`
    
      WHERE `id` = 2

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_rstbox	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rstbox/EngageBox/Box.php:226
    9	EngageBox\Box::get()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:51
    8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	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/SiteApplication.php:199
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

33. Время запроса: 0.31 ms После последнего запроса: 2.73 ms Память запроса: 0.026 MB. Память перед запросом: 20.351 MB Возвращено строк: 1

    SELECT *
    
      FROM `lzhkd_convertforms`
    
      WHERE `id` = 2 
      AND `state` = 1

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_convertforms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 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.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_convertforms/ConvertForms/Form.php:59
    19	ConvertForms\Form::load()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:512
    18	ConvertForms\Helper::renderFormById()	JROOT/plugins/system/convertforms/convertforms.php:170
    17	PlgSystemConvertForms::process()	Такой же, как вызов в строке ниже
    16	preg_replace_callback()	JROOT/plugins/system/convertforms/convertforms.php:133
    15	PlgSystemConvertForms->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    12	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:59
    8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	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/SiteApplication.php:199
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

34. Время запроса: 0.32 ms После последнего запроса: 8.67 ms Память запроса: 0.025 MB. Память перед запросом: 20.677 MB Возвращено строк: 1

    SELECT *
    
      FROM `lzhkd_convertforms`
    
      WHERE `id` = 1 
      AND `state` = 1

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_convertforms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_convertforms/ConvertForms/Form.php:59
    19	ConvertForms\Form::load()	JROOT/administrator/components/com_convertforms/ConvertForms/Helper.php:512
    18	ConvertForms\Helper::renderFormById()	JROOT/plugins/system/convertforms/convertforms.php:170
    17	PlgSystemConvertForms::process()	Такой же, как вызов в строке ниже
    16	preg_replace_callback()	JROOT/plugins/system/convertforms/convertforms.php:133
    15	PlgSystemConvertForms->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    12	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
    11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:59
    8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->onAfterDispatch()	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/SiteApplication.php:199
    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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

35. Время запроса: 1.10 ms После последнего запроса: 38.98 ms Память запроса: 0.040 MB. Память перед запросом: 25.025 MB Возвращено строк: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM lzhkd_fields AS a
    
      LEFT JOIN `lzhkd_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN lzhkd_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN lzhkd_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN lzhkd_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN lzhkd_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      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 ASC

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Используется сортировка файлов
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	a315920_425S2.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	a315920_425S2.a.group_id	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.17 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.23 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.14 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    57	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    56	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    55	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    54	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    53	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    52	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    51	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    50	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    49	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
    48	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    47	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    46	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:243
    45	Gantry\Framework\Platform->filter()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/76/76a8a988d7735dbe40e80e4f2e21c76a95a7402275b0d81ed8d9d63621363753.php:46
    43	__TwigTemplate_9de61b1bffe5e4a300450305c980a111457a1e69ae8a37f594f6d850e7ecea28->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_notio/twig/e5/e5268dffce800e3c934a305acccd3e212756d65eef04442b9038dbd3c1e2f733.php:73
    41	__TwigTemplate_84e322db953f2d6464056719dbd6a850301d1462f5c47ceb9aa272fe8d33a3ce->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/76/76a8a988d7735dbe40e80e4f2e21c76a95a7402275b0d81ed8d9d63621363753.php:35
    38	__TwigTemplate_9de61b1bffe5e4a300450305c980a111457a1e69ae8a37f594f6d850e7ecea28->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/2d/2d54cc18d549391dc4d426f37c856c7526b84be1692b12ccfdbdac470f67aacf.php:85
    35	__TwigTemplate_c2890f2e1d1f87bc21b2d5a04cd7a9f8f619c08de0b88d6c63c69a77171dec0f->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

36. Время запроса: 0.28 ms После последнего запроса: 4.38 ms Память запроса: 0.035 MB. Память перед запросом: 25.395 MB Возвращено строк: 9

    SELECT `a`.`menutype`,`a`.`title`
    
      FROM `lzhkd_menu_types` AS `a`
    
      WHERE `a`.`client_id` = 0

    План запросов (Explain)

    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	9	11.11	Using where

    Профиль

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.02 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.06 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    43	JDatabaseDriver->loadAssocList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138
    42	Gantry\Framework\Menu->getMenuOptions()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:115
    41	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:274
    40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    39	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/7d/7de55bdbe5d1b2d3174b39b5634ba29e07f32412588c4d8c675de890d7a8359f.php:32
    38	__TwigTemplate_7d723ece087eed21407a873d695d18df55edc9a8cf166b695bf2d1847854c2f1->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/2d/2d54cc18d549391dc4d426f37c856c7526b84be1692b12ccfdbdac470f67aacf.php:85
    35	__TwigTemplate_c2890f2e1d1f87bc21b2d5a04cd7a9f8f619c08de0b88d6c63c69a77171dec0f->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

37. Время запроса: 0.68 ms После последнего запроса: 0.91 ms Память запроса: 0.038 MB. Память перед запросом: 25.490 MB Возвращено строк: 27

    SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
    
      FROM lzhkd_menu AS m
    
      WHERE m.menutype = 'mainmenu' 
      AND m.parent_id > 0 
      AND m.client_id = 0 
      AND m.published >= 0
    
      ORDER BY m.lft

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype	idx_menutype	98	const	43	27.70	Using index condition; Using where; Используется сортировка файлов

    Профиль

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.36 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.05 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    44	JDatabaseDriver->loadAssocList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791
    43	Gantry\Framework\Menu->getMenuItemIds()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:310
    42	Gantry\Framework\Menu->getItemsFromPlatform()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:753
    41	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:316
    40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    39	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/7d/7de55bdbe5d1b2d3174b39b5634ba29e07f32412588c4d8c675de890d7a8359f.php:32
    38	__TwigTemplate_7d723ece087eed21407a873d695d18df55edc9a8cf166b695bf2d1847854c2f1->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/2d/2d54cc18d549391dc4d426f37c856c7526b84be1692b12ccfdbdac470f67aacf.php:85
    35	__TwigTemplate_c2890f2e1d1f87bc21b2d5a04cd7a9f8f619c08de0b88d6c63c69a77171dec0f->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

38. Время запроса: 1.53 ms После последнего запроса: 49.65 ms Память запроса: 0.072 MB. Память перед запросом: 28.608 MB Возвращено строк: 140

    SHOW FULL COLUMNS 
      FROM `lzhkd_jshopping_config`

    План запросов (Explain)

    EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `lzhkd_jshopping_config`

    Профиль

    Status	Duration
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 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
    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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.03 ms
    Sending data	0.16 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.15 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    70	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    69	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    68	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    67	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    66	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/config.php:14
    65	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
    64	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    63	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    62	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    61	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
    60	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    59	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    58	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    57	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    56	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    55	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    54	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    53	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    52	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    51	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    50	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    49	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    48	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    47	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    46	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294
    45	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:43
    43	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_notio/twig/e5/e5268dffce800e3c934a305acccd3e212756d65eef04442b9038dbd3c1e2f733.php:73
    41	__TwigTemplate_84e322db953f2d6464056719dbd6a850301d1462f5c47ceb9aa272fe8d33a3ce->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:35
    38	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/48/48ef1b23c94cc7b5a1425f0ad17f0653142e89228846834b81ddd6ac93703b50.php:53
    35	__TwigTemplate_09fee88b1cddba1c6d735d02ff9988caa2ba68fcd33342ba2110f1d58b53118d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

39. Время запроса: 0.45 ms После последнего запроса: 1.01 ms Память запроса: 0.125 MB. Память перед запросом: 28.866 MB Возвращено строк: 1

    SELECT *
    
      FROM lzhkd_jshopping_config
    
      WHERE `id` = '1'

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_jshopping_config	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    67	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    66	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    65	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/lib/factory.php:30
    64	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    63	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    62	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    61	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
    60	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    59	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    58	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    57	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    56	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    55	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    54	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    53	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    52	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    51	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    50	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    49	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    48	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    47	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    46	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294
    45	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:43
    43	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_notio/twig/e5/e5268dffce800e3c934a305acccd3e212756d65eef04442b9038dbd3c1e2f733.php:73
    41	__TwigTemplate_84e322db953f2d6464056719dbd6a850301d1462f5c47ceb9aa272fe8d33a3ce->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:35
    38	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/48/48ef1b23c94cc7b5a1425f0ad17f0653142e89228846834b81ddd6ac93703b50.php:53
    35	__TwigTemplate_09fee88b1cddba1c6d735d02ff9988caa2ba68fcd33342ba2110f1d58b53118d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

40. Время запроса: 0.43 ms После последнего запроса: 0.45 ms Память запроса: 0.053 MB. Память перед запросом: 28.894 MB Возвращено строк: 8

    SHOW FULL COLUMNS 
      FROM `lzhkd_jshopping_currencies`

    План запросов (Explain)

    EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `lzhkd_jshopping_currencies`

    Профиль

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.07 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    74	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    73	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    72	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    71	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    70	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
    69	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:328
    68	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
    67	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:569
    66	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    65	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    64	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    63	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    62	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    61	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
    60	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    59	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    58	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    57	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    56	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    55	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    54	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    53	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    52	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    51	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    50	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    49	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    48	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    47	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    46	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294
    45	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:43
    43	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_notio/twig/e5/e5268dffce800e3c934a305acccd3e212756d65eef04442b9038dbd3c1e2f733.php:73
    41	__TwigTemplate_84e322db953f2d6464056719dbd6a850301d1462f5c47ceb9aa272fe8d33a3ce->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:35
    38	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/48/48ef1b23c94cc7b5a1425f0ad17f0653142e89228846834b81ddd6ac93703b50.php:53
    35	__TwigTemplate_09fee88b1cddba1c6d735d02ff9988caa2ba68fcd33342ba2110f1d58b53118d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

41. Время запроса: 0.28 ms После последнего запроса: 0.12 ms Память запроса: 0.050 MB. Память перед запросом: 28.939 MB Возвращено строк: 1

    SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
      FROM `lzhkd_jshopping_currencies` 
      WHERE currency_publish = '1' 
      ORDER BY currency_ordering

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_jshopping_currencies	NULL	ref	currency_publish	currency_publish	1	const	1	100.00	Using index condition; Используется сортировка файлов

    Профиль

    Status	Duration
    starting	0.04 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
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.07 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    69	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    68	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
    67	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:570
    66	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
    65	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
    64	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
    63	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
    62	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1595
    61	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
    60	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    59	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    58	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    57	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    56	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    55	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    54	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    53	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    52	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    51	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    50	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    49	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    48	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    47	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    46	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294
    45	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:43
    43	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_notio/twig/e5/e5268dffce800e3c934a305acccd3e212756d65eef04442b9038dbd3c1e2f733.php:73
    41	__TwigTemplate_84e322db953f2d6464056719dbd6a850301d1462f5c47ceb9aa272fe8d33a3ce->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:35
    38	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/48/48ef1b23c94cc7b5a1425f0ad17f0653142e89228846834b81ddd6ac93703b50.php:53
    35	__TwigTemplate_09fee88b1cddba1c6d735d02ff9988caa2ba68fcd33342ba2110f1d58b53118d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---

42. Время запроса: 1.40 ms После последнего запроса: 0.11 ms Память запроса: 0.048 MB. Память перед запросом: 28.952 MB Возвращено строк: 4

    select id,link 
      from lzhkd_menu 
    			          
      where `type`='component' 
      and published=1 
      and link like '%option=com_jshopping%' 
      and client_id=0 
    					  
      and (language='*' or language='ru-RU') 
      and access IN (1,1,5)

    План запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lzhkd_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	242	0.34	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.05 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.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	1.16 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    65	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    64	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
    63	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
    62	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
    61	shopItemMenu::getInstance()	JROOT/components/com_jshopping/router.php:16
    60	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    59	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    58	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    57	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    56	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    55	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    54	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    53	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    52	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    51	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    50	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    49	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    48	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    47	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    46	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:294
    45	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
    44	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:43
    43	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->block_particle()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214
    42	Twig\Template->displayBlock()	JROOT/cache/gantry5/rt_notio/twig/e5/e5268dffce800e3c934a305acccd3e212756d65eef04442b9038dbd3c1e2f733.php:73
    41	__TwigTemplate_84e322db953f2d6464056719dbd6a850301d1462f5c47ceb9aa272fe8d33a3ce->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    39	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/ea/eac4c3a6debfbc4daf15f0fe32fc54c8cd8e1825ffa470d7e070d8b1f66697c5.php:35
    38	__TwigTemplate_790587944e0d35c4c603b04daaf0e9dd50d282f7ef96f37eb76d0ce6a83eeffd->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    36	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/48/48ef1b23c94cc7b5a1425f0ad17f0653142e89228846834b81ddd6ac93703b50.php:53
    35	__TwigTemplate_09fee88b1cddba1c6d735d02ff9988caa2ba68fcd33342ba2110f1d58b53118d->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
    28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
    27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
    26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
    23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
    22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
    21	Twig\Template->getAttribute()	JROOT/cache/gantry5/rt_notio/twig/38/3812505670f11bde876c7a68f28748b66bbe1adf678489b9f2054ba6a13ad5eb.php:47
    20	__TwigTemplate_4b8d0f7e1f8ae0570bdf7afd29d505f403ac271b326a522aa231db20cfdff69a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    18	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/32/32aaaa3fdb1ed2783d2924392019fdc5baa6882a4c2df7f6d5168f43cfed6eec.php:35
    17	__TwigTemplate_4193f48ae348449a7c3cc84b7f0fa4c30d98c5352e5af65aee59507bde72acd0->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    15	Twig\Template->display()	JROOT/cache/gantry5/rt_notio/twig/b5/b59f8c34ea31b8b43d19ca3b5b2b60698a8c2ee6a9c02e44c5fa0e6162b95b40.php:35
    14	__TwigTemplate_20f1a52bae3d2c1feb90fb8a2faff424448467bc0b00cac26144ceb14448191a->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
    13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
    12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
    11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
    10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
    9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
    8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_notio/index.php:30
    7	require JROOT/templates/rt_notio/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

    [Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

    ---