Детский сад № 1 «Теремок»

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1783872941,
                "last": 1783872941,
                "now": 1783872941
            },
            "client": {
                "forwarded": "216.73.216.173"
            },
            "token": "NgSbo6qBo04xS42J97N2iaddsmtPfCaq"
        },
        "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
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Время

Память

64 запросов зарегистрировано 259.34 ms

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

   SELECT `data`
   
     FROM `dr2cm_session`
   
     WHERE `session_id` = X'346c3336353571756d3671736666656f6562763376346b366c67'

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

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

   Профиль

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.07 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.37 ms После последнего запроса: 0.48 ms Память запроса: 0.020 MB. Память перед запросом: 1.041 MB Возвращено строк: 0

   SELECT `session_id`
   
     FROM `dr2cm_session`
   
     WHERE `session_id` = X'346c3336353571756d3671736666656f6562763376346b366c67' 
     LIMIT 1

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

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

   Профиль

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 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.49 ms После последнего запроса: 0.14 ms Память запроса: 0.004 MB. Память перед запросом: 1.046 MB

   INSERT INTO `dr2cm_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'346c3336353571756d3671736666656f6562763376346b366c67', 1, 1783872941, 0, '', 0)

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

   EXPLAIN недоступен для: INSERT INTO `dr2cm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'346c3336353571756d3671736666656f6562763376346b366c67', 1, 1783872941, 0, '', 0)

   Профиль

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.16 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.11 ms
   closing tables	0.01 ms
   freeing items	0.02 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.28 ms После последнего запроса: 6.75 ms Память запроса: 0.021 MB. Память перед запросом: 1.144 MB Возвращено строк: 5

   SELECT id, rules
   
     FROM `dr2cm_viewlevels`

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

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

   Профиль

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.06 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 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.74 ms После последнего запроса: 0.16 ms Память запроса: 0.021 MB. Память перед запросом: 1.156 MB Возвращено строк: 2

   SELECT b.id
   
     FROM dr2cm_usergroups AS a
   
     LEFT JOIN dr2cm_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
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.08 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.10 ms
   preparing	0.02 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Время запроса: 3.27 ms После последнего запроса: 0.56 ms Память запроса: 0.051 MB. Память перед запросом: 1.181 MB Возвращено строк: 142

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM dr2cm_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

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

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dr2cm_extensions	NULL	ref	extension	extension	82	const	170	0.60	Using where; Используется сортировка файлов

   Профиль

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.05 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.72 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 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:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Такой же, как вызов в строке ниже
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Время запроса: 0.49 ms После последнего запроса: 77.24 ms Память запроса: 0.022 MB. Память перед запросом: 5.347 MB Возвращено строк: 2

   SELECT *
   
     FROM dr2cm_languages
   
     ORDER BY ordering ASC

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

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

   Профиль

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.11 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.09 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
   12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
   11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
   10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
   9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:63
   8	plgSystemSh404sef->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 для получения ссылок на файлы]

   ---

8. Время запроса: 2.15 ms После последнего запроса: 2.47 ms Память запроса: 0.023 MB. Память перед запросом: 5.503 MB Возвращено строк: 1

   SELECT `params` 
     FROM dr2cm_extensions 
     WHERE `element`='com_sh404sef' 
     AND `type`='component';

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

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

   Профиль

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.11 ms
   preparing	0.02 ms
   executing	0.08 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
   14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
   13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
   12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
   11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:665
   10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
   9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:86
   8	plgSystemSh404sef->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 для получения ссылок на файлы]

   ---

9. Время запроса: 6.02 ms После последнего запроса: 19.04 ms Память запроса: 0.025 MB. Память перед запросом: 5.974 MB Возвращено строк: 4

   SELECT * 
     FROM `dr2cm_sh404sef_aliases` 
     WHERE `state` = 1 
     and (`alias` = 'detski-sad-1-schelkovo.html') 
     order by `ordering` asc

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

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dr2cm_sh404sef_aliases	NULL	ref	state,alias	alias	573	const	4	100.00	Using where; Используется сортировка файлов

   Профиль

   Status	Duration
   starting	0.11 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.14 ms
   preparing	0.03 ms
   executing	0.11 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
   16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:221
   15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:115
   14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
   13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
   12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:681
   11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:280
   10	Sh404sefClassRouterInternal->preprocessParseRule()	Такой же, как вызов в строке ниже
   9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
   7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
   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 для получения ссылок на файлы]

   ---

10. Время запроса: 66.23 ms После последнего запроса: 0.25 ms Память запроса: 3.259 MB. Память перед запросом: 5.983 MB Возвращено строк: 13535

    SELECT * 
      FROM dr2cm_sh404sef_aliases 
      WHERE state = 1 
      and (type = 1 or type = 2);

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

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

    Профиль

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.02 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    executing	64.91 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	5.98 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
    18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
    17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
    16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:285
    15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
    14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
    13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:205
    12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:681
    11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:280
    10	Sh404sefClassRouterInternal->preprocessParseRule()	Такой же, как вызов в строке ниже
    9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
    7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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 для получения ссылок на файлы]

    ---

11. Время запроса: 1.00 ms После последнего запроса: 305.33 ms Память запроса: 0.025 MB. Память перед запросом: 14.649 MB Возвращено строк: 4

    SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
      FROM dr2cm_sh404sef_urls 
      WHERE `oldurl`='detski-sad-1-schelkovo.html' 
      ORDER BY `rank`;

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

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

    Профиль

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.45 ms
    preparing	0.04 ms
    executing	0.18 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
    18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
    17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
    16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
    15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1740
    14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1334
    13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2384
    12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:435
    11	Sh404sefClassRouterInternal->parseRule()	Такой же, как вызов в строке ниже
    10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
    8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
    7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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 для получения ссылок на файлы]

    ---

12. Время запроса: 1.62 ms После последнего запроса: 0.23 ms Память запроса: 0.008 MB. Память перед запросом: 14.660 MB

    UPDATE `dr2cm_sh404sef_urls` 
      SET `cpt`=2469, `last_hit`='2026-07-12 16:15:41' 
      WHERE `id`='8106' 
      AND `rank`=0;

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

    EXPLAIN недоступен для: UPDATE `dr2cm_sh404sef_urls` SET `cpt`=2469, `last_hit`='2026-07-12 16:15:41' WHERE `id`='8106' AND `rank`=0;

    Профиль

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.10 ms
    updating	0.15 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.12 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
    17	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
    16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
    15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
    14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1353
    13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2384
    12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:435
    11	Sh404sefClassRouterInternal->parseRule()	Такой же, как вызов в строке ниже
    10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
    9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
    8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
    7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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 для получения ссылок на файлы]

    ---

13. Время запроса: 3.19 ms После последнего запроса: 3.64 ms Память запроса: 0.024 MB. Память перед запросом: 14.700 MB Возвращено строк: 8

    SHOW FULL COLUMNS 
      FROM `dr2cm_template_styles`

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

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

    Профиль

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.74 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.12 ms
    checking permissions	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.11 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    11	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1028
    9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
    8	plgSystemEF4_JMFramework->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 для получения ссылок на файлы]

    ---

14. Время запроса: 1.52 ms После последнего запроса: 0.33 ms Память запроса: 0.021 MB. Память перед запросом: 14.719 MB Возвращено строк: 1
    Повторяющиеся запросы: #61

    SELECT *
    
      FROM dr2cm_template_styles
    
      WHERE `id` = '12'

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

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

    Профиль

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1029
    9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
    8	plgSystemEF4_JMFramework->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.90 ms После последнего запроса: 5.82 ms Память запроса: 0.006 MB. Память перед запросом: 14.810 MB

    UPDATE `dr2cm_extensions`
    
      SET `params` = '{\"mediaversion\":\"774cdbf91c55e563b52f39c7eb566eb3\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

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

    EXPLAIN недоступен для: UPDATE `dr2cm_extensions` SET `params` = '{\"mediaversion\":\"774cdbf91c55e563b52f39c7eb566eb3\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.10 ms
    updating	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.07 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:294
    8	plgSystemEF4_JMFramework->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.70 ms После последнего запроса: 0.36 ms Память запроса: 0.022 MB. Память перед запросом: 14.899 MB Возвращено строк: 7

    SELECT id, home, template, s.params
    
      FROM dr2cm_template_styles as s
    
      LEFT JOIN dr2cm_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	vsesadiki_ru.e.element	1	81.82	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.12 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:2182
    10	JMFTemplate::getTemplateStyleId()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:136
    9	JMFTemplate->__construct()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:296
    8	plgSystemEF4_JMFramework->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 для получения ссылок на файлы]

    ---

17. Время запроса: 1.87 ms После последнего запроса: 10.05 ms Память запроса: 0.029 MB. Память перед запросом: 15.045 MB Возвращено строк: 43

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dr2cm_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_dbreplacer','com_djmediatools','com_fields','com_finder','com_gantry5','com_ijoomlainstaller','com_installer','com_jcomments','com_jmap','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sh404sef','com_tags','com_templates','com_uniform','com_users','com_wrapper')

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

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

    Профиль

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.13 ms
    preparing	0.02 ms
    executing	0.46 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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. Время запроса: 22.66 ms После последнего запроса: 0.24 ms Память запроса: 1.001 MB. Память перед запросом: 15.099 MB Возвращено строк: 7672

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dr2cm_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	dr2cm_assets	NULL	ALL	idx_asset_name,idx_parent_id	INDEX KEY не используется	NULL	NULL	12852	20.18	Using where

    Профиль

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	22.22 ms
    end	0.02 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	3.50 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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. Время запроса: 4.26 ms После последнего запроса: 31.35 ms Память запроса: 0.031 MB. Память перед запросом: 20.752 MB Возвращено строк: 31

    SHOW FULL COLUMNS 
      FROM `dr2cm_content`

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

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

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.44 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    executing	0.08 ms
    checking permissions	0.06 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.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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.04 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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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. Время запроса: 1.11 ms После последнего запроса: 1.50 ms Память запроса: 0.005 MB. Память перед запросом: 20.800 MB

    UPDATE dr2cm_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '5426'

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

    EXPLAIN недоступен для: UPDATE dr2cm_content SET `hits` = (`hits` + 1) WHERE `id` = '5426'

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.12 ms
    updating	0.17 ms
    end	0.01 ms
    query end	0.02 ms
    waiting for handler commit	0.10 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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. Время запроса: 4.68 ms После последнего запроса: 3.64 ms Память запроса: 0.023 MB. Память перед запросом: 20.847 MB Возвращено строк: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM dr2cm_content AS a
    
      INNER JOIN dr2cm_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN dr2cm_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN dr2cm_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN dr2cm_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 5426 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-12 16:15:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 16:15:41') 
      AND (a.state = 1 OR a.state =2)

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

    Профиль

    Status	Duration
    starting	0.26 ms
    Executing hook on transaction	0.01 ms
    starting	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
    Opening tables	0.20 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.05 ms
    statistics	0.35 ms
    preparing	0.04 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	0.23 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->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. Время запроса: 1.65 ms После последнего запроса: 3.46 ms Память запроса: 0.028 MB. Память перед запросом: 20.942 MB Возвращено строк: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_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 = 389
    
      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	484	63.84	Using where

    Профиль

    Status	Duration
    starting	0.18 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.18 ms
    preparing	0.04 ms
    executing	0.90 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Такой же, как вызов в строке ниже
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->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. Время запроса: 0.69 ms После последнего запроса: 13.79 ms Память запроса: 0.029 MB. Память перед запросом: 21.608 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1032&catid=389&id=5426&lang=ru&view=article';

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_sh404sef_urls	NULL	ref	newurl	newurl	573	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.18 ms
    preparing	0.02 ms
    executing	0.09 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    29	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    28	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    27	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    26	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:778
    25	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    24	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    23	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    22	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    21	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    20	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    18	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    16	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->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. Время запроса: 6.38 ms После последнего запроса: 0.56 ms Память запроса: 0.022 MB. Память перед запросом: 21.623 MB Возвращено строк: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `dr2cm_contentitem_tag_map` AS m 
    
      INNER JOIN `dr2cm_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 5426 
      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	8366	1.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	vsesadiki_ru.m.tag_id	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	2.41 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    11	ContentViewArticle->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. Время запроса: 0.42 ms После последнего запроса: 30.42 ms Память запроса: 0.027 MB. Память перед запросом: 22.401 MB Возвращено строк: 0
    Повторяющиеся запросы: #30

    SELECT m.*
    
      FROM dr2cm_modules AS m
    
      LEFT JOIN dr2cm_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.client_id = 0 
      AND m.id = 586 
      AND m.access IN (1,1,5) 
      AND m.published = 1 
      AND e.enabled = 1
    
      ORDER BY m.ordering

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    25	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:672
    24	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:555
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:299
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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. Время запроса: 6.79 ms После последнего запроса: 0.62 ms Память запроса: 0.027 MB. Память перед запросом: 22.429 MB Возвращено строк: 1
    Повторяющиеся запросы: #31

    SELECT m.*
    
      FROM dr2cm_modules AS m
    
      LEFT JOIN dr2cm_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.client_id = 0 
      AND m.id = 1413 
      AND m.access IN (1,1,5) 
      AND m.published = 1 
      AND e.enabled = 1
    
      ORDER BY m.ordering

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	10.00	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    25	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:672
    24	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:555
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:299
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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. Время запроса: 23.30 ms После последнего запроса: 0.82 ms Память запроса: 0.029 MB. Память перед запросом: 22.491 MB Возвращено строк: 1
    Повторяющиеся запросы: #32

    SELECT c.id, c.title, c.catid, c.alias, c.metadata, f_gps_points.value as f_gps_points, f_point_marker.value as f_point_marker, f_point_names.value as f_point_names
    
      FROM dr2cm_content as c
    
      LEFT JOIN `dr2cm_fields_values` AS `f_gps_points` 
      ON (`c`.`id` = `f_gps_points`.`item_id`) 
      AND f_gps_points.field_id=8
    
      LEFT JOIN `dr2cm_fields_values` AS `f_point_marker` 
      ON (`c`.`id` = `f_point_marker`.`item_id`) 
      AND f_point_marker.field_id=5
    
      LEFT JOIN `dr2cm_fields_values` AS `f_point_names` 
      ON (`c`.`id` = `f_point_names`.`item_id`) 
      AND f_point_names.field_id=9
    
      WHERE c.id = '5426'
    
      GROUP BY c.id

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	f_gps_points	NULL	ref	idx_field_id,idx_item_id	idx_field_id	4	const	4325	100.00	Using where
    1	SIMPLE	f_point_marker	NULL	ref	idx_field_id,idx_item_id	idx_field_id	4	const	5040	100.00	Using where
    1	SIMPLE	f_point_names	NULL	ref	idx_field_id,idx_item_id	idx_field_id	4	const	6	100.00	Using where

    Профиль

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.05 ms
    executing	22.64 ms
    end	0.02 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	2.02 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_community_links/helper.php:87
    27	mod_com_links::mod_get_result()	JROOT/modules/mod_community_links/mod_community_links.php:30
    26	include JROOT/modules/mod_community_links/mod_community_links.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/src/Replace.php:596
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:299
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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. Время запроса: 2.04 ms После последнего запроса: 0.38 ms Память запроса: 0.034 MB. Память перед запросом: 22.508 MB Возвращено строк: 0

    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 `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_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 = 5426
    
      ORDER BY c.lft

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

    Профиль

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	4.67 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    40	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    39	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    38	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    37	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    36	ContentRouter->getCategorySegment()	Такой же, как вызов в строке ниже
    35	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
    34	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    33	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    32	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    31	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    30	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    29	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    28	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    27	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_community_links/mod_community_links.php:137
    26	include JROOT/modules/mod_community_links/mod_community_links.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/src/Replace.php:596
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:299
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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. Время запроса: 4.51 ms После последнего запроса: 0.41 ms Память запроса: 0.036 MB. Память перед запросом: 22.533 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1032&id=5426&lang=ru&view=article';

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_sh404sef_urls	NULL	ref	newurl	newurl	573	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.76 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    44	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    43	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    42	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    41	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:778
    40	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    39	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    38	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    37	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    36	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    35	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    34	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    33	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    32	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    31	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    30	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    29	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    28	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    27	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_community_links/mod_community_links.php:137
    26	include JROOT/modules/mod_community_links/mod_community_links.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/src/Replace.php:596
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:299
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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.34 ms После последнего запроса: 0.67 ms Память запроса: 0.027 MB. Память перед запросом: 22.525 MB Возвращено строк: 0
    Повторяющиеся запросы: #25

    SELECT m.*
    
      FROM dr2cm_modules AS m
    
      LEFT JOIN dr2cm_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.client_id = 0 
      AND m.id = 586 
      AND m.access IN (1,1,5) 
      AND m.published = 1 
      AND e.enabled = 1
    
      ORDER BY m.ordering

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

    Профиль

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.77 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    25	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:672
    24	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:555
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:308
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

31. Время запроса: 0.84 ms После последнего запроса: 0.18 ms Память запроса: 0.027 MB. Память перед запросом: 22.538 MB Возвращено строк: 1
    Повторяющиеся запросы: #26

    SELECT m.*
    
      FROM dr2cm_modules AS m
    
      LEFT JOIN dr2cm_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.client_id = 0 
      AND m.id = 1413 
      AND m.access IN (1,1,5) 
      AND m.published = 1 
      AND e.enabled = 1
    
      ORDER BY m.ordering

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	10.00	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.34 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    25	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:672
    24	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:555
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:308
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

32. Время запроса: 30.29 ms После последнего запроса: 0.27 ms Память запроса: 0.029 MB. Память перед запросом: 22.580 MB Возвращено строк: 1
    Повторяющиеся запросы: #27

    SELECT c.id, c.title, c.catid, c.alias, c.metadata, f_gps_points.value as f_gps_points, f_point_marker.value as f_point_marker, f_point_names.value as f_point_names
    
      FROM dr2cm_content as c
    
      LEFT JOIN `dr2cm_fields_values` AS `f_gps_points` 
      ON (`c`.`id` = `f_gps_points`.`item_id`) 
      AND f_gps_points.field_id=8
    
      LEFT JOIN `dr2cm_fields_values` AS `f_point_marker` 
      ON (`c`.`id` = `f_point_marker`.`item_id`) 
      AND f_point_marker.field_id=5
    
      LEFT JOIN `dr2cm_fields_values` AS `f_point_names` 
      ON (`c`.`id` = `f_point_names`.`item_id`) 
      AND f_point_names.field_id=9
    
      WHERE c.id = '5426'
    
      GROUP BY c.id

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	f_gps_points	NULL	ref	idx_field_id,idx_item_id	idx_field_id	4	const	4325	100.00	Using where
    1	SIMPLE	f_point_marker	NULL	ref	idx_field_id,idx_item_id	idx_field_id	4	const	5040	100.00	Using where
    1	SIMPLE	f_point_names	NULL	ref	idx_field_id,idx_item_id	idx_field_id	4	const	6	100.00	Using where

    Профиль

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	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.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	29.85 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	2.95 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_community_links/helper.php:87
    27	mod_com_links::mod_get_result()	JROOT/modules/mod_community_links/mod_community_links.php:30
    26	include JROOT/modules/mod_community_links/mod_community_links.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    25	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    24	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/modulesanywhere/src/Replace.php:596
    23	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:336
    22	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:216
    21	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:198
    20	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:157
    19	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:80
    18	PlgSystemModulesAnywhere->processArticle()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/regularlabs/src/Article.php:331
    16	RegularLabs\Library\Article::processText()	JROOT/libraries/regularlabs/src/Article.php:308
    15	RegularLabs\Library\Article::process()	JROOT/libraries/regularlabs/src/SystemPlugin.php:230
    14	RegularLabs\Library\SystemPlugin->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/article/view.html.php:193
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

33. Время запроса: 1.44 ms После последнего запроса: 2.81 ms Память запроса: 0.029 MB. Память перед запросом: 22.604 MB Возвращено строк: 5

    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 dr2cm_fields AS a
    
      LEFT JOIN `dr2cm_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN dr2cm_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN dr2cm_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN dr2cm_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN dr2cm_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `dr2cm_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 (389,0,471)) 
      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	5	100.00	Using where; Using temporary; Используется сортировка файлов
    1	SIMPLE	l	NULL	ALL	idx_langcode	INDEX KEY не используется	NULL	NULL	2	100.00	Using where; Using join buffer (hash join)
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	vsesadiki_ru.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	vsesadiki_ru.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	vsesadiki_ru.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	vsesadiki_ru.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	vsesadiki_ru.a.id	1	100.00	Using where; Using index; Distinct

    Профиль

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.21 ms
    preparing	0.04 ms
    Creating tmp table	0.14 ms
    executing	0.36 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	1.48 ms
    cleaning up	0.02 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/article/view.html.php:193
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

34. Время запроса: 1.26 ms После последнего запроса: 0.57 ms Память запроса: 0.024 MB. Память перед запросом: 22.654 MB Возвращено строк: 2

    SELECT `field_id`,`value`
    
      FROM `dr2cm_fields_values`
    
      WHERE `field_id` IN (5,8,9,10,11) 
      AND `item_id` = '5426'

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	2	100.00	Using where

    Профиль

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.13 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	1.55 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:680
    16	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
    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/article/view.html.php:193
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

35. Время запроса: 6.68 ms После последнего запроса: 14.25 ms Память запроса: 0.041 MB. Память перед запросом: 22.933 MB Возвращено строк: 41

    SHOW FULL COLUMNS 
      FROM `dr2cm_sh404sef_metas`

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

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

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.46 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.07 ms
    executing	0.09 ms
    checking permissions	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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.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.10 ms
    checking permissions	0.04 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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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.07 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    35	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    34	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    33	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    32	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:138
    31	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:328
    30	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:37
    29	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
    28	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:448
    27	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
    26	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/fields/textarea/tmpl/textarea.php:18
    19	include JROOT/plugins/fields/textarea/tmpl/textarea.php	JROOT/administrator/components/com_fields/libraries/fieldsplugin.php:134
    18	FieldsPlugin->onCustomFieldsPrepareField()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_fields/helpers/fields.php:201
    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/article/view.html.php:193
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

36. Время запроса: 0.75 ms После последнего запроса: 0.20 ms Память запроса: 0.032 MB. Память перед запросом: 22.990 MB Возвращено строк: 1

    SELECT * 
      FROM dr2cm_sh404sef_metas 
      WHERE `newurl`='index.php?option=com_content&Itemid=1032&catid=389&id=5426&lang=ru&view=article';

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_sh404sef_metas	NULL	ref	newurl	newurl	573	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.38 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    33	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    32	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    31	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    30	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:38
    29	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
    28	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:448
    27	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
    26	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    23	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
    22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/fields/textarea/tmpl/textarea.php:18
    19	include JROOT/plugins/fields/textarea/tmpl/textarea.php	JROOT/administrator/components/com_fields/libraries/fieldsplugin.php:134
    18	FieldsPlugin->onCustomFieldsPrepareField()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_fields/helpers/fields.php:201
    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/article/view.html.php:193
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

37. Время запроса: 0.38 ms После последнего запроса: 17.18 ms Память запроса: 0.024 MB. Память перед запросом: 23.084 MB Возвращено строк: 0

    SELECT * 
      FROM dr2cm_content_extravote 
      WHERE content_id=5426 
      AND extra_id = 0

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_content_extravote	NULL	ref	extravote_idx	extravote_idx	4	const	1	10.00	Using where

    Профиль

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/plugins/content/extravote/extravote.php:62
    15	plgContentExtraVote->ContentExtraVote()	JROOT/plugins/content/extravote/extravote.php:44
    14	plgContentExtraVote->onContentBeforeDisplay()	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/article/view.html.php:199
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

38. Время запроса: 1.90 ms После последнего запроса: 0.62 ms Память запроса: 0.032 MB. Память перед запросом: 23.109 MB Возвращено строк: 61

    SELECT a.id, a.title, a.catid, a.language, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
    
      FROM dr2cm_content AS a
    
      LEFT JOIN dr2cm_categories AS cc 
      ON cc.id = a.catid
    
      WHERE a.catid = 389 
      AND a.state = 1 
      AND a.access IN (1,1,5)  
      AND (a.state = 1 OR a.state = -1) 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-07-12 16:15:41') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-07-12 16:15:41')
    
      ORDER BY a.ordering

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	61	16.00	Using where; Используется сортировка файлов
    1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.71 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
    14	PlgContentPagenavigation->onContentBeforeDisplay()	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/article/view.html.php:199
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

39. Время запроса: 0.79 ms После последнего запроса: 0.46 ms Память запроса: 0.031 MB. Память перед запросом: 23.167 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1032&catid=389&id=8329&lang=ru&view=article';

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_sh404sef_urls	NULL	ref	newurl	newurl	573	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    32	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    31	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    30	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    29	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:778
    28	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    27	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    26	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    25	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    24	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    23	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    22	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    21	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    19	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    15	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/pagenavigation/pagenavigation.php:193
    14	PlgContentPagenavigation->onContentBeforeDisplay()	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/article/view.html.php:199
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

40. Время запроса: 4.56 ms После последнего запроса: 0.44 ms Память запроса: 0.031 MB. Память перед запросом: 23.184 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1032&catid=389&id=5427&lang=ru&view=article';

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_sh404sef_urls	NULL	ref	newurl	newurl	573	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    32	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    31	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    30	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    29	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:778
    28	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    27	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    26	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    25	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    24	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    23	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    22	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    21	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    19	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    15	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/pagenavigation/pagenavigation.php:204
    14	PlgContentPagenavigation->onContentBeforeDisplay()	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/article/view.html.php:199
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

41. Время запроса: 1.05 ms После последнего запроса: 7.70 ms Память запроса: 0.027 MB. Память перед запросом: 23.223 MB Возвращено строк: 1

    SELECT *  
      FROM `dr2cm_jcomments_objects` 
      WHERE `object_id` = '5426' 
      AND `object_group` = 'com_content' 
      AND `lang` = 'ru-RU'

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_jcomments_objects	NULL	ref	idx_object	idx_object	833	const,const,const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.03 ms
    executing	0.35 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    24	JDatabaseDriver->loadObject()	JROOT/components/com_jcomments/models/object.php:28
    23	JCommentsModelObject::getObjectInfo()	JROOT/components/com_jcomments/helpers/object.php:117
    22	JCommentsObjectHelper::fetchObjectInfo()	Такой же, как вызов в строке ниже
    21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/helpers/object.php:159
    19	JCommentsObjectHelper::getObjectInfo()	JROOT/components/com_jcomments/helpers/object.php:46
    18	JCommentsObjectHelper::getLink()	JROOT/components/com_jcomments/classes/factory.php:255
    17	JCommentsFactory::getTemplate()	JROOT/components/com_jcomments/jcomments.php:194
    16	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
    15	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
    14	plgContentJComments->onContentAfterDisplay()	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/article/view.html.php:202
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

42. Время запроса: 0.41 ms После последнего запроса: 0.39 ms Память запроса: 0.025 MB. Память перед запросом: 23.204 MB Возвращено строк: 1

    SELECT count(*)
    
      FROM dr2cm_jcomments AS c
    
      WHERE c.object_id = 5426 
      AND c.object_group = 'com_content' 
      AND c.published = 1

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	idx_object	idx_object	772	const,const,const	1	100.00	Using index

    Профиль

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    18	JCommentsModel::getCommentsCount()	JROOT/components/com_jcomments/jcomments.php:1307
    17	JComments::getCommentsCount()	JROOT/components/com_jcomments/jcomments.php:224
    16	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
    15	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
    14	plgContentJComments->onContentAfterDisplay()	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/article/view.html.php:202
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

43. Время запроса: 2.03 ms После последнего запроса: 2.75 ms Память запроса: 0.025 MB. Память перед запросом: 23.326 MB Возвращено строк: 0

    SELECT `id`
    
      FROM `dr2cm_jcomments_mailq`
    
      ORDER BY `priority` desc 
      LIMIT 10

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_jcomments_mailq	NULL	index	NULL	idx_priority	1	NULL	1	100.00	Backward index scan; Using index

    Профиль

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/helpers/notification.php:78
    17	JCommentsNotificationHelper::send()	JROOT/components/com_jcomments/jcomments.php:289
    16	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
    15	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
    14	plgContentJComments->onContentAfterDisplay()	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/article/view.html.php:202
    11	ContentViewArticle->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 для получения ссылок на файлы]

    ---

44. Время запроса: 0.51 ms После последнего запроса: 13.05 ms Память запроса: 0.023 MB. Память перед запросом: 23.357 MB Возвращено строк: 1

    SELECT `params` 
      FROM dr2cm_extensions 
      WHERE `type`='plugin' 
      AND `folder`='system' 
      AND `element`='sef';

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

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

    Профиль

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
    14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
    13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
    12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:182
    11	Sh404sefHelperGeneral::getExtensionParams()	JROOT/administrator/components/com_sh404sef/helpers/url.php:541
    10	Sh404sefHelperUrl::canonicalRoutedToAbs()	JROOT/components/com_sh404sef/meta_ext/com_content.php:127
    9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
    8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
    7	plgSystemSh404sef->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 для получения ссылок на файлы]

    ---

45. Время запроса: 0.30 ms После последнего запроса: 0.32 ms Память запроса: 0.023 MB. Память перед запросом: 23.374 MB Возвращено строк: 1

    SELECT `id`, `title`, `alias`, `catid`, `language` 
      FROM dr2cm_content 
      WHERE `id`=5426;

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

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

    Профиль

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/slugs.php:55
    11	Sh404sefModelSlugs->getArticle()	JROOT/components/com_sh404sef/sef_ext.php:693
    10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:169
    9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
    8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
    7	plgSystemSh404sef->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 для получения ссылок на файлы]

    ---

46. Время запроса: 0.37 ms После последнего запроса: 0.15 ms Память запроса: 0.023 MB. Память перед запросом: 23.382 MB Возвращено строк: 0
    Повторяющиеся запросы: #47

    SELECT * 
      FROM dr2cm_categories 
      WHERE parent_id > 0 
      and extension = 'com_content' 
      and path = 'uncategorised' 
      and level = 1;

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_categories	NULL	ref	cat_idx,idx_path	idx_path	402	const	1	5.00	Using where

    Профиль

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
    11	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/components/com_sh404sef/sef_ext.php:707
    10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:169
    9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
    8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
    7	plgSystemSh404sef->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 для получения ссылок на файлы]

    ---

47. Время запроса: 0.28 ms После последнего запроса: 0.10 ms Память запроса: 0.024 MB. Память перед запросом: 23.390 MB Возвращено строк: 0
    Повторяющиеся запросы: #46

    SELECT * 
      FROM dr2cm_categories 
      WHERE parent_id > 0 
      and extension = 'com_content' 
      and path = 'uncategorised' 
      and level = 1;

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_categories	NULL	ref	cat_idx,idx_path	idx_path	402	const	1	5.00	Using where

    Профиль

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    15	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    14	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    13	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
    12	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/administrator/components/com_sh404sef/models/slugs.php:280
    11	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:714
    10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:169
    9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
    8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
    7	plgSystemSh404sef->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 для получения ссылок на файлы]

    ---

48. Время запроса: 1.20 ms После последнего запроса: 0.15 ms Память запроса: 0.025 MB. Память перед запросом: 23.403 MB Возвращено строк: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_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 s.id = 389
    
      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_left_right	INDEX KEY не используется	NULL	NULL	484	64.58	Using where

    Профиль

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.81 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_sh404sef/models/slugs.php:161
    13	Sh404sefModelSlugs->getCategory()	JROOT/administrator/components/com_sh404sef/models/slugs.php:199
    12	Sh404sefModelSlugs->getCategoryPathArray()	JROOT/administrator/components/com_sh404sef/models/slugs.php:290
    11	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:714
    10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:169
    9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:509
    8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
    7	plgSystemSh404sef->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 для получения ссылок на файлы]

    ---

49. Время запроса: 1.47 ms После последнего запроса: 19.14 ms Память запроса: 0.021 MB. Память перед запросом: 23.449 MB Возвращено строк: 11

    SELECT id 
      FROM dr2cm_template_styles 
      ORDER BY id

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_template_styles	NULL	index	NULL	PRIMARY	4	NULL	11	100.00	Using index

    Профиль

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:329
    9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126
    8	JMFTemplate->__construct()	JROOT/templates/jm-trendy/index.php:13
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

50. Время запроса: 0.65 ms После последнего запроса: 18.83 ms Память запроса: 0.026 MB. Память перед запросом: 23.587 MB Возвращено строк: 0

    SELECT *
    
      FROM dr2cm_banners
    
      WHERE '2026-07-12 16:15:41' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

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

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

    Профиль

    Status	Duration
    starting	0.18 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    18	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    17	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    14	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-trendy/tpl/blocks/top.php:14
    12	include JROOT/templates/jm-trendy/tpl/blocks/top.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

51. Время запроса: 1.24 ms После последнего запроса: 0.85 ms Память запроса: 0.027 MB. Память перед запросом: 23.608 MB Возвращено строк: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM dr2cm_banners as a
    
      LEFT JOIN dr2cm_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-12 16:15:41') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 16:15:41') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.catid IN (958)
    
      ORDER BY a.sticky DESC, RAND()  
      LIMIT 3

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	idx_state,idx_banner_catid	idx_banner_catid,idx_state	4,1	NULL	1	6.40	Using intersect(idx_banner_catid,idx_state); Using where; Using temporary; Используется сортировка файлов
    1	SIMPLE	cl	NULL	eq_ref	PRIMARY	PRIMARY	4	vsesadiki_ru.a.cid	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.22 ms
    preparing	0.03 ms
    Creating tmp table	0.17 ms
    executing	0.22 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.05 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    19	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    18	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    17	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    14	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:935
    13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-trendy/tpl/blocks/top.php:14
    12	include JROOT/templates/jm-trendy/tpl/blocks/top.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

52. Время запроса: 4.57 ms После последнего запроса: 1.86 ms Память запроса: 0.028 MB. Память перед запросом: 23.707 MB Возвращено строк: 9

    SELECT a.id, a.title, a.alias, a.catid AS category_id, a.access, a.featured, a.language, a.created AS date
    
      FROM dr2cm_content AS a
    
      LEFT JOIN dr2cm_categories AS c 
      ON c.id = a.catid
    
      WHERE a.id IN (4669,4733,4599,4173,4624,4625,4598,6816,4100) 
      AND a.id != 5426 
      AND c.published = 1 
      AND a.state = 1 
      AND c.access IN (1,5) 
      AND a.access IN (1,5) 
      AND a.publish_up <= '2026-07-12 16:15:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 16:15:00')
    
      ORDER BY date DESC 
      LIMIT 9

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	range	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	NULL	9	0.67	Using where; Используется сортировка файлов
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	vsesadiki_ru.a.catid	1	10.00	Using where

    Профиль

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.21 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.44 ms
    preparing	0.04 ms
    executing	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_raxo_allmode/helper.php:535
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:49
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

53. Время запроса: 1.82 ms После последнего запроса: 0.24 ms Память запроса: 0.034 MB. Память перед запросом: 23.735 MB Возвращено строк: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_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 = 149
    
      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	484	30.17	Using where

    Профиль

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.23 ms
    preparing	0.07 ms
    executing	1.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    32	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    31	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    30	ContentRouter->getCategorySegment()	Такой же, как вызов в строке ниже
    29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:599
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:49
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

54. Время запроса: 4.45 ms После последнего запроса: 0.69 ms Память запроса: 0.034 MB. Память перед запросом: 23.774 MB Возвращено строк: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_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 = 339
    
      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	484	29.44	Using where

    Профиль

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    executing	0.94 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    32	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    31	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    30	ContentRouter->getCategorySegment()	Такой же, как вызов в строке ниже
    29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:599
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:49
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

55. Время запроса: 1.66 ms После последнего запроса: 0.55 ms Память запроса: 0.034 MB. Память перед запросом: 23.809 MB Возвращено строк: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_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 = 358
    
      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	484	29.62	Using where

    Профиль

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.18 ms
    preparing	0.04 ms
    executing	0.91 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    32	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    31	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    30	ContentRouter->getCategorySegment()	Такой же, как вызов в строке ниже
    29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:599
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:49
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

56. Время запроса: 0.53 ms После последнего запроса: 0.42 ms Память запроса: 0.034 MB. Память перед запросом: 23.834 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=981&catid=358&id=4669&lang=ru&view=article';

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_sh404sef_urls	NULL	ref	newurl	newurl	573	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    38	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    37	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    36	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    35	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:778
    34	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    33	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    32	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    31	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    30	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    29	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    28	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    27	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    26	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    25	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:599
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:49
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

57. Время запроса: 0.37 ms После последнего запроса: 1.38 ms Память запроса: 0.034 MB. Память перед запросом: 23.879 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=422&catid=149&id=4100&lang=ru&view=article';

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dr2cm_sh404sef_urls	NULL	ref	newurl	newurl	573	const	1	100.00	Using where

    Профиль

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    38	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    37	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    36	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    35	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:778
    34	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    33	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    32	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    31	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    30	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    29	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    28	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    27	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    26	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    25	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:599
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:49
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

58. Время запроса: 1.57 ms После последнего запроса: 2.71 ms Память запроса: 0.027 MB. Память перед запросом: 23.873 MB Возвращено строк: 4

    SELECT a.id, a.title, a.alias, a.catid AS category_id, a.access, a.featured, a.language, a.created AS date
    
      FROM dr2cm_content AS a
    
      LEFT JOIN dr2cm_categories AS c 
      ON c.id = a.catid
    
      WHERE (a.catid = 353) 
      AND a.id != 5426 
      AND c.published = 1 
      AND a.state = 1 
      AND c.access IN (1,5) 
      AND a.access IN (1,5) 
      AND a.publish_up <= '2026-07-12 16:15:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 16:15:00')
    
      ORDER BY date DESC 
      LIMIT 4

    План запросов (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	range	PRIMARY,idx_access,idx_state,idx_catid	idx_catid	8	NULL	63	0.67	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.25 ms
    preparing	0.04 ms
    executing	0.84 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 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/modules/mod_raxo_allmode/helper.php:535
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:56
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

59. Время запроса: 3.36 ms После последнего запроса: 0.22 ms Память запроса: 0.034 MB. Память перед запросом: 23.898 MB Возвращено строк: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_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 = 353
    
      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	484	57.04	Using where

    Профиль

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    executing	2.73 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    32	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    31	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    30	ContentRouter->getCategorySegment()	Такой же, как вызов в строке ниже
    29	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    28	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    27	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    26	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    25	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:599
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:56
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

60. Время запроса: 1.32 ms После последнего запроса: 2.52 ms Память запроса: 0.027 MB. Память перед запросом: 23.923 MB Возвращено строк: 0

    SELECT a.id, a.title, a.alias, a.catid AS category_id, a.access, a.featured, a.language, a.created AS date
    
      FROM dr2cm_content AS a
    
      LEFT JOIN dr2cm_categories AS c 
      ON c.id = a.catid
    
      WHERE (a.catid = 470) 
      AND a.id != 5426 
      AND c.published = 1 
      AND a.state = 1 
      AND c.access IN (1,5) 
      AND a.access IN (1,5) 
      AND a.publish_up <= '2026-07-12 16:15:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 16:15:00')
    
      ORDER BY date DESC 
      LIMIT 3

    План запросов (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	range	PRIMARY,idx_access,idx_state,idx_catid	idx_catid	8	NULL	2	2.50	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.19 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_raxo_allmode/helper.php:535
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:56
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/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 для получения ссылок на файлы]

    ---

61. Время запроса: 3.05 ms После последнего запроса: 22.48 ms Память запроса: 0.021 MB. Память перед запросом: 27.005 MB Возвращено строк: 1
    Повторяющиеся запросы: #14

    SELECT *
    
      FROM dr2cm_template_styles
    
      WHERE `id` = '12'

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

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

    Профиль

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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/ef4_jmframework/ef4_jmframework.php:1029
    8	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:522
    7	plgSystemEF4_JMFramework->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
    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 для получения ссылок на файлы]

    ---

62. Время запроса: 4.79 ms После последнего запроса: 9.89 ms Память запроса: 0.022 MB. Память перед запросом: 27.208 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_metainfo
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-1-schelkovo.html'
     
      AND `published` = 1

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

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

    Профиль

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:496
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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 для получения ссылок на файлы]

    ---

63. Время запроса: 0.49 ms После последнего запроса: 0.11 ms Память запроса: 0.022 MB. Память перед запросом: 27.214 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_canonicals
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-1-schelkovo.html'

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

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

    Профиль

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:575
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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 для получения ссылок на файлы]

    ---

64. Время запроса: 0.55 ms После последнего запроса: 17.86 ms Память запроса: 0.020 MB. Память перед запросом: 27.492 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_headings
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-1-schelkovo.html'

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

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

    Профиль

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:891
    7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    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 для получения ссылок на файлы]

    ---