{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778295176,
                "last": 1778295176,
                "now": 1778295176
            },
            "token": "WOTu7ttpt3GlkJaawRmfilXhB9ACUqRM"
        },
        "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
        }
    }
}

Время

Память

15 SQL-запросов зафиксировано 33.50 ms

1. Время запроса: 0.36 ms Память запроса: 0.019 MB Память до запроса: 4.959 MB Выбрано строк: 0

   SELECT `data`
   
     FROM `bitq5_session`
   
     WHERE `session_id` = X'65367367346a66336936686e333261306174636d353131697535'

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

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

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   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.25 ms После последнего запроса: 1.53 ms Память запроса: 0.011 MB Память до запроса: 5.150 MB Выбрано строк: 0

   SELECT `session_id`
   
     FROM `bitq5_session`
   
     WHERE `session_id` = X'65367367346a66336936686e333261306174636d353131697535' 
     LIMIT 1

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

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

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Время запроса: 0.33 ms После последнего запроса: 0.16 ms Память запроса: 0.010 MB Память до запроса: 5.167 MB

   INSERT INTO `bitq5_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'65367367346a66336936686e333261306174636d353131697535', 1, 1778295176, 0, '', 0)

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

   EXPLAIN не доступен для запроса: INSERT INTO `bitq5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'65367367346a66336936686e333261306174636d353131697535', 1, 1778295176, 0, '', 0)

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Время запроса: 0.29 ms После последнего запроса: 5.81 ms Память запроса: 0.013 MB Память до запроса: 6.015 MB Выбрано строк: 3

   SELECT id, rules
   
     FROM `bitq5_viewlevels`

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

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	bitq5_viewlevels	NULL	ALL	NULL	Индекс не используется	NULL	NULL	3	100.00	NULL

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Время запроса: 0.37 ms После последнего запроса: 0.15 ms Память запроса: 0.014 MB Память до запроса: 6.039 MB Выбрано строк: 1

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

   План SQL-запросов (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	1	100.00	Using where; Using index

   Профилирование SQL-запросов

   Status	Duration
   starting	0.06 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.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.06 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.04 ms
   cleaning up	0.01 ms

   Стек вызовов

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Время запроса: 0.42 ms После последнего запроса: 45.32 ms Память запроса: 0.018 MB Память до запроса: 10.841 MB

   UPDATE `bitq5_extensions`
   
     SET `params` = '{\"mediaversion\":\"a57322a9b4d7477ea34e14471aa99e45\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

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

   EXPLAIN не доступен для запроса: UPDATE `bitq5_extensions` SET `params` = '{\"mediaversion\":\"a57322a9b4d7477ea34e14471aa99e45\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:58
   9	plgSystemBdthemes_Shortcodes->onAfterRoute()	Same as call in the line below.
   8	call_user_func_array()	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 для получения ссылок на файлы]

   ---

7. Время запроса: 1.09 ms После последнего запроса: 104.72 ms Память запроса: 0.018 MB Память до запроса: 21.872 MB Выбрано строк: 1439

   SELECT 
   					c.id AS CID
   				
     FROM 
   					bitq5_categories AS c
   				
     LEFT JOIN 
   					bitq5_content AS content 
   					
     ON 
   					c.id = content.catid 
   						
   				
     WHERE 
   					1=1 
   					 
     AND ( c.id = 3) 
   					
     AND 
   					c.extension = 'com_content' 
     AND 
   					c.published = 1

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

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	c	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	content	NULL	ref	idx_catid	idx_catid	4	const	1439	100.00	Using index

   Профилирование SQL-запросов

   Status	Duration
   starting	0.15 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.11 ms
   preparing	0.03 ms
   executing	0.39 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.03 ms

   Стек вызовов

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   14	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85
   13	NSP_GK5_com_content_Model::getSources()	Same as call in the line below.
   12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:100
   11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
   10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
   9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
   8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
   7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
   6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
   5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
   4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
   3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
   2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Время запроса: 16.67 ms После последнего запроса: 2.30 ms Память запроса: 0.018 MB Память до запроса: 22.081 MB Выбрано строк: 4

   SELECT
   			content.id AS iid				
   		
     FROM 
   			bitq5_content AS content
   			 
   			 
   			
   		
     WHERE 
   			content.state = 1
                    
     AND content.access IN (1,1)    
   		 		
     AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2026-05-09 05:52:56' )
   				
     AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2026-05-09 05:52:56' )
   			 
     AND (  content.catid = 3 ) 
   			
   			 
   			
   			
   			
   		
   		
   		
     ORDER BY 
   			 content.created DESC 
   		
     LIMIT
   			0,4;

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

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	content	NULL	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state,idx_access	4,1,4	NULL	359	15.97	Using intersect(idx_catid,idx_state,idx_access); Using where; Используется filesort

   Профилирование SQL-запросов

   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.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.10 ms
   preparing	0.03 ms
   executing	16.19 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.02 ms

   Стек вызовов

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268
   13	NSP_GK5_com_content_Model::getArticles()	Same as call in the line below.
   12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:114
   11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
   10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
   9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
   8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
   7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
   6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
   5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
   4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
   3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
   2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Время запроса: 0.77 ms После последнего запроса: 0.16 ms Память запроса: 0.018 MB Память до запроса: 22.106 MB Выбрано строк: 4

   SELECT
   			content.id AS iid,
   			content.title AS title, 
   			content.fulltext AS text,
   			content.created AS date,  
   			content.publish_up AS date_publish,
   			content.hits AS hits,
   			content.images AS images,
   			content.featured AS frontpage,
   			content.access AS access,
   			content.language AS lang,
   			categories.title AS catname, 
   			users.email AS author_email,
   			content.created_by_alias AS author_alias,
   			users.name AS author_username,
   			content_rating.rating_sum AS rating_sum,
   			content_rating.rating_count AS rating_count,
   			
     CASE WHEN CHAR_LENGTH(content.alias) 
   				THEN CONCAT_WS(":", content.id, content.alias) 
   					ELSE content.id END as id, 
   			
     CASE WHEN CHAR_LENGTH(categories.alias) 
   				THEN CONCAT_WS(":", categories.id, categories.alias) 
   					ELSE categories.id END as cid			
   		
     FROM 
   			bitq5_content AS content 
   			
     LEFT JOIN 
   				bitq5_categories AS categories 
   				
     ON categories.id = content.catid 
   			
     LEFT JOIN 
   				bitq5_users AS users 
   				
     ON users.id = content.created_by 			
   			
     LEFT JOIN 
   				bitq5_content_rating AS content_rating 
   				
     ON content_rating.content_id = content.id
   			
     LEFT JOIN 
   				bitq5_content_frontpage AS content_frontpage 
   				
     ON content_frontpage.content_id = content.id
   		
     WHERE 
   			1=1
   			 
     AND ( content.id = 265460 OR  content.id = 265455 OR  content.id = 265449 OR  content.id = 265448)
   		
     ORDER BY 
   			 content.created DESC

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

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	content	NULL	range	PRIMARY	PRIMARY	4	NULL	4	100.00	Using where; Using temporary; Используется filesort
   1	SIMPLE	categories	NULL	eq_ref	PRIMARY	PRIMARY	4	origamib_hrmby.content.catid	1	100.00	Using where
   1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	origamib_hrmby.content.created_by	1	100.00	Using where
   1	SIMPLE	content_rating	NULL	ALL	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
   1	SIMPLE	content_frontpage	NULL	eq_ref	PRIMARY	PRIMARY	4	origamib_hrmby.content.id	1	100.00	Using where; Using index

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332
   13	NSP_GK5_com_content_Model::getArticles()	Same as call in the line below.
   12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:114
   11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
   10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
   9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
   8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
   7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
   6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
   5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
   4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
   3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
   2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Время запроса: 0.79 ms После последнего запроса: 1.70 ms Память запроса: 0.035 MB Память до запроса: 22.311 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 `bitq5_categories` AS `s`
    
      INNER JOIN `bitq5_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) 
      AND c.published = 1 
      AND s.id = 3
    
      ORDER BY c.lft

    План SQL-запросов (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	Используется filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	129	79.32	Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.30 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.05 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Same as call in the line below.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    15	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    14	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    13	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41
    12	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Время запроса: 2.93 ms После последнего запроса: 4.70 ms Память запроса: 0.018 MB Память до запроса: 22.541 MB Выбрано строк: 9829

    SELECT 
    					c.id AS CID
    				
      FROM 
    					bitq5_categories AS c
    				
      LEFT JOIN 
    					bitq5_content AS content 
    					
      ON 
    					c.id = content.catid 
    						
    				
      WHERE 
    					1=1 
    					 
      AND ( c.id = 249) 
    					
      AND 
    					c.extension = 'com_content' 
      AND 
    					c.published = 1

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	content	NULL	ref	idx_catid	idx_catid	4	const	9829	100.00	Using index

    Профилирование SQL-запросов

    Status	Duration
    starting	0.06 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.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	2.43 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.05 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:85
    13	NSP_GK5_com_content_Model::getSources()	Same as call in the line below.
    12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:100
    11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Время запроса: 7.50 ms После последнего запроса: 17.63 ms Память запроса: 0.018 MB Память до запроса: 23.285 MB Выбрано строк: 1

    SELECT
    			content.id AS iid				
    		
      FROM 
    			bitq5_content AS content
    			 
    			 
    			
      LEFT JOIN bitq5_content_frontpage as content_frontpage 
      ON id = content_id
    		
      WHERE 
    			content.state = 1
                       
    		 		
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2026-05-09 05:52:56' )
    				
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2026-05-09 05:52:56' )
    			 
      AND (  content.catid = 249 ) 
    			
    			 
      AND content.featured = 1 
    			
    			
    			
    		
    		
    		
      ORDER BY 
    			 content.publish_up DESC 
    		
      LIMIT
    			0,1;

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	index_merge	idx_state,idx_catid,idx_featured_catid	idx_featured_catid,idx_state	5,1	NULL	176	15.95	Using intersect(idx_featured_catid,idx_state); Using where; Используется filesort
    1	SIMPLE	content_frontpage	NULL	eq_ref	PRIMARY	PRIMARY	4	origamib_hrmby.content.id	1	100.00	Using where; Using index

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:268
    13	NSP_GK5_com_content_Model::getArticles()	Same as call in the line below.
    12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:114
    11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Время запроса: 0.53 ms После последнего запроса: 0.16 ms Память запроса: 0.018 MB Память до запроса: 23.307 MB Выбрано строк: 1

    SELECT
    			content.id AS iid,
    			content.title AS title, 
    			content.fulltext AS text,
    			content.created AS date,  
    			content.publish_up AS date_publish,
    			content.hits AS hits,
    			content.images AS images,
    			content.featured AS frontpage,
    			content.access AS access,
    			content.language AS lang,
    			categories.title AS catname, 
    			users.email AS author_email,
    			content.created_by_alias AS author_alias,
    			users.name AS author_username,
    			content_rating.rating_sum AS rating_sum,
    			content_rating.rating_count AS rating_count,
    			
      CASE WHEN CHAR_LENGTH(content.alias) 
    				THEN CONCAT_WS(":", content.id, content.alias) 
    					ELSE content.id END as id, 
    			
      CASE WHEN CHAR_LENGTH(categories.alias) 
    				THEN CONCAT_WS(":", categories.id, categories.alias) 
    					ELSE categories.id END as cid			
    		
      FROM 
    			bitq5_content AS content 
    			
      LEFT JOIN 
    				bitq5_categories AS categories 
    				
      ON categories.id = content.catid 
    			
      LEFT JOIN 
    				bitq5_users AS users 
    				
      ON users.id = content.created_by 			
    			
      LEFT JOIN 
    				bitq5_content_rating AS content_rating 
    				
      ON content_rating.content_id = content.id
    			
      LEFT JOIN 
    				bitq5_content_frontpage AS content_frontpage 
    				
      ON content_frontpage.content_id = content.id
    		
      WHERE 
    			1=1
    			 
      AND ( content.id = 265438)
    		
      ORDER BY 
    			 content.publish_up DESC

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	content_rating	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	SIMPLE	content_frontpage	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/model.php:332
    13	NSP_GK5_com_content_Model::getArticles()	Same as call in the line below.
    12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:114
    11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Время запроса: 0.80 ms После последнего запроса: 0.40 ms Память запроса: 0.035 MB Память до запроса: 23.341 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 `bitq5_categories` AS `s`
    
      INNER JOIN `bitq5_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) 
      AND c.published = 1 
      AND s.id = 249
    
      ORDER BY c.lft

    План SQL-запросов (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	Используется filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	129	85.81	Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.31 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.05 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Caller	File and line number
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Same as call in the line below.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:189
    15	NSP_GK5_com_content_View::itemLink()	JROOT/modules/mod_news_pro_gk5/tmpl/com_content/view.php:22
    14	NSP_GK5_com_content_View::image()	JROOT/modules/mod_news_pro_gk5/tmpl/view.php:25
    13	NSP_GK5_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_content/controller.php:41
    12	NSP_GK5_com_content_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:180
    11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:28
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Время запроса: 0.39 ms После последнего запроса: 7.39 ms Память запроса: 0.019 MB Память до запроса: 24.193 MB Выбрано строк: 87

    SELECT * 
      FROM bitq5_acymailing_config

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

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	bitq5_acymailing_config	NULL	ALL	NULL	Индекс не используется	NULL	NULL	87	100.00	NULL

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
    14	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
    12	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
    11	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
    10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
    9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
    8	plgSystemRegacymailing->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	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 для получения ссылок на файлы]

    ---

12 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

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

2. 2 × SELECT    content.id AS iid,    content.title AS title,     content.fulltext AS text,    content.created AS date,      content.publish_up AS date_publish,    content.hits AS hits,    content.images AS images,    content.featured AS frontpage,    content.access AS access,    content.language AS lang,    categories.title AS catname,     users.email AS author_email,    content.created_by_alias AS author_alias,    users.name AS author_username,    content_rating.rating_sum AS rating_sum,    content_rating.rating_count AS rating_count,    
     CASE WHEN CHAR_LENGTH(content.alias)      THEN CONCAT_WS(":", content.id, content.alias)       ELSE content.id END as id,     
     CASE WHEN CHAR_LENGTH(categories.alias)      THEN CONCAT_WS(":", categories.id, categories.alias)       ELSE categories.id END as cid      
     FROM     bitq5_content AS content     
     LEFT JOIN      bitq5_categories AS categories      
     ON categories.id = content.catid     
     LEFT JOIN      bitq5_users AS users      
     ON users.id = content.created_by        
     LEFT JOIN      bitq5_content_rating AS content_rating      
     ON content_rating.content_id = content.id    
     LEFT JOIN      bitq5_content_frontpage AS content_frontpage      
     ON content_frontpage.content_id = content.id

3. 2 × SELECT       c.id AS CID     
     FROM       bitq5_categories AS c     
     LEFT JOIN       bitq5_content AS content       
     ON       c.id = content.catid

4. 1 × SELECT    content.id AS iid       
     FROM     bitq5_content AS content              
     LEFT JOIN bitq5_content_frontpage as content_frontpage 
     ON id = content_id

5. 1 × SELECT * 
     FROM bitq5_acymailing_confi

6. 1 × SELECT `session_id` 
     FROM `bitq5_session`

7. 1 × SELECT id, rules 
     FROM `bitq5_viewlevels

8. 1 × SELECT `data` 
     FROM `bitq5_session`

9. 1 × SELECT    content.id AS iid       
     FROM     bitq5_content AS content

10. 1 × SELECT b.id 
      FROM bitq5_usergroups AS a 
      LEFT JOIN bitq5_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

Прочие SQL-запросы:

1. 1 × UPDATE `bitq5_extensions` 
     SET `params` = '{\"mediaversion\":\"a57322a9b4d7477ea34e14471aa99e45\"}'

2. 1 × INSERT INTO `bitq5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'65367367346a66336936686e333261306174636d353131697535', 1, 1778295176, 0, '', 0