Детский сад № 12

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1783837741,
                "last": 1783837741,
                "now": 1783837741
            },
            "client": {
                "forwarded": "216.73.216.173"
            },
            "token": "rV8vuIAqfR4uxvLr90fFbd9KUkgD2osG"
        },
        "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
    }
}

Время

Память

55 запросов зарегистрировано 101.44 ms

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

   SELECT `data`
   
     FROM `dr2cm_session`
   
     WHERE `session_id` = X'736d69666d6a743337656365677576637233736b6276626b6738'

   План запросов (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.10 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.11 ms
   init	0.01 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.03 ms
   freeing items	1.82 ms
   cleaning up	0.02 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.58 ms После последнего запроса: 1.71 ms Память запроса: 0.021 MB. Память перед запросом: 1.139 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.07 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.11 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.12 ms
   end	0.02 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

   Стек вызовов

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

   ---

3. Время запроса: 0.52 ms После последнего запроса: 0.18 ms Память запроса: 0.021 MB. Память перед запросом: 1.151 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.08 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 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.10 ms
   preparing	0.03 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.02 ms
   cleaning up	0.00 ms

   Стек вызовов

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

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

   ---

4. Время запроса: 0.67 ms После последнего запроса: 32.43 ms Память запроса: 0.022 MB. Память перед запросом: 5.335 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.09 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.02 ms
   Opening tables	0.10 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.03 ms
   executing	0.11 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

   Стек вызовов

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

   ---

5. Время запроса: 0.74 ms После последнего запроса: 1.52 ms Память запроса: 0.023 MB. Память перед запросом: 5.493 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.09 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.13 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.13 ms
   preparing	0.03 ms
   executing	0.09 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.04 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 для получения ссылок на файлы]

   ---

6. Время запроса: 1.91 ms После последнего запроса: 8.55 ms Память запроса: 0.024 MB. Память перед запросом: 5.963 MB Возвращено строк: 4

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

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

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

   Профиль

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

   ---

7. Время запроса: 23.53 ms После последнего запроса: 0.22 ms Память запроса: 3.259 MB. Память перед запросом: 5.972 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.09 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.16 ms
   preparing	0.03 ms
   executing	22.40 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	4.74 ms
   cleaning up	0.02 ms

   Стек вызовов

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

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

   ---

8. Время запроса: 2.59 ms После последнего запроса: 166.97 ms Память запроса: 0.025 MB. Память перед запросом: 14.638 MB Возвращено строк: 3

   SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
     FROM dr2cm_sh404sef_urls 
     WHERE `oldurl`='detski-sad-12-friazino.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	3	100.00	Using where; Используется сортировка файлов

   Профиль

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

   Стек вызовов

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

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

   ---

9. Время запроса: 1.06 ms После последнего запроса: 0.35 ms Память запроса: 0.008 MB. Память перед запросом: 14.650 MB

   UPDATE `dr2cm_sh404sef_urls` 
     SET `cpt`=2108, `last_hit`='2026-07-12 06:29:01' 
     WHERE `id`='16207' 
     AND `rank`=0;

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

   EXPLAIN недоступен для: UPDATE `dr2cm_sh404sef_urls` SET `cpt`=2108, `last_hit`='2026-07-12 06:29:01' WHERE `id`='16207' AND `rank`=0;

   Профиль

   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.22 ms
   updating	0.34 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.15 ms
   closing tables	0.02 ms
   freeing items	0.03 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 для получения ссылок на файлы]

   ---

10. Время запроса: 3.65 ms После последнего запроса: 3.83 ms Память запроса: 0.024 MB. Память перед запросом: 14.690 MB Возвращено строк: 8

    SHOW FULL COLUMNS 
      FROM `dr2cm_template_styles`

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

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

    Профиль

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.01 ms
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	1.50 ms
    init	0.03 ms
    System lock	0.05 ms
    optimizing	0.05 ms
    statistics	0.36 ms
    preparing	0.06 ms
    Creating tmp table	0.15 ms
    executing	0.34 ms
    checking permissions	0.20 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.04 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.09 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.11 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    11	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1028
    9	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209
    8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Время запроса: 0.58 ms После последнего запроса: 0.53 ms Память запроса: 0.021 MB. Память перед запросом: 14.709 MB Возвращено строк: 1
    Повторяющиеся запросы: #52

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

    ---

12. Время запроса: 0.82 ms После последнего запроса: 4.24 ms Память запроса: 0.006 MB. Память перед запросом: 14.800 MB

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

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

    EXPLAIN недоступен для: UPDATE `dr2cm_extensions` SET `params` = '{\"mediaversion\":\"291dde7b26979c293aa5d1c15f0b966b\"}' 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.11 ms
    init	0.01 ms
    System lock	0.14 ms
    updating	0.15 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.12 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:294
    8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Время запроса: 0.85 ms После последнего запроса: 0.54 ms Память запроса: 0.022 MB. Память перед запросом: 14.889 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.12 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.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.16 ms
    preparing	0.04 ms
    executing	0.23 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

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

    ---

14. Время запроса: 1.75 ms После последнего запроса: 4.65 ms Память запроса: 0.028 MB. Память перед запросом: 15.034 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.13 ms
    Executing hook on transaction	0.00 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.22 ms
    preparing	0.03 ms
    executing	0.96 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 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: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 для получения ссылок на файлы]

    ---

15. Время запроса: 13.20 ms После последнего запроса: 0.34 ms Память запроса: 1.001 MB. Память перед запросом: 15.087 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.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 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.21 ms
    preparing	0.05 ms
    executing	12.52 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	3.28 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Время запроса: 2.70 ms После последнего запроса: 21.08 ms Память запроса: 0.031 MB. Память перед запросом: 20.740 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.00 ms
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.70 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.04 ms
    Creating tmp table	0.07 ms
    executing	0.16 ms
    checking permissions	0.11 ms
    checking permissions	0.07 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 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.04 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.05 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.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.07 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 для получения ссылок на файлы]

    ---

17. Время запроса: 0.91 ms После последнего запроса: 1.45 ms Память запроса: 0.006 MB. Память перед запросом: 20.789 MB

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

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

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

    Профиль

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

    ---

18. Время запроса: 1.62 ms После последнего запроса: 1.62 ms Память запроса: 0.023 MB. Память перед запросом: 20.837 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 = 5374 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-12 06:29:02') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 06:29:02') 
      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	1	100.00	NULL

    Профиль

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

    ---

19. Время запроса: 2.67 ms После последнего запроса: 1.62 ms Память запроса: 0.028 MB. Память перед запросом: 20.932 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 = 387
    
      ORDER BY c.lft

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

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

    Профиль

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Такой же, как вызов в строке ниже
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Время запроса: 0.71 ms После последнего запроса: 7.75 ms Память запроса: 0.029 MB. Память перед запросом: 21.597 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1031&catid=387&id=5374&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.12 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.17 ms
    preparing	0.03 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    29	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
    28	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
    27	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
    26	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:778
    25	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:815
    24	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1537
    23	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1193
    22	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2390
    21	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1047
    20	Sh404sefClassRouterInternal->buildRule()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
    18	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:661
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
    16	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Время запроса: 5.16 ms После последнего запроса: 0.67 ms Память запроса: 0.022 MB. Память перед запросом: 21.613 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` = 5374 
      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.11 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.21 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.24 ms
    preparing	0.04 ms
    executing	4.22 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	2.29 ms
    cleaning up	0.02 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 для получения ссылок на файлы]

    ---

22. Время запроса: 0.80 ms После последнего запроса: 23.32 ms Память запроса: 0.027 MB. Память перед запросом: 22.405 MB Возвращено строк: 0
    Повторяющиеся запросы: #23

    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.14 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.17 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.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 для получения ссылок на файлы]

    ---

23. Время запроса: 0.49 ms После последнего запроса: 0.88 ms Память запроса: 0.027 MB. Память перед запросом: 22.418 MB Возвращено строк: 0
    Повторяющиеся запросы: #22

    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.00 ms
    starting	0.02 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.02 ms
    statistics	0.08 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	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 для получения ссылок на файлы]

    ---

24. Время запроса: 2.27 ms После последнего запроса: 3.20 ms Память запроса: 0.028 MB. Память перед запросом: 22.462 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 (387,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.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.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.33 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.32 ms
    preparing	0.05 ms
    Creating tmp table	0.47 ms
    executing	0.47 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 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 для получения ссылок на файлы]

    ---

25. Время запроса: 0.75 ms После последнего запроса: 0.74 ms Память запроса: 0.024 MB. Память перед запросом: 22.511 MB Возвращено строк: 0

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

    План запросов (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.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.29 ms
    preparing	0.03 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

    Стек вызовов

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

    ---

26. Время запроса: 2.09 ms После последнего запроса: 17.35 ms Память запроса: 0.035 MB. Память перед запросом: 22.855 MB Возвращено строк: 41

    SHOW FULL COLUMNS 
      FROM `dr2cm_sh404sef_metas`

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

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

    Профиль

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.50 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.13 ms
    checking permissions	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 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.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.03 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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.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.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

27. Время запроса: 1.31 ms После последнего запроса: 0.22 ms Память запроса: 0.026 MB. Память перед запросом: 22.906 MB Возвращено строк: 1

    SELECT * 
      FROM dr2cm_sh404sef_metas 
      WHERE `newurl`='index.php?option=com_content&Itemid=1031&catid=387&id=5374&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.10 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 ms
    preparing	0.02 ms
    executing	0.83 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

    Стек вызовов

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

    ---

28. Время запроса: 0.50 ms После последнего запроса: 1.23 ms Память запроса: 0.024 MB. Память перед запросом: 22.922 MB Возвращено строк: 1

    SELECT * 
      FROM dr2cm_content_extravote 
      WHERE content_id=5374 
      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.00 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.07 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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 для получения ссылок на файлы]

    ---

29. Время запроса: 0.99 ms После последнего запроса: 0.73 ms Память запроса: 0.024 MB. Память перед запросом: 22.947 MB Возвращено строк: 13

    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 = 387 
      AND a.state = 1 
      AND a.access IN (1,1,5)  
      AND (a.state = 1 OR a.state = -1) 
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-07-12 06:29:02') 
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-07-12 06:29:02')
    
      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	13	16.00	Using where; Используется сортировка файлов
    1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Профиль

    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.00 ms
    Opening tables	0.06 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.23 ms
    preparing	0.06 ms
    executing	0.33 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

    Стек вызовов

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

    ---

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

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

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

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

    Профиль

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 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

    Стек вызовов

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

    ---

31. Время запроса: 0.60 ms После последнего запроса: 3.37 ms Память запроса: 0.027 MB. Память перед запросом: 23.029 MB Возвращено строк: 1

    SELECT *  
      FROM `dr2cm_jcomments_objects` 
      WHERE `object_id` = '5374' 
      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.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.02 ms
    executing	0.09 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    24	JDatabaseDriver->loadObject()	JROOT/components/com_jcomments/models/object.php:28
    23	JCommentsModelObject::getObjectInfo()	JROOT/components/com_jcomments/helpers/object.php:117
    22	JCommentsObjectHelper::fetchObjectInfo()	Такой же, как вызов в строке ниже
    21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/helpers/object.php:159
    19	JCommentsObjectHelper::getObjectInfo()	JROOT/components/com_jcomments/helpers/object.php:46
    18	JCommentsObjectHelper::getLink()	JROOT/components/com_jcomments/classes/factory.php:255
    17	JCommentsFactory::getTemplate()	JROOT/components/com_jcomments/jcomments.php:194
    16	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
    15	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
    14	plgContentJComments->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Время запроса: 0.54 ms После последнего запроса: 0.45 ms Память запроса: 0.025 MB. Память перед запросом: 23.010 MB Возвращено строк: 1

    SELECT count(*)
    
      FROM dr2cm_jcomments AS c
    
      WHERE c.object_id = 5374 
      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.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    18	JCommentsModel::getCommentsCount()	JROOT/components/com_jcomments/jcomments.php:1307
    17	JComments::getCommentsCount()	JROOT/components/com_jcomments/jcomments.php:224
    16	JComments::show()	JROOT/plugins/content/jcomments/jcomments.php:280
    15	plgContentJComments->onAfterDisplayContent()	JROOT/plugins/content/jcomments/jcomments.php:337
    14	plgContentJComments->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:202
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Время запроса: 0.69 ms После последнего запроса: 6.93 ms Память запроса: 0.024 MB. Память перед запросом: 23.164 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.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 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.06 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: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 для получения ссылок на файлы]

    ---

34. Время запроса: 0.41 ms После последнего запроса: 0.38 ms Память запроса: 0.023 MB. Память перед запросом: 23.182 MB Возвращено строк: 1

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

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

    ---

35. Время запроса: 0.47 ms После последнего запроса: 0.18 ms Память запроса: 0.023 MB. Память перед запросом: 23.191 MB Возвращено строк: 0
    Повторяющиеся запросы: #36

    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.06 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.03 ms
    statistics	0.12 ms
    preparing	0.03 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: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 для получения ссылок на файлы]

    ---

36. Время запроса: 0.41 ms После последнего запроса: 0.11 ms Память запроса: 0.024 MB. Память перед запросом: 23.198 MB Возвращено строк: 0
    Повторяющиеся запросы: #35

    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.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.00 ms
    System lock	0.02 ms
    optimizing	0.02 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.01 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

37. Время запроса: 1.99 ms После последнего запроса: 0.20 ms Память запроса: 0.025 MB. Память перед запросом: 23.211 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 = 387
    
      ORDER BY c.lft

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется сортировка файлов
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_left_right	INDEX KEY не используется	NULL	NULL	484	64.03	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.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.03 ms
    executing	1.23 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.21 ms
    cleaning up	0.01 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 для получения ссылок на файлы]

    ---

38. Время запроса: 0.48 ms После последнего запроса: 10.31 ms Память запроса: 0.021 MB. Память перед запросом: 23.261 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.09 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.07 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

    Стек вызовов

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

    ---

39. Время запроса: 1.30 ms После последнего запроса: 10.76 ms Память запроса: 0.028 MB. Память перед запросом: 23.483 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 != 5374 
      AND c.published = 1 
      AND a.state = 1 
      AND c.access IN (1,5) 
      AND a.access IN (1,5) 
      AND a.publish_up <= '2026-07-12 06:29:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 06:29: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.18 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.39 ms
    preparing	0.06 ms
    executing	0.28 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

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

    ---

40. Время запроса: 2.07 ms После последнего запроса: 0.34 ms Память запроса: 0.034 MB. Память перед запросом: 23.510 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.18 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.08 ms
    executing	1.29 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 для получения ссылок на файлы]

    ---

41. Время запроса: 2.15 ms После последнего запроса: 0.91 ms Память запроса: 0.034 MB. Память перед запросом: 23.549 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.18 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.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.18 ms
    preparing	0.05 ms
    executing	1.36 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 для получения ссылок на файлы]

    ---

42. Время запроса: 2.17 ms После последнего запроса: 1.56 ms Память запроса: 0.034 MB. Память перед запросом: 23.583 MB Возвращено строк: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `dr2cm_categories` AS `s`
    
      INNER JOIN `dr2cm_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 358
    
      ORDER BY c.lft

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

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

    Профиль

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

    ---

43. Время запроса: 0.57 ms После последнего запроса: 0.66 ms Память запроса: 0.034 MB. Память перед запросом: 23.608 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.07 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.15 ms
    preparing	0.03 ms
    executing	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	1.81 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 для получения ссылок на файлы]

    ---

44. Время запроса: 0.56 ms После последнего запроса: 1.71 ms Память запроса: 0.034 MB. Память перед запросом: 23.653 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.02 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.13 ms
    preparing	0.03 ms
    executing	0.07 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

    Стек вызовов

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

    ---

45. Время запроса: 2.35 ms После последнего запроса: 2.04 ms Память запроса: 0.027 MB. Память перед запросом: 23.648 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 != 5374 
      AND c.published = 1 
      AND a.state = 1 
      AND c.access IN (1,5) 
      AND a.access IN (1,5) 
      AND a.publish_up <= '2026-07-12 06:29:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 06:29: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.15 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.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.47 ms
    preparing	0.06 ms
    executing	1.31 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.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_raxo_allmode/helper.php:535
    20	ModRaxoAllmodeHelper::getList()	Такой же, как вызов в строке ниже
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
    17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:46
    16	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
    13	JMFTemplate->renderModules()	JROOT/templates/jm-trendy/tpl/blocks/main.php:56
    12	include JROOT/templates/jm-trendy/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    11	JMFTemplate->renderBlock()	JROOT/templates/jm-trendy/tpl/default-ug.php:64
    10	include JROOT/templates/jm-trendy/tpl/default-ug.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
    9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
    8	JMFTemplate->renderScheme()	JROOT/templates/jm-trendy/index.php:14
    7	require JROOT/templates/jm-trendy/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Время запроса: 2.10 ms После последнего запроса: 0.34 ms Память запроса: 0.034 MB. Память перед запросом: 23.672 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.19 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.19 ms
    preparing	0.05 ms
    executing	1.32 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.74 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: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 для получения ссылок на файлы]

    ---

47. Время запроса: 0.51 ms После последнего запроса: 0.59 ms Память запроса: 0.034 MB. Память перед запросом: 23.698 MB Возвращено строк: 1

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

    ---

48. Время запроса: 0.46 ms После последнего запроса: 0.67 ms Память запроса: 0.034 MB. Память перед запросом: 23.721 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1031&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.06 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.03 ms
    executing	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	6.44 ms
    cleaning up	0.06 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 для получения ссылок на файлы]

    ---

49. Время запроса: 1.60 ms После последнего запроса: 7.66 ms Память запроса: 0.034 MB. Память перед запросом: 23.743 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1031&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.35 ms
    Executing hook on transaction	0.01 ms
    starting	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.18 ms
    init	0.03 ms
    System lock	0.07 ms
    optimizing	0.03 ms
    statistics	0.29 ms
    preparing	0.09 ms
    executing	0.16 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.08 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 для получения ссылок на файлы]

    ---

50. Время запроса: 0.57 ms После последнего запроса: 1.11 ms Память запроса: 0.034 MB. Память перед запросом: 23.766 MB Возвращено строк: 1

    SELECT `oldurl`, `dateadd` 
      FROM dr2cm_sh404sef_urls 
      WHERE `newurl`='index.php?option=com_content&Itemid=1031&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.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.09 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

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

    ---

51. Время запроса: 1.19 ms После последнего запроса: 2.30 ms Память запроса: 0.027 MB. Память перед запросом: 23.774 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 != 5374 
      AND c.published = 1 
      AND a.state = 1 
      AND c.access IN (1,5) 
      AND a.access IN (1,5) 
      AND a.publish_up <= '2026-07-12 06:29:00' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-12 06:29: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.24 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.14 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.08 ms
    statistics	0.33 ms
    preparing	0.08 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

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

    ---

52. Время запроса: 0.50 ms После последнего запроса: 15.82 ms Память запроса: 0.021 MB. Память перед запросом: 26.856 MB Возвращено строк: 1
    Повторяющиеся запросы: #11

    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.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.03 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1029
    8	plgSystemEF4_JMFramework->getTemplateName()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:522
    7	plgSystemEF4_JMFramework->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Время запроса: 0.55 ms После последнего запроса: 6.71 ms Память запроса: 0.022 MB. Память перед запросом: 26.997 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_metainfo
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-12-friazino.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.01 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.09 ms
    preparing	0.02 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.01 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 для получения ссылок на файлы]

    ---

54. Время запроса: 0.26 ms После последнего запроса: 0.10 ms Память запроса: 0.022 MB. Память перед запросом: 27.003 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_canonicals
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-12-friazino.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.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.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

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

    ---

55. Время запроса: 0.61 ms После последнего запроса: 8.53 ms Память запроса: 0.020 MB. Память перед запросом: 27.335 MB Возвращено строк: 0

    SELECT *
     
      FROM dr2cm_jmap_headings
     
      WHERE `linkurl` = 'https://www.vsesadiki.ru/detski-sad-12-friazino.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.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.07 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

    Стек вызовов

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

    ---