Детский сад № 24 "Кораблик"

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1783770597,
                "last": 1783770597,
                "now": 1783770597
            },
            "client": {
                "forwarded": "216.73.216.173"
            },
            "token": "ob6g0qCvwRlhDnMsFknqRl41ABuYTkQm"
        },
        "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 запросов зарегистрировано 89.89 ms

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

   SELECT `data`
   
     FROM `dr2cm_session`
   
     WHERE `session_id` = X'6631356768337432386d64613267347273367536736237323275'

   План запросов (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.06 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.07 ms
   init	0.03 ms
   System lock	0.03 ms
   optimizing	0.01 ms
   statistics	0.09 ms
   executing	0.01 ms
   end	0.02 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.04 ms
   freeing items	0.52 ms
   cleaning up	0.01 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.34 ms После последнего запроса: 0.44 ms Память запроса: 0.020 MB. Память перед запросом: 1.041 MB Возвращено строк: 0

   SELECT `session_id`
   
     FROM `dr2cm_session`
   
     WHERE `session_id` = X'6631356768337432386d64613267347273367536736237323275' 
     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.03 ms
   Executing hook on transaction	0.00 ms
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 ms
   end	0.02 ms
   query end	0.02 ms
   waiting for handler commit	0.01 ms
   closing tables	0.03 ms
   freeing items	0.17 ms
   cleaning up	0.01 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.69 ms После последнего запроса: 0.11 ms Память запроса: 0.004 MB. Память перед запросом: 1.046 MB

   INSERT INTO `dr2cm_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6631356768337432386d64613267347273367536736237323275', 1, 1783770597, 0, '', 0)

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

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

   Профиль

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.03 ms
   Opening tables	0.04 ms
   init	0.03 ms
   System lock	0.01 ms
   update	0.32 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.14 ms
   closing tables	0.03 ms
   freeing items	1.28 ms
   cleaning up	0.01 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.41 ms После последнего запроса: 1.24 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.00 ms
   checking permissions	0.00 ms
   Opening tables	0.09 ms
   init	0.00 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.01 ms
   preparing	0.02 ms
   executing	0.07 ms
   end	0.00 ms
   query end	0.02 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	0.16 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.45 ms После последнего запроса: 0.11 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.04 ms
   checking permissions	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.06 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.12 ms
   preparing	0.06 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.00 ms
   freeing items	2.15 ms
   cleaning up	0.01 ms

   Стек вызовов

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

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

   ---

6. Время запроса: 0.61 ms После последнего запроса: 25.66 ms Память запроса: 0.022 MB. Память перед запросом: 5.342 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.08 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.02 ms
   preparing	0.05 ms
   executing	0.09 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.02 ms
   closing tables	0.03 ms
   freeing items	0.04 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 для получения ссылок на файлы]

   ---

7. Время запроса: 0.62 ms После последнего запроса: 1.08 ms Память запроса: 0.023 MB. Память перед запросом: 5.498 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.07 ms
   Executing hook on transaction	0.03 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.12 ms
   preparing	0.02 ms
   executing	0.07 ms
   end	0.01 ms
   query end	0.02 ms
   waiting for handler commit	0.03 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 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 для получения ссылок на файлы]

   ---

8. Время запроса: 0.80 ms После последнего запроса: 5.84 ms Память запроса: 0.024 MB. Память перед запросом: 5.968 MB Возвращено строк: 4

   SELECT * 
     FROM `dr2cm_sh404sef_aliases` 
     WHERE `state` = 1 
     and (`alias` = 'detski-sad-24-lytkarino.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.09 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.02 ms
   Opening tables	0.13 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.16 ms
   preparing	0.03 ms
   executing	0.13 ms
   end	0.01 ms
   query end	0.02 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 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 для получения ссылок на файлы]

   ---

9. Время запроса: 16.50 ms После последнего запроса: 0.13 ms Память запроса: 3.259 MB. Память перед запросом: 5.978 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.07 ms
   Executing hook on transaction	0.01 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.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   executing	15.44 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	5.12 ms
   cleaning up	0.04 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 для получения ссылок на файлы]

   ---

10. Время запроса: 2.48 ms После последнего запроса: 134.94 ms Память запроса: 0.025 MB. Память перед запросом: 14.644 MB Возвращено строк: 4

    SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
      FROM dr2cm_sh404sef_urls 
      WHERE `oldurl`='detski-sad-24-lytkarino.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.14 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.05 ms
    Opening tables	0.15 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.55 ms
    preparing	0.05 ms
    executing	1.14 ms
    end	0.02 ms
    query end	0.03 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.09 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

11. Время запроса: 0.89 ms После последнего запроса: 0.27 ms Память запроса: 0.008 MB. Память перед запросом: 14.655 MB

    UPDATE `dr2cm_sh404sef_urls` 
      SET `cpt`=2372, `last_hit`='2026-07-11 11:49:57' 
      WHERE `id`='8888' 
      AND `rank`=0;

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

    EXPLAIN недоступен для: UPDATE `dr2cm_sh404sef_urls` SET `cpt`=2372, `last_hit`='2026-07-11 11:49:57' WHERE `id`='8888' AND `rank`=0;

    Профиль

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.12 ms
    updating	0.25 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.12 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

12. Время запроса: 3.10 ms После последнего запроса: 3.04 ms Память запроса: 0.024 MB. Память перед запросом: 14.694 MB Возвращено строк: 8

    SHOW FULL COLUMNS 
      FROM `dr2cm_template_styles`

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

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

    Профиль

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.01 ms
    starting	0.31 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	1.21 ms
    init	0.03 ms
    System lock	0.03 ms
    optimizing	0.04 ms
    statistics	0.17 ms
    preparing	0.05 ms
    Creating tmp table	0.10 ms
    executing	0.22 ms
    checking permissions	0.16 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.08 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 ms
    freeing items	0.09 ms
    cleaning up	0.02 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 для получения ссылок на файлы]

    ---

13. Время запроса: 0.54 ms После последнего запроса: 0.50 ms Память запроса: 0.021 MB. Память перед запросом: 14.714 MB Возвращено строк: 1
    Повторяющиеся запросы: #56

    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.02 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.04 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

    Стек вызовов

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

    ---

14. Время запроса: 0.84 ms После последнего запроса: 3.98 ms Память запроса: 0.006 MB. Память перед запросом: 14.805 MB

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

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

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

    Профиль

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.15 ms
    updating	0.18 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.10 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

15. Время запроса: 0.78 ms После последнего запроса: 0.56 ms Память запроса: 0.022 MB. Память перед запросом: 14.894 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.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.04 ms
    executing	0.15 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.01 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 для получения ссылок на файлы]

    ---

16. Время запроса: 1.09 ms После последнего запроса: 3.74 ms Память запроса: 0.028 MB. Память перед запросом: 15.040 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.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.02 ms
    executing	0.47 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

    Стек вызовов

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

    ---

17. Время запроса: 15.32 ms После последнего запроса: 0.22 ms Память запроса: 1.001 MB. Память перед запросом: 15.094 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.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	14.74 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	7.08 ms
    cleaning up	0.03 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 для получения ссылок на файлы]

    ---

18. Время запроса: 2.78 ms После последнего запроса: 19.92 ms Память запроса: 0.031 MB. Память перед запросом: 20.748 MB Возвращено строк: 31

    SHOW FULL COLUMNS 
      FROM `dr2cm_content`

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

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

    Профиль

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.71 ms
    init	0.02 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.18 ms
    preparing	0.04 ms
    Creating tmp table	0.07 ms
    executing	0.15 ms
    checking permissions	0.14 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.12 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 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 для получения ссылок на файлы]

    ---

19. Время запроса: 0.83 ms После последнего запроса: 1.00 ms Память запроса: 0.005 MB. Память перед запросом: 20.796 MB

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

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

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

    Профиль

    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.12 ms
    init	0.01 ms
    System lock	0.13 ms
    updating	0.21 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.10 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

20. Время запроса: 1.19 ms После последнего запроса: 1.51 ms Память запроса: 0.023 MB. Память перед запросом: 20.843 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 = 5155 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-11 11:49:58') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-11 11:49:58') 
      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.23 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.25 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.29 ms
    preparing	0.03 ms
    executing	0.04 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.04 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 для получения ссылок на файлы]

    ---

21. Время запроса: 2.00 ms После последнего запроса: 1.44 ms Память запроса: 0.028 MB. Память перед запросом: 20.939 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 = 379
    
      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	61.45	Using where

    Профиль

    Status	Duration
    starting	0.20 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.05 ms
    statistics	0.17 ms
    preparing	0.05 ms
    executing	1.12 ms
    end	0.02 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.02 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 для получения ссылок на файлы]

    ---

22. Время запроса: 0.54 ms После последнего запроса: 5.52 ms Память запроса: 0.029 MB. Память перед запросом: 21.604 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1024&catid=379&id=5155&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.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.05 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.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

    Стек вызовов

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

    ---

23. Время запроса: 3.75 ms После последнего запроса: 0.61 ms Память запроса: 0.022 MB. Память перед запросом: 21.620 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` = 5155 
      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.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.14 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.04 ms
    executing	2.94 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.09 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/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 для получения ссылок на файлы]

    ---

24. Время запроса: 0.62 ms После последнего запроса: 18.68 ms Память запроса: 0.027 MB. Память перед запросом: 22.396 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.12 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    executing	0.03 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

    Стек вызовов

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

    ---

25. Время запроса: 0.49 ms После последнего запроса: 0.70 ms Память запроса: 0.027 MB. Память перед запросом: 22.425 MB Возвращено строк: 0
    Повторяющиеся запросы: #24

    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.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    executing	0.03 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

    Стек вызовов

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

    ---

26. Время запроса: 1.52 ms После последнего запроса: 2.20 ms Память запроса: 0.028 MB. Память перед запросом: 22.469 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 (379,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.14 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.21 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Creating tmp table	0.28 ms
    executing	0.36 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/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. Время запроса: 0.48 ms После последнего запроса: 0.47 ms Память запроса: 0.024 MB. Память перед запросом: 22.518 MB Возвращено строк: 0

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

    План запросов (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	1	100.00	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.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.13 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

    Стек вызовов

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

    ---

28. Время запроса: 2.20 ms После последнего запроса: 12.89 ms Память запроса: 0.035 MB. Память перед запросом: 22.863 MB Возвращено строк: 41

    SHOW FULL COLUMNS 
      FROM `dr2cm_sh404sef_metas`

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

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

    Профиль

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.47 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.09 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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.09 ms
    end	0.01 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.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:138
    19	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:328
    18	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:37
    17	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
    16	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:448
    15	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
    14	plgSystemSh404sef->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. Время запроса: 0.99 ms После последнего запроса: 0.21 ms Память запроса: 0.026 MB. Память перед запросом: 22.913 MB Возвращено строк: 1

    SELECT * 
      FROM dr2cm_sh404sef_metas 
      WHERE `newurl`='index.php?option=com_content&Itemid=1024&catid=379&id=5155&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.06 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.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.49 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.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    21	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    20	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    19	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    18	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:38
    17	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
    16	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:448
    15	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
    14	plgSystemSh404sef->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.49 ms После последнего запроса: 1.26 ms Память запроса: 0.024 MB. Память перед запросом: 22.929 MB Возвращено строк: 0

    SELECT * 
      FROM dr2cm_content_extravote 
      WHERE content_id=5155 
      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.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

31. Время запроса: 1.09 ms После последнего запроса: 0.68 ms Память запроса: 0.025 MB. Память перед запросом: 22.954 MB Возвращено строк: 19

    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 = 379 
      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-11 11:49:58') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-07-11 11:49:58')
    
      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	19	16.00	Using where; Используется сортировка файлов
    1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.06 ms
    statistics	0.15 ms
    preparing	0.04 ms
    executing	0.36 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.05 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

32. Время запроса: 0.41 ms После последнего запроса: 0.50 ms Память запроса: 0.031 MB. Память перед запросом: 22.982 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1024&catid=379&id=5154&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.07 ms
    Executing hook on transaction	0.01 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.07 ms
    preparing	0.02 ms
    executing	0.05 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.02 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 для получения ссылок на файлы]

    ---

33. Время запроса: 0.55 ms После последнего запроса: 3.84 ms Память запроса: 0.028 MB. Память перед запросом: 23.042 MB Возвращено строк: 1

    SELECT *  
      FROM `dr2cm_jcomments_objects` 
      WHERE `object_id` = '5155' 
      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.09 ms
    Executing hook on transaction	0.01 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.11 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

    Стек вызовов

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

    ---

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

    SELECT count(*)
    
      FROM dr2cm_jcomments AS c
    
      WHERE c.object_id = 5155 
      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.03 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

35. Время запроса: 0.48 ms После последнего запроса: 2.94 ms Память запроса: 0.025 MB. Память перед запросом: 23.162 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.06 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.01 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.05 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.01 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

36. Время запроса: 0.51 ms После последнего запроса: 3.98 ms Память запроса: 0.023 MB. Память перед запросом: 23.181 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.10 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.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.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 для получения ссылок на файлы]

    ---

37. Время запроса: 0.31 ms После последнего запроса: 0.26 ms Память запроса: 0.023 MB. Память перед запросом: 23.198 MB Возвращено строк: 1

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

    План запросов (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.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.01 ms
    statistics	0.04 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.02 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 для получения ссылок на файлы]

    ---

38. Время запроса: 0.39 ms После последнего запроса: 0.14 ms Память запроса: 0.023 MB. Память перед запросом: 23.206 MB Возвращено строк: 0
    Повторяющиеся запросы: #39  #58

    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.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.03 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.01 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

39. Время запроса: 0.28 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB. Память перед запросом: 23.214 MB Возвращено строк: 0
    Повторяющиеся запросы: #38  #58

    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.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.01 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 для получения ссылок на файлы]

    ---

40. Время запроса: 1.28 ms После последнего запроса: 0.15 ms Память запроса: 0.025 MB. Память перед запросом: 23.227 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 = 379
    
      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	62.16	Using where

    Профиль

    Status	Duration
    starting	0.10 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.00 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.84 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

    Стек вызовов

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

    ---

41. Время запроса: 0.36 ms После последнего запроса: 7.64 ms Память запроса: 0.021 MB. Память перед запросом: 23.277 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.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.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 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

    Стек вызовов

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

    ---

42. Время запроса: 4.30 ms После последнего запроса: 1.77 ms Память запроса: 0.076 MB. Память перед запросом: 23.339 MB Возвращено строк: 32

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM dr2cm_modules AS m
    
      LEFT JOIN dr2cm_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN dr2cm_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-11 11:49:58') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-11 11:49:58') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1024 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ALL	element_clientid,element_folder_clientid	INDEX KEY не используется	NULL	NULL	300	1.00	Using where; Using temporary; Используется сортировка файлов
    1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	newsfeeds	204	vsesadiki_ru.e.element,const	18	0.48	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	vsesadiki_ru.m.id	16	40.00	Using where; Using index

    Профиль

    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
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    executing	3.42 ms
    end	0.02 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.15 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476
    11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469
    10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711
    9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
    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 для получения ссылок на файлы]

    ---

43. Время запроса: 0.98 ms После последнего запроса: 5.59 ms Память запроса: 0.028 MB. Память перед запросом: 23.508 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 != 5155 
      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-11 11:49:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-11 11:49: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.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.27 ms
    preparing	0.05 ms
    executing	0.17 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

    Стек вызовов

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

    ---

44. Время запроса: 1.54 ms После последнего запроса: 0.26 ms Память запроса: 0.034 MB. Память перед запросом: 23.536 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.14 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.04 ms
    executing	0.92 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.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 для получения ссылок на файлы]

    ---

45. Время запроса: 1.44 ms После последнего запроса: 0.74 ms Память запроса: 0.034 MB. Память перед запросом: 23.574 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.01 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.84 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.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 для получения ссылок на файлы]

    ---

46. Время запроса: 1.58 ms После последнего запроса: 0.68 ms Память запроса: 0.034 MB. Память перед запросом: 23.609 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.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.07 ms
    executing	0.89 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

    Стек вызовов

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

    ---

47. Время запроса: 0.43 ms После последнего запроса: 0.48 ms Память запроса: 0.034 MB. Память перед запросом: 23.634 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.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.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.05 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 для получения ссылок на файлы]

    ---

48. Время запроса: 0.39 ms После последнего запроса: 1.24 ms Память запроса: 0.034 MB. Память перед запросом: 23.679 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.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.08 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.02 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 для получения ссылок на файлы]

    ---

49. Время запроса: 1.37 ms После последнего запроса: 1.65 ms Память запроса: 0.027 MB. Память перед запросом: 23.673 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 != 5155 
      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-11 11:49:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-11 11:49: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.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.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.26 ms
    preparing	0.04 ms
    executing	0.67 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

    Стек вызовов

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

    ---

50. Время запроса: 1.49 ms После последнего запроса: 0.24 ms Память запроса: 0.034 MB. Память перед запросом: 23.698 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.13 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    executing	0.89 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: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 для получения ссылок на файлы]

    ---

51. Время запроса: 0.43 ms После последнего запроса: 0.47 ms Память запроса: 0.034 MB. Память перед запросом: 23.723 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1024&catid=353&id=9400&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.01 ms
    starting	0.01 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.07 ms
    preparing	0.02 ms
    executing	0.07 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.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: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 для получения ссылок на файлы]

    ---

52. Время запроса: 0.36 ms После последнего запроса: 0.49 ms Память запроса: 0.034 MB. Память перед запросом: 23.747 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1024&catid=353&id=9399&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.01 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.08 ms
    preparing	0.02 ms
    executing	0.04 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.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: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 для получения ссылок на файлы]

    ---

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

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1024&catid=353&id=9077&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.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.07 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.02 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: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 для получения ссылок на файлы]

    ---

54. Время запроса: 0.29 ms После последнего запроса: 0.40 ms Память запроса: 0.034 MB. Память перед запросом: 23.792 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1024&catid=353&id=8987&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.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.05 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    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: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 для получения ссылок на файлы]

    ---

55. Время запроса: 0.71 ms После последнего запроса: 1.32 ms Память запроса: 0.027 MB. Память перед запросом: 23.800 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 != 5155 
      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-11 11:49:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-11 11:49: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.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.24 ms
    preparing	0.05 ms
    executing	0.06 ms
    end	0.00 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

    Стек вызовов

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

    ---

56. Время запроса: 0.52 ms После последнего запроса: 17.50 ms Память запроса: 0.021 MB. Память перед запросом: 26.925 MB Возвращено строк: 1
    Повторяющиеся запросы: #13

    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.10 ms
    Executing hook on transaction	0.01 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.02 ms
    statistics	0.06 ms
    preparing	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.01 ms
    freeing items	0.02 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 для получения ссылок на файлы]

    ---

57. Время запроса: 0.49 ms После последнего запроса: 19.18 ms Память запроса: 0.031 MB. Память перед запросом: 27.376 MB Возвращено строк: 0

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1840&filter_tag[0]=63&id=166&lang=ru&layout=blog&view=category';

    План запросов (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.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.01 ms
    statistics	0.09 ms
    preparing	0.03 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    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/sh404sef.class.php:778
    29	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    28	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    27	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    26	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    25	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    24	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    23	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    22	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    20	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    15	ModMenuHelper::getList()	JROOT/modules/mod_djmegamenu/helper.php:103
    14	modDJMMHelper::getList()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:48
    13	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 для получения ссылок на файлы]

    ---

58. Время запроса: 0.54 ms После последнего запроса: 1.00 ms Память запроса: 0.033 MB. Память перед запросом: 27.411 MB Возвращено строк: 0
    Повторяющиеся запросы: #38  #39

    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.09 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.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.04 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    36	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    35	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    34	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    33	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
    32	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/administrator/components/com_sh404sef/models/slugs.php:280
    31	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:646
    30	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/sef_ext/com_content.php:229
    29	include JROOT/components/com_sh404sef/sef_ext/com_content.php	JROOT/components/com_sh404sef/sef_ext.php:388
    28	sef_404->create()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1756
    27	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    26	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    25	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    24	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    23	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    22	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    20	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    15	ModMenuHelper::getList()	JROOT/modules/mod_djmegamenu/helper.php:103
    14	modDJMMHelper::getList()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:48
    13	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 для получения ссылок на файлы]

    ---

59. Время запроса: 0.59 ms После последнего запроса: 0.19 ms Память запроса: 0.034 MB. Память перед запросом: 27.432 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 = 166
    
      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	NULL
    1	SIMPLE	c	NULL	range	cat_idx,idx_left_right	idx_left_right	4	NULL	83	90.08	Using index condition; Using where

    Профиль

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.02 ms
    starting	0.01 ms
    checking permissions	0.01 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.11 ms
    preparing	0.03 ms
    executing	0.09 ms
    end	0.00 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    35	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    34	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_sh404sef/models/slugs.php:161
    33	Sh404sefModelSlugs->getCategory()	JROOT/administrator/components/com_sh404sef/models/slugs.php:199
    32	Sh404sefModelSlugs->getCategoryPathArray()	JROOT/administrator/components/com_sh404sef/models/slugs.php:290
    31	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:646
    30	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/sef_ext/com_content.php:229
    29	include JROOT/components/com_sh404sef/sef_ext/com_content.php	JROOT/components/com_sh404sef/sef_ext.php:388
    28	sef_404->create()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1756
    27	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    26	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    25	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    24	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    23	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    22	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    20	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    15	ModMenuHelper::getList()	JROOT/modules/mod_djmegamenu/helper.php:103
    14	modDJMMHelper::getList()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:48
    13	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 для получения ссылок на файлы]

    ---

60. Время запроса: 0.40 ms После последнего запроса: 0.53 ms Память запроса: 0.032 MB. Память перед запросом: 27.461 MB Возвращено строк: 1

    SELECT `oldurl` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1840&id=166&lang=ru&layout=blog&view=category';

    План запросов (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.01 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.09 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.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    35	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
    34	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
    33	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
    32	ShlDbHelper::selectResult()	JROOT/components/com_sh404sef/sef_ext.php:813
    31	sef_404::sefGetLocation()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:508
    30	shFinalizePlugin()	JROOT/components/com_sh404sef/sef_ext/com_content.php:323
    29	include JROOT/components/com_sh404sef/sef_ext/com_content.php	JROOT/components/com_sh404sef/sef_ext.php:388
    28	sef_404->create()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1756
    27	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    26	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    25	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    24	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    23	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    22	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    20	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    15	ModMenuHelper::getList()	JROOT/modules/mod_djmegamenu/helper.php:103
    14	modDJMMHelper::getList()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:48
    13	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 для получения ссылок на файлы]

    ---

61. Время запроса: 0.46 ms После последнего запроса: 56.23 ms Память запроса: 0.023 MB. Память перед запросом: 28.352 MB Возвращено строк: 1

    SELECT manifest_cache 
      FROM dr2cm_extensions 
      WHERE element='mod_djmegamenu' 
      LIMIT 1

    План запросов (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	element_clientid	402	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.01 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 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.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/modules/mod_djmegamenu/helper.php:341
    14	modDJMMHelper::getVersion()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:84
    13	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Такой же, как вызов в строке ниже
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 для получения ссылок на файлы]

    ---

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

    SELECT *
     
      FROM dr2cm_jmap_metainfo
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-24-lytkarino.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.07 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    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.22 ms После последнего запроса: 0.09 ms Память запроса: 0.022 MB. Память перед запросом: 28.392 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_canonicals
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-24-lytkarino.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.03 ms
    Executing hook on transaction	0.00 ms
    starting	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.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.00 ms
    freeing items	0.01 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.51 ms После последнего запроса: 7.89 ms Память запроса: 0.020 MB. Память перед запросом: 28.662 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_headings
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-24-lytkarino.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.04 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 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

    Стек вызовов

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

    ---