85 лет Н.Ф. Левину

Список материалов в категории 85 лет Н.Ф. Левину
Заголовок	Кол-во просмотров
«Псковский американец» Георг Францевич Викенгейзер	Просмотров: 4378
Александр Невский	Просмотров: 6227
Археология	Просмотров: 5226
Архитекторы	Просмотров: 4665
Военная история	Просмотров: 5197
Выставка книг и статей Натана Феликсовича Левина	Просмотров: 12565
Изборск	Просмотров: 5643
Изборская улица	Просмотров: 5492
Историческое обоснование ходатайства О присвоении Пскову Почётного звания Российской Федерации «Город воинской славы»	Просмотров: 10250
История	Просмотров: 5718

Консоль отладки Joomla

Сессия

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

Профилирование

Время

Память

Время: 32.71 ms / 32.71 ms Память: 1.516 MB / 1.85 MB Application: afterLoad

Время: 218.08 ms / 250.80 ms Память: 6.641 MB / 8.49 MB Application: afterInitialise

Время: 32.53 ms / 283.33 ms Память: 1.444 MB / 9.94 MB Application: afterRoute

Время: 1.54 ms / 284.87 ms Память: 0.034 MB / 9.97 MB Application: beforeRenderComponent com_content

Время: 10.05 ms / 294.92 ms Память: 0.679 MB / 10.65 MB Application: Before Access::preloadComponents (all components)

Время: 1.78 ms / 296.70 ms Память: 0.058 MB / 10.71 MB Application: After Access::preloadComponents (all components)

Время: 0.04 ms / 296.74 ms Память: -0.002 MB / 10.71 MB Application: Before Access::preloadPermissions (com_content)

Время: 23.92 ms / 320.66 ms Память: 4.640 MB / 15.35 MB Application: After Access::preloadPermissions (com_content)

Время: 0.24 ms / 320.90 ms Память: -0.128 MB / 15.22 MB Application: Before Access::getAssetRules (id:258 name:com_content.category.142)

Время: 0.67 ms / 321.57 ms Память: 0.025 MB / 15.25 MB Application: After Access::getAssetRules (id:258 name:com_content.category.142)

Время: 5.47 ms / 327.03 ms Память: 0.184 MB / 15.43 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Время: 0.12 ms / 327.15 ms Память: 0.006 MB / 15.44 MB Application: After Access::getAssetRules (id:8 name:com_content)

Время: 186.05 ms / 513.20 ms Память: 2.935 MB / 18.37 MB Application: afterRenderComponent com_content

Время: 0.38 ms / 513.57 ms Память: 0.004 MB / 18.37 MB Application: afterDispatch

Время: 24.55 ms / 538.12 ms Память: 2.016 MB / 20.39 MB Application: beforeRenderModule mod_banners (Menu Ad)

Время: 23.82 ms / 561.94 ms Память: 0.201 MB / 20.59 MB Application: afterRenderModule mod_banners (Menu Ad)

Время: 10.05 ms / 571.99 ms Память: 0.032 MB / 20.62 MB Application: beforeRenderModule mod_custom (Menu News 3)

Время: 3.12 ms / 575.11 ms Память: 0.026 MB / 20.65 MB Application: afterRenderModule mod_custom (Menu News 3)

Время: 42.04 ms / 617.15 ms Память: 0.244 MB / 20.89 MB Application: beforeRenderModule mod_custom (Счетчик mail)

Время: 0.39 ms / 617.54 ms Память: 0.006 MB / 20.90 MB Application: afterRenderModule mod_custom (Счетчик mail)

Время: 0.09 ms / 617.63 ms Память: -0.002 MB / 20.90 MB Application: beforeRenderModule mod_custom (Контакты)

Время: 1.03 ms / 618.66 ms Память: 0.004 MB / 20.90 MB Application: afterRenderModule mod_custom (Контакты)

Время: 0.09 ms / 618.75 ms Память: 0.012 MB / 20.91 MB Application: beforeRenderModule mod_news_show_sp2 (Сего Дня)

Время: 83.58 ms / 702.34 ms Память: 1.035 MB / 21.95 MB Application: afterRenderModule mod_news_show_sp2 (Сего Дня)

Время: 0.07 ms / 702.40 ms Память: -0.064 MB / 21.88 MB Application: beforeRenderModule mod_banners (Sidebar Ad 2 (Дыхания банер))

Время: 42.78 ms / 745.19 ms Память: 0.026 MB / 21.91 MB Application: afterRenderModule mod_banners (Sidebar Ad 2 (Дыхания банер))

Время: 0.16 ms / 745.35 ms Память: 0.002 MB / 21.91 MB Application: beforeRenderModule mod_breadcrumbs (breadcrumbs)

Время: 2.41 ms / 747.76 ms Память: 0.025 MB / 21.94 MB Application: afterRenderModule mod_breadcrumbs (breadcrumbs)

Время: 0.08 ms / 747.84 ms Память: -0.005 MB / 21.93 MB Application: beforeRenderModule mod_search (Search)

Время: 0.90 ms / 748.73 ms Память: 0.015 MB / 21.95 MB Application: afterRenderModule mod_search (Search)

Время: 14.61 ms / 763.34 ms Память: 0.444 MB / 22.39 MB Application: afterRender

Всего запросов к базе данных: 279.89 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_session	const	PRIMARY	PRIMARY	194	const	1

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:46
14	JSessionStorageDatabase->read()	Такой же, как вызов в строке ниже
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:266
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:835
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:145
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:395
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_session	const	PRIMARY	PRIMARY	194	const	1

#	Вызывающий объект	Файл и номер строки
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:163
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:837
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:145
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:395
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	14.52 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.03 ms
Update	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	17.03 ms
Query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:163
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:837
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:145
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:395
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 для получения ссылок на файлы]

Время запроса: 1.33 ms После последнего запроса: 5.21 ms Память запроса: 0.037 MB. Память перед запросом: 3.751 MB Возвращено строк: 43

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ecifm_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_extensions	ref	extension	extension	82	const	44	Using index condition; Using where

Профиль

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.45 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::{closure:Joomla\CMS\Component\ComponentHelper::load():434}()	Такой же, как вызов в строке ниже
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.80 ms После последнего запроса: 4.86 ms Память запроса: 0.020 MB. Память перед запросом: 3.932 MB Возвращено строк: 4

SELECT id, rules

  FROM `ecifm_viewlevels`

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

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

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.03 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:466
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.86 ms После последнего запроса: 0.24 ms Память запроса: 0.020 MB. Память перед запросом: 3.941 MB Возвращено строк: 1

SELECT b.id

  FROM ecifm_usergroups AS a

  LEFT JOIN ecifm_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:466
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.86 ms После последнего запроса: 1.61 ms Память запроса: 0.022 MB. Память перед запросом: 4.007 MB Возвращено строк: 102

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM ecifm_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_extensions	ALL	extension	INDEX KEY не используется	NULL	NULL	285	Using where; Используется сортировка файлов

Профиль

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.96 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::{closure:Joomla\CMS\Plugin\PluginHelper::load():323}()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.97 ms После последнего запроса: 39.19 ms Память запроса: 0.024 MB. Память перед запросом: 5.426 MB Возвращено строк: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ecifm_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Профиль

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
19	Joomla\CMS\Helper\LibraryHelper::{closure:Joomla\CMS\Helper\LibraryHelper::loadLibrary():157}()	Такой же, как вызов в строке ниже
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:330
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:25
8	plgSystemHelix->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:677
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 22.23 ms После последнего запроса: 0.31 ms Память запроса: 0.007 MB. Память перед запросом: 5.419 MB

UPDATE `ecifm_extensions`

  SET `params` = '{\"mediaversion\":\"9dfb2789cef14581f51b5b9a9f161cbb\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

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

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

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.03 ms
Updating main table	0.02 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.10 ms
Updating	0.12 ms
End of update loop	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	21.46 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:381
14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:340
13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:25
8	plgSystemHelix->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:677
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.97 ms После последнего запроса: 4.05 ms Память запроса: 0.596 MB. Память перед запросом: 5.655 MB Возвращено строк: 383

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM ecifm_menu AS m

  LEFT JOIN ecifm_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	INDEX KEY не используется	NULL	NULL	426	Using where; Используется сортировка файлов
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bakas.m.component_id	1	Using where

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	3.35 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
23	Joomla\CMS\Menu\SiteMenu->{closure:Joomla\CMS\Menu\SiteMenu::load():77}()	Такой же, как вызов в строке ниже
22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
20	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
19	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
18	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
17	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:426
16	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
15	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:110
12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:303
11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:291
10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1548
9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:26
8	plgSystemHelix->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:677
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.80 ms После последнего запроса: 5.06 ms Память запроса: 0.054 MB. Память перед запросом: 6.814 MB Возвращено строк: 12

SELECT id, home, template, s.params

  FROM ecifm_template_styles as s

  LEFT JOIN ecifm_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	12	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	bakas.e.element	1	Using index condition; Using where

Профиль

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:110
12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:303
11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:291
10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1548
9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:26
8	plgSystemHelix->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:677
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.64 ms После последнего запроса: 19.02 ms Память запроса: 0.024 MB. Память перед запросом: 8.026 MB Возвращено строк: 1

SELECT id,template 
  FROM ecifm_template_styles 
  WHERE client_id=0 
  AND home=1

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

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

Профиль

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure:/var/ftp/pskoviana/administrator/components/com_widgetkit/widgetkit.php:20}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->{closure:YOOtheme\Widgetkit\Application::__construct():44}()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->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:677
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.44 ms После последнего запроса: 28.49 ms Память запроса: 0.021 MB. Память перед запросом: 9.283 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 `ecifm_categories` AS `s`

  INNER JOIN `ecifm_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 = 142

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	25	Using index condition; Using where

Профиль

Status	Duration
Starting	0.24 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.08 ms
Statistics	0.24 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:359
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
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:1151
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.95 ms После последнего запроса: 2.98 ms Память запроса: 0.024 MB. Память перед запросом: 9.435 MB Возвращено строк: 91

SELECT *

  FROM `ecifm_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_jcomments_settings	ref	PRIMARY	PRIMARY	214	const,const	91	Using where

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
14	JCommentsCfg::_load()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/classes/config.php:159
11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->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:1199
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.88 ms После последнего запроса: 9.14 ms Память запроса: 0.019 MB. Память перед запросом: 9.952 MB Возвращено строк: 1

SELECT *

  FROM ecifm_languages

  WHERE published=1

  ORDER BY ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_languages	ALL	NULL	INDEX KEY не используется	NULL	NULL	1	Using where; Используется сортировка файлов

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.52 ms После последнего запроса: 10.62 ms Память запроса: 0.025 MB. Память перед запросом: 10.655 MB Возвращено строк: 43

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `ecifm_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_cpanel','com_fields','com_finder','com_importjoomla','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_pskoviana','com_pskovlib','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper','com_zoo')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_assets	range	idx_asset_name	idx_asset_name	202	NULL	44	Using index condition

Профиль

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.24 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.57 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:406
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 11.77 ms После последнего запроса: 0.27 ms Память запроса: 0.591 MB. Память перед запросом: 10.709 MB Возвращено строк: 5214

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `ecifm_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

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

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

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	11.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:406
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.48 ms После последнего запроса: 13.24 ms Память запроса: 0.023 MB. Память перед запросом: 15.240 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,(
SELECT COUNT(i.`id`)

  FROM `ecifm_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `ecifm_categories` AS `s`

  INNER JOIN `ecifm_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id = 142

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	PRIMARY	c	range	cat_idx,idx_left_right	idx_left_right	4	NULL	25	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	bakas.c.id	12	Using index condition; Using where

Профиль

Status	Duration
Starting	0.25 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.07 ms
Statistics	0.21 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.18 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	0.62 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	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/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.76 ms После последнего запроса: 2.95 ms Память запроса: 0.289 MB. Память перед запросом: 15.435 MB Возвращено строк: 10

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM ecifm_content AS a

  LEFT JOIN ecifm_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ecifm_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ecifm_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ecifm_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 142 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-02 09:00:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-02 09:00:38')

  ORDER BY  c.path,  a.title,  a.created   
  LIMIT 10

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

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

Профиль

Status	Duration
Starting	0.39 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.20 ms
Optimizing	0.11 ms
Statistics	0.22 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.08 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	1.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.65 ms После последнего запроса: 2.58 ms Память запроса: 0.023 MB. Память перед запросом: 15.795 MB Возвращено строк: 2

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 3226 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.77 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.60 ms После последнего запроса: 0.30 ms Память запроса: 0.023 MB. Память перед запросом: 15.817 MB Возвращено строк: 2

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1157 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.75 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.08 ms После последнего запроса: 0.29 ms Память запроса: 0.023 MB. Память перед запросом: 15.840 MB Возвращено строк: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1129 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.25 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1121 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	6.75 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.56 ms После последнего запроса: 0.52 ms Память запроса: 0.023 MB. Память перед запросом: 15.876 MB Возвращено строк: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1159 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.66 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 8.19 ms После последнего запроса: 0.51 ms Память запроса: 0.023 MB. Память перед запросом: 15.894 MB Возвращено строк: 2

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1115 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	7.31 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.68 ms После последнего запроса: 0.39 ms Память запроса: 0.023 MB. Память перед запросом: 15.916 MB Возвращено строк: 2

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1155 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.79 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.69 ms После последнего запроса: 0.58 ms Память запроса: 0.023 MB. Память перед запросом: 15.939 MB Возвращено строк: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1152 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.87 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1176 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.27 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 6.82 ms После последнего запроса: 0.43 ms Память запроса: 0.023 MB. Память перед запросом: 15.975 MB Возвращено строк: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1120 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	6.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.30 ms После последнего запроса: 3.27 ms Память запроса: 0.023 MB. Память перед запросом: 16.068 MB Возвращено строк: 1

SELECT COUNT(*)

  FROM ecifm_content AS a

  LEFT JOIN ecifm_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ecifm_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ecifm_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ecifm_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 142 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-02 09:00:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-02 09:00:38')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	72	Using where

Профиль

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.08 ms
Statistics	0.19 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.33 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:290
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:430
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 142 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	5.81 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.82 ms После последнего запроса: 29.10 ms Память запроса: 0.024 MB. Память перед запросом: 17.054 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ecifm_fields AS a

  LEFT JOIN `ecifm_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ecifm_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ecifm_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ecifm_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `ecifm_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 (142,0,25)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

Профиль

Status	Duration
Starting	0.24 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.09 ms
Statistics	0.22 ms
Preparing	0.09 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.36 ms
Creating sort index	0.06 ms
Removing tmp table	0.08 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.17 ms После последнего запроса: 44.90 ms Память запроса: 0.027 MB. Память перед запросом: 18.228 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ecifm_fields AS a

  LEFT JOIN `ecifm_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ecifm_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ecifm_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ecifm_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_content.categories' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

Профиль

Status	Duration
Starting	0.25 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.09 ms
Statistics	0.28 ms
Preparing	0.10 ms
Creating tmp table	0.11 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.48 ms
Creating sort index	0.08 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
14	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:709
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.04 ms После последнего запроса: 1.11 ms Память запроса: 0.027 MB. Память перед запросом: 18.249 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ecifm_fields AS a

  LEFT JOIN `ecifm_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ecifm_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ecifm_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ecifm_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `ecifm_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (142,0,25)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

Профиль

Status	Duration
Starting	0.24 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.09 ms
Statistics	0.23 ms
Preparing	0.10 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.47 ms
Creating sort index	0.07 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
21	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
20	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:28
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
14	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:709
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.91 ms После последнего запроса: 0.58 ms Память запроса: 0.028 MB. Память перед запросом: 18.269 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ecifm_fields AS a

  LEFT JOIN `ecifm_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ecifm_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ecifm_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ecifm_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_content.category.title' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

Профиль

Status	Duration
Starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.11 ms
Optimizing	0.08 ms
Statistics	0.21 ms
Preparing	0.09 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.43 ms
Creating sort index	0.07 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
21	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/joomla/content/category_default.php:57
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
14	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:709
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
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:234
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.95 ms После последнего запроса: 30.38 ms Память запроса: 0.024 MB. Память перед запросом: 20.364 MB Возвращено строк: 1

SELECT id, title, module, position, content, showtitle, params

  FROM ecifm_modules AS m

  WHERE m.published = 1 
  AND m.id = 166 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-11-02 09:00:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-02 09:00:38') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY position, ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Профиль

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/menu.php:672
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:270
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:245
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:603
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:606
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:524
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:555
11	HelixMenu->showMenu()	JROOT/plugins/system/helix/features/menu.php:76
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:223
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1135
8	Helix::Header()	JROOT/templates/shaper_sportson/index.php:35
7	require JROOT/templates/shaper_sportson/index.php	JROOT/libraries/src/Document/HtmlDocument.php:721
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:572
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1107
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.66 ms После последнего запроса: 0.91 ms Память запроса: 0.025 MB. Память перед запросом: 20.440 MB Возвращено строк: 0

Повторяющиеся запросы: #50

SELECT *

  FROM ecifm_banners

  WHERE '2026-11-02 09:00:38' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

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

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

Профиль

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.05 ms
Executing	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
20	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/helix/core/classes/joomla25/helper.php:175
18	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:687
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:270
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:245
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:603
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:606
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:524
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:555
11	HelixMenu->showMenu()	JROOT/plugins/system/helix/features/menu.php:76
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:223
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1135
8	Helix::Header()	JROOT/templates/shaper_sportson/index.php:35
7	require JROOT/templates/shaper_sportson/index.php	JROOT/libraries/src/Document/HtmlDocument.php:721
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:572
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1107
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.98 ms После последнего запроса: 1.20 ms Память запроса: 0.026 MB. Память перед запросом: 20.567 MB Возвращено строк: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM ecifm_banners as a

  LEFT JOIN ecifm_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-02 09:00:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-02 09:00:38') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
  AND a.catid IN (24)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 5

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	2	Using where; Используется сортировка файлов
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	bakas.a.cid	1

Профиль

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
21	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
20	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/helix/core/classes/joomla25/helper.php:175
18	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:687
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:270
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:245
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:603
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:606
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:524
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:555
11	HelixMenu->showMenu()	JROOT/plugins/system/helix/features/menu.php:76
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:223
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1135
8	Helix::Header()	JROOT/templates/shaper_sportson/index.php:35
7	require JROOT/templates/shaper_sportson/index.php	JROOT/libraries/src/Document/HtmlDocument.php:721
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:572
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1107
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 18.80 ms После последнего запроса: 0.20 ms Память запроса: 0.009 MB. Память перед запросом: 20.582 MB

UPDATE ecifm_banners

  SET impmade = (impmade + 1)

  WHERE id IN (17)

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

EXPLAIN недоступен для: UPDATE ecifm_banners SET impmade = (impmade + 1) WHERE id IN (17)

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.02 ms
Updating main table	0.02 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.06 ms
Updating	0.15 ms
End of update loop	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	18.08 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:268
21	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
20	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/helix/core/classes/joomla25/helper.php:175
18	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:687
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:270
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:245
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:603
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:606
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:524
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:555
11	HelixMenu->showMenu()	JROOT/plugins/system/helix/features/menu.php:76
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:223
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1135
8	Helix::Header()	JROOT/templates/shaper_sportson/index.php:35
7	require JROOT/templates/shaper_sportson/index.php	JROOT/libraries/src/Document/HtmlDocument.php:721
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:572
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1107
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.64 ms После последнего запроса: 10.48 ms Память запроса: 0.024 MB. Память перед запросом: 20.596 MB Возвращено строк: 1

SELECT id, title, module, position, content, showtitle, params

  FROM ecifm_modules AS m

  WHERE m.published = 1 
  AND m.id = 219 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-11-02 09:00:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-02 09:00:38') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY position, ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/menu.php:672
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:270
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:245
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:603
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:606
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:524
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:555
11	HelixMenu->showMenu()	JROOT/plugins/system/helix/features/menu.php:76
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:223
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1135
8	Helix::Header()	JROOT/templates/shaper_sportson/index.php:35
7	require JROOT/templates/shaper_sportson/index.php	JROOT/libraries/src/Document/HtmlDocument.php:721
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:572
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1107
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.41 ms После последнего запроса: 0.61 ms Память запроса: 0.029 MB. Память перед запросом: 20.649 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ecifm_fields AS a

  LEFT JOIN `ecifm_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ecifm_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ecifm_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ecifm_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

Профиль

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.06 ms
Statistics	0.16 ms
Preparing	0.06 ms
Creating tmp table	0.08 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.32 ms
Creating sort index	0.05 ms
Removing tmp table	0.08 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
30	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
29	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
28	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
27	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
26	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
24	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
23	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
22	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
21	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
20	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
19	include JROOT/modules/mod_custom/mod_custom.php	JROOT/plugins/system/helix/core/classes/joomla25/helper.php:175
18	JModuleHelper::renderModule()	JROOT/plugins/system/helix/core/classes/menu.php:687
17	HelixMenu->loadModule()	JROOT/plugins/system/helix/core/classes/menu.php:270
16	HelixMenu->loadSubContent()	JROOT/plugins/system/helix/core/classes/menu.php:245
15	HelixMenu->genMenuItem()	JROOT/plugins/system/helix/core/classes/menu.php:603
14	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:606
13	HelixMenu->genMenuItems()	JROOT/plugins/system/helix/core/classes/menu.php:524
12	HelixMenu->genMenu()	JROOT/plugins/system/helix/core/classes/menu.php:555
11	HelixMenu->showMenu()	JROOT/plugins/system/helix/features/menu.php:76
10	HelixFeatureMenu->onPosition()	JROOT/plugins/system/helix/core/helix.php:223
9	Helix::importFeatures()	JROOT/plugins/system/helix/core/helix.php:1135
8	Helix::Header()	JROOT/templates/shaper_sportson/index.php:35
7	require JROOT/templates/shaper_sportson/index.php	JROOT/libraries/src/Document/HtmlDocument.php:721
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:572
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1107
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.13 ms После последнего запроса: 37.10 ms Память запроса: 0.449 MB. Память перед запросом: 20.779 MB Возвращено строк: 207

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM ecifm_modules AS m

  LEFT JOIN ecifm_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN ecifm_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-11-02 09:00:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-02 09:00:38') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 214 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering, m.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	5	const,const	46	Using where; Используется сортировка файлов
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	bakas.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bakas.m.id	12	Using where

Профиль

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.08 ms
Statistics	0.18 ms
Preparing	0.10 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	2.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:451
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:379
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:86
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:618
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix/core/helix.php:720
11	Helix::countModules()	JROOT/plugins/system/helix/core/helix.php:352
10	Helix::showRow()	JROOT/plugins/system/helix/core/helix.php:429
9	Helix::generatelayout()	JROOT/plugins/system/helix/core/helix.php:698
8	Helix::layout()	JROOT/templates/shaper_sportson/index.php:60
7	require JROOT/templates/shaper_sportson/index.php	JROOT/libraries/src/Document/HtmlDocument.php:721
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:572
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1107
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 11.07 ms После последнего запроса: 8.13 ms Память запроса: 0.022 MB. Память перед запросом: 21.186 MB Возвращено строк: 2

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM ecifm_content AS a

  LEFT JOIN ecifm_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ecifm_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ecifm_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ecifm_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (206,210,218,222,224,251,255,256,258,261,262,265) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-02 09:00:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-02 09:00:38')

  ORDER BY a.created ASC 
  LIMIT 10

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

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

Профиль

Status	Duration
Starting	0.38 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.20 ms
Optimizing	0.11 ms
Statistics	0.32 ms
Preparing	0.25 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	9.21 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
11	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:152
10	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.80 ms После последнего запроса: 0.30 ms Память запроса: 0.022 MB. Память перед запросом: 21.220 MB Возвращено строк: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2867 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	6.94 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
12	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
11	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:152
10	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.88 ms После последнего запроса: 0.27 ms Память запроса: 0.022 MB. Память перед запросом: 21.236 MB Возвращено строк: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ecifm_contentitem_tag_map` AS m 

  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2868 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX KEY не используется	NULL	NULL	834	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bakas.t.id	4	Using index condition; Using where

Профиль

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	7.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:488
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
12	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
11	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:152
10	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.42 ms После последнего запроса: 1.17 ms Память запроса: 0.026 MB. Память перед запросом: 21.305 MB Возвращено строк: 17

SHOW FULL COLUMNS 
  FROM `ecifm_users`

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

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

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.36 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.22 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:524
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:262
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:181
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:42
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:329
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:611
16	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:885
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:256
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:309
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_news_show_sp2/helper.php:103
11	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:152
10	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.69 ms После последнего запроса: 0.87 ms Память запроса: 0.023 MB. Память перед запросом: 21.349 MB Возвращено строк: 1

SELECT *

  FROM `ecifm_users`

  WHERE `id` = 372

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_users	const	PRIMARY	PRIMARY	4	const	1

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:88
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:888
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:256
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:309
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_news_show_sp2/helper.php:103
11	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:152
10	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.90 ms После последнего запроса: 5.28 ms Память запроса: 0.023 MB. Память перед запросом: 21.946 MB Возвращено строк: 8

SELECT `g`.`id`,`g`.`title`

  FROM `ecifm_usergroups` AS g

  INNER JOIN `ecifm_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 372

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	8
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	bakas.m.group_id	1

Профиль

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:113
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:888
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:256
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:309
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_news_show_sp2/helper.php:103
11	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:152
10	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.34 ms После последнего запроса: 0.37 ms Память запроса: 0.026 MB. Память перед запросом: 21.956 MB Возвращено строк: 4

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 `ecifm_categories` AS `s`

  INNER JOIN `ecifm_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 = 261

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	56	Using index condition; Using where

Профиль

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.11 ms
Optimizing	0.07 ms
Statistics	0.19 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	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/modules/mod_news_show_sp2/helper.php:108
11	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:152
10	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.71 ms После последнего запроса: 41.16 ms Память запроса: 0.022 MB. Память перед запросом: 21.906 MB Возвращено строк: 0

Повторяющиеся запросы: #37

SELECT *

  FROM ecifm_banners

  WHERE '2026-11-02 09:00:38' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

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

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

Профиль

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.05 ms
Executing	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.11 ms После последнего запроса: 0.27 ms Память запроса: 0.023 MB. Память перед запросом: 21.916 MB Возвращено строк: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM ecifm_banners as a

  LEFT JOIN ecifm_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-02 09:00:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-02 09:00:38') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
  AND a.catid IN (18)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 5

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where; Используется сортировка файлов
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	bakas.a.cid	1

Профиль

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.07 ms
Statistics	0.12 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.14 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 39.26 ms После последнего запроса: 0.16 ms Память запроса: 0.005 MB. Память перед запросом: 21.927 MB

UPDATE ecifm_banners

  SET impmade = (impmade + 1)

  WHERE id IN (8)

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

EXPLAIN недоступен для: UPDATE ecifm_banners SET impmade = (impmade + 1) WHERE id IN (8)

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.02 ms
Updating main table	0.02 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.06 ms
Updating	0.12 ms
End of update loop	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	38.52 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:268
12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:199
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:104
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.75 ms После последнего запроса: 5.34 ms Память запроса: 0.021 MB. Память перед запросом: 21.978 MB Возвращено строк: 0

SELECT *
 
  FROM ecifm_jmap_metainfo
 
  WHERE `linkurl` = 'https://pskoviana.ru/istoriya/persony/142-85-let-n-f-levinu'
 
  AND `published` = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ecifm_jmap_metainfo	ref	published	published	1	const	1	Using where

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:429
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.63 ms После последнего запроса: 0.13 ms Память запроса: 0.021 MB. Память перед запросом: 21.984 MB Возвращено строк: 0

SELECT *
 
  FROM ecifm_jmap_canonicals
 
  WHERE `linkurl` = 'https://pskoviana.ru/istoriya/persony/142-85-let-n-f-levinu'

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

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

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:508
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:524
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:846
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:594
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1121
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.66 ms После последнего запроса: 8.74 ms Память запроса: 0.020 MB. Память перед запросом: 22.388 MB Возвращено строк: 0

SELECT *
 
  FROM ecifm_jmap_headings
 
  WHERE `linkurl` = 'https://pskoviana.ru/istoriya/persony/142-85-let-n-f-levinu'

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

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

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:824
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:1127
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:240
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

32 типов запросов зарегистрировано (отсортировано по вхождениям)

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

13 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ecifm_contentitem_tag_map` AS m  
  INNER JOIN `ecifm_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

3 × 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 ecifm_fields AS a 
  LEFT JOIN `ecifm_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ecifm_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ecifm_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ecifm_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `ecifm_extensions`

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 `ecifm_categories` AS `s` 
  INNER JOIN `ecifm_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ecifm_assets`

2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM ecifm_content AS a 
  LEFT JOIN ecifm_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ecifm_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ecifm_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ecifm_content_rating AS v 
  ON a.id = v.content_id

2 × 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 ecifm_fields AS a 
  LEFT JOIN `ecifm_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ecifm_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ecifm_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ecifm_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ecifm_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × SELECT id, title, module, position, content, showtitle, params 
  FROM ecifm_modules AS m

```
2 × SELECT * 
  FROM ecifm_banners
```

2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM ecifm_banners as a 
  LEFT JOIN ecifm_banner_clients AS cl 
  ON cl.id = a.cid

1 × SELECT `data` 
  FROM `ecifm_session`

1 × SELECT `session_id` 
  FROM `ecifm_session`

1 × SELECT id, rules 
  FROM `ecifm_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM ecifm_extensions

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM ecifm_menu AS m 
  LEFT JOIN ecifm_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, home, template, s.params 
  FROM ecifm_template_styles as s 
  LEFT JOIN ecifm_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT id,template 
  FROM ecifm_template_styles

1 × SELECT * 
  FROM `ecifm_jcomments_settings`

```
1 × SELECT * 
  FROM ecifm_languages
```

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

1 × SELECT COUNT(*) 
  FROM ecifm_content AS a 
  LEFT JOIN ecifm_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ecifm_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ecifm_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ecifm_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ecifm_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ecifm_modules AS m 
  LEFT JOIN ecifm_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ecifm_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM `ecifm_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `ecifm_usergroups` AS g 
  INNER JOIN `ecifm_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT *  
  FROM ecifm_jmap_metainfo

1 × SELECT *  
  FROM ecifm_jmap_canonicals

1 × SELECT *  
  FROM ecifm_jmap_headings

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

2 × UPDATE ecifm_banners 
  SET impmade = (impmade + 1)

1 × INSERT INTO `ecifm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3332393063653533393161333538643061633238346539363139363533623539', 1, 1793610038, 0, '', 0

1 × UPDATE `ecifm_extensions` 
  SET `params` = '{\"mediaversion\":\"9dfb2789cef14581f51b5b9a9f161cbb\"}'

1 × SHOW FULL COLUMNS 
  FROM `ecifm_users

Сего Дня

2 ноября 1468 года

2 ноября 1989 года

Контакты

Консоль отладки Joomla

Сессия

Профилирование

Время

Память

Использование памяти

Запросы к базе данных

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

2 повторяющихся запросов зарегистрировано

32 типов запросов зарегистрировано (отсортировано по вхождениям)

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

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