Подсказка для новичков - Доска объявлений. Москва.

Введите сначала свои данные в редактировании своего профиля здесь, тогда ваши телефоны, организация и другие данные будут автоматически вводится в ваших новых объявлениях.

При добавлении нового объявления Вы можете изменить размер шрифта , его цвет. Также можете изменить сам шрифт и другие его параметры. Ниже фото.

Кликабельный номер телефона в объявлениях.

Если Вы хотите только кликабельный номер телефона в своих объявлениях, то отредактируйте профиль согласно фото. Фото ниже.

Объявление без контактных данных.

Если Вы не хотите указывать контактные данные в своем объявлении, то в поле "контакты" или в поле Имя+телефон в своём профиле при редактировании укажите просто имя. Если и имя не хотите, то просто точку поставьте. В этом случае посетитель будет общаться с Вами через контактную форму в объявлении. При этом он должен зарегистрироваться на сайте. Все объявления не разрешенные законом будут удаляться. Они все проходят через модерацию, хотя и добавляются сразу на сайт.

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1763538312,
                "last": 1763538312,
                "now": 1763538312
            },
            "token": "Tvpym6XJoELG7qj99ixDmbAXDjypHoSa"
        },
        "registry": {
            "djclassifieds_items141": {
                "ajaxload": null
            },
            "com_slogin": {
                "return_url": "aHR0cHM6Ly9tb3Nrb2Rvcy5ydS9pbmRleC5waHAvcG9kc2themthLWRseWEtbm92aWNoa292"
            },
            "djclassifieds_items124": {
                "ajaxload": null
            },
            "djclassifieds_items148": {
                "ajaxload": null
            }
        },
        "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
        }
    }
}

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

Время

Память

Время: 7.14 ms / 7.14 ms Память: 0.409 MB / 0.75 MB Application: afterLoad

Время: 64.12 ms / 71.27 ms Память: 1.687 MB / 2.44 MB Application: afterInitialise

Время: 36.56 ms / 107.83 ms Память: 0.812 MB / 3.25 MB Application: afterRoute

Время: 6.92 ms / 114.75 ms Память: 0.028 MB / 3.28 MB Application: beforeRenderComponent com_content

Время: 2.94 ms / 117.70 ms Память: 0.049 MB / 3.33 MB Application: Before Access::preloadComponents (all components)

Время: 2.98 ms / 120.68 ms Память: 0.063 MB / 3.39 MB Application: After Access::preloadComponents (all components)

Время: 0.04 ms / 120.72 ms Память: -0.004 MB / 3.38 MB Application: Before Access::preloadPermissions (com_content)

Время: 2.60 ms / 123.33 ms Память: 0.517 MB / 3.90 MB Application: After Access::preloadPermissions (com_content)

Время: 0.05 ms / 123.38 ms Память: -0.034 MB / 3.87 MB Application: Before Access::getAssetRules (id:224 name:com_content.article.85)

Время: 0.39 ms / 123.77 ms Память: 0.008 MB / 3.88 MB Application: After Access::getAssetRules (id:224 name:com_content.article.85)

Время: 181.29 ms / 305.06 ms Память: 0.463 MB / 4.34 MB Application: afterRenderComponent com_content

Время: 0.87 ms / 305.94 ms Память: 0.007 MB / 4.35 MB Application: afterDispatch

Время: 6.58 ms / 312.52 ms Память: 0.058 MB / 4.40 MB Application: beforeRenderModule mod_breadcrumbs (Навигатор сайта)

Время: 1.93 ms / 314.45 ms Память: 0.050 MB / 4.45 MB Application: afterRenderModule mod_breadcrumbs (Навигатор сайта)

Время: 0.10 ms / 314.55 ms Память: 0.001 MB / 4.46 MB Application: beforeRenderModule mod_djclassifieds_items (Сток опт дет 4)

Время: 31.91 ms / 346.46 ms Память: 0.342 MB / 4.80 MB Application: afterRenderModule mod_djclassifieds_items (Сток опт дет 4)

Время: 0.06 ms / 346.52 ms Память: -0.025 MB / 4.77 MB Application: beforeRenderModule mod_djclassifieds_menu (Добавить объявление Самый верх)

Время: 3.14 ms / 349.66 ms Память: 0.159 MB / 4.93 MB Application: afterRenderModule mod_djclassifieds_menu (Добавить объявление Самый верх)

Время: 0.04 ms / 349.69 ms Память: -0.037 MB / 4.90 MB Application: beforeRenderModule mod_slogin (SLogin)

Время: 2.09 ms / 351.78 ms Память: 0.039 MB / 4.93 MB Application: afterRenderModule mod_slogin (SLogin)

Время: 0.03 ms / 351.81 ms Память: -0.000 MB / 4.93 MB Application: beforeRenderModule mod_menu (Личный кабинет Меню)

Время: 2.20 ms / 354.01 ms Память: 0.045 MB / 4.98 MB Application: afterRenderModule mod_menu (Личный кабинет Меню)

Время: 0.04 ms / 354.05 ms Память: -0.000 MB / 4.98 MB Application: beforeRenderModule mod_djclassifieds_items (Сток оптом)

Время: 32.23 ms / 386.29 ms Память: 0.089 MB / 5.07 MB Application: afterRenderModule mod_djclassifieds_items (Сток оптом)

Время: 0.10 ms / 386.38 ms Память: -0.044 MB / 5.02 MB Application: beforeRenderModule mod_djclassifieds_items (Зарегистрированных объявления)

Время: 72.46 ms / 458.84 ms Память: 0.293 MB / 5.32 MB Application: afterRenderModule mod_djclassifieds_items (Зарегистрированных объявления)

Время: 0.09 ms / 458.94 ms Память: -0.184 MB / 5.13 MB Application: beforeRenderModule mod_djclassifieds_menu (Добавить объявление Самый низ)

Время: 0.55 ms / 459.49 ms Память: 0.040 MB / 5.17 MB Application: afterRenderModule mod_djclassifieds_menu (Добавить объявление Самый низ)

Время: 0.04 ms / 459.53 ms Память: -0.037 MB / 5.14 MB Application: beforeRenderModule mod_menu (Контакты)

Время: 0.62 ms / 460.15 ms Память: 0.012 MB / 5.15 MB Application: afterRenderModule mod_menu (Контакты)

Время: 19.51 ms / 479.66 ms Память: 0.198 MB / 5.34 MB Application: afterRender

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

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

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

69 запросов зарегистрировано 343.24 ms

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

2 повторяющихся запросов: #30 #67

2 повторяющихся запросов: #43 #47

2 повторяющихся запросов: #49 #51

2 повторяющихся запросов: #56 #58

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

SELECT `data`

  FROM `joomla_session`

  WHERE `session_id` = X'6636333632646235326562353231396339643866626137346661663933626531'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Такой же, как вызов в строке ниже
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

SELECT `session_id`

  FROM `joomla_session`

  WHERE `session_id` = X'6636333632646235326562353231396339643866626137346661663933626531' 
  LIMIT 1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.32 ms После последнего запроса: 0.15 ms Память запроса: 0.004 MB. Память перед запросом: 1.048 MB

INSERT INTO `joomla_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6636333632646235326562353231396339643866626137346661663933626531', 1, 1763538312, 0, '', 0)

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 2.07 ms После последнего запроса: 1.07 ms Память запроса: 0.064 MB. Память перед запросом: 1.079 MB Возвращено строк: 47

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

  FROM `joomla_extensions`

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla_extensions	NULL	ref	extension	extension	82	const	47	1.00	Using where

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	1.39 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.39 ms
end	0.00 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 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::Joomla\CMS\Component\{closure}()	Такой же, как вызов в строке ниже
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.21 ms После последнего запроса: 1.59 ms Память запроса: 0.021 MB. Память перед запросом: 1.146 MB Возвращено строк: 5

SELECT id, rules

  FROM `joomla_viewlevels`

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

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

Профиль

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

Стек вызовов

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

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

Время запроса: 1.20 ms После последнего запроса: 0.15 ms Память запроса: 0.021 MB. Память перед запросом: 1.158 MB Возвращено строк: 2

SELECT b.id

  FROM joomla_usergroups AS a

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

  WHERE a.id = 9

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

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

Профиль

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

Стек вызовов

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

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

Время запроса: 1.39 ms После последнего запроса: 0.34 ms Память запроса: 0.051 MB. Память перед запросом: 1.179 MB Возвращено строк: 158

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

  FROM joomla_extensions

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

  ORDER BY ordering

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

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

Профиль

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

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

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

SELECT `path`

  FROM joomla_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `file`

  FROM joomla_rsfirewall_hashes

  WHERE `type`='protect'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.78 ms После последнего запроса: 0.06 ms Память запроса: 0.026 MB. Память перед запросом: 1.552 MB Возвращено строк: 66

SELECT *

  FROM joomla_rsfirewall_configuration

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.37 ms После последнего запроса: 3.29 ms Память запроса: 0.024 MB. Память перед запросом: 1.855 MB Возвращено строк: 10

SHOW FULL COLUMNS 
  FROM `joomla_rsfirewall_logs`

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:77
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 4.06 ms После последнего запроса: 19.52 ms Память запроса: 0.048 MB. Память перед запросом: 2.467 MB Возвращено строк: 20

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 joomla_menu AS m

  LEFT JOIN joomla_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	30	10.00	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dandam_jm3.m.component_id	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Такой же, как вызов в строке ниже
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM joomla_rsfirewall_hashes

  WHERE (`type`='3.10.12' OR `type`='protect') 
  AND `flag`!='C'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1049
9	plgSystemRsfirewall->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM joomla_rsfirewall_snapshots

  WHERE `type`='protect'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1072
9	plgSystemRsfirewall->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `ip`,`reason`

  FROM joomla_rsfirewall_lists

  WHERE (`ip`='18.97.9.172' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
10	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1108
9	plgSystemRsfirewall->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `ip`,`reason`

  FROM joomla_rsfirewall_lists

  WHERE (`ip`='18.97.9.172' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
10	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1112
9	plgSystemRsfirewall->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM joomla_rsfirewall_exceptions

  WHERE `published`='1'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:700
10	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1243
9	plgSystemRsfirewall->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `joomla_extensions`

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
20	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Такой же, как вызов в строке ниже
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
17	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
16	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
15	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/nrframework/NRFramework/Functions.php:318
11	NRFramework\Functions::isFeed()	JROOT/plugins/system/convertforms/convertforms.php:439
10	PlgSystemConvertForms->getHelper()	JROOT/plugins/system/convertforms/convertforms.php:98
9	PlgSystemConvertForms->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.43 ms После последнего запроса: 0.18 ms Память запроса: 0.008 MB. Память перед запросом: 2.733 MB

UPDATE `joomla_extensions`

  SET `params` = '{\"mediaversion\":\"62a3226dc94d255d7952061fe74bf56b\"}'

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

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

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

Профиль

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

Стек вызовов

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

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

Время запроса: 2.07 ms После последнего запроса: 4.20 ms Память запроса: 0.026 MB. Память перед запросом: 3.104 MB Возвращено строк: 2

SELECT id, home, template, s.params

  FROM joomla_template_styles as s

  LEFT JOIN joomla_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
21	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
20	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
19	Joomla\CMS\HTML\HTMLHelper::script()	Такой же, как вызов в строке ниже
18	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
17	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
16	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
15	JHtmlJquery::framework()	Такой же, как вызов в строке ниже
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:119
11	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
10	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
9	plgSystemJRealtimeAnalytics->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SHOW FULL COLUMNS 
  FROM `joomla_session`

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jrealtimeanalytics/tables/session.php:163
15	JRealtimeTableSession->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:135
13	JRealtimeHelpersUsers::getSessionTable()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48
12	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
11	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
10	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
9	plgSystemJRealtimeAnalytics->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM joomla_session

  WHERE `session_id` = 'f6362db52eb5219c9d8fba74faf93be1'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:136
13	JRealtimeHelpersUsers::getSessionTable()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48
12	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
11	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
10	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
9	plgSystemJRealtimeAnalytics->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `joomla_realtimeanalytics_eventstats`
 
  WHERE `type` = 'viewurl'
 
  AND `published` = 1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388
16	JRealtimeModelEventstatsObsrv::loadEventsFromDB()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:181
15	JRealtimeModelEventstatsObsrv->trackEventVisitPage()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:413
14	JRealtimeModelEventstatsObsrv->update()	JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97
13	JRealtimeModelObservable->notify()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78
12	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
11	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
10	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
9	plgSystemJRealtimeAnalytics->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `joomla_realtimeanalytics_eventstats`
 
  WHERE `type` = 'minpages'
 
  AND `published` = 1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388
16	JRealtimeModelEventstatsObsrv::loadEventsFromDB()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:231
15	JRealtimeModelEventstatsObsrv->trackEventMinPageVisited()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:416
14	JRealtimeModelEventstatsObsrv->update()	JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97
13	JRealtimeModelObservable->notify()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78
12	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
11	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:601
10	plgSystemJRealtimeAnalytics->startApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:628
9	plgSystemJRealtimeAnalytics->onAfterRoute()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM joomla_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.55 ms После последнего запроса: 5.04 ms Память запроса: 0.028 MB. Память перед запросом: 3.330 MB Возвращено строк: 47

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

  FROM `joomla_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_altauserpoints','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_djclassifieds','com_djmediatools','com_fields','com_finder','com_gsd','com_installer','com_jmap','com_joomlaupdate','com_jrealtimeanalytics','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsfirewall','com_search','com_slogin','com_tagmeta','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

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

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

Профиль

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

Стек вызовов

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

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

Время запроса: 1.44 ms После последнего запроса: 0.31 ms Память запроса: 0.091 MB. Память перед запросом: 3.385 MB Возвращено строк: 582

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

  FROM `joomla_assets`

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

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

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

Профиль

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

Стек вызовов

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

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

Время запроса: 4.34 ms После последнего запроса: 1.96 ms Память запроса: 0.031 MB. Память перед запросом: 3.882 MB Возвращено строк: 31

SHOW FULL COLUMNS 
  FROM `joomla_content`

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.94 ms После последнего запроса: 1.34 ms Память запроса: 0.005 MB. Память перед запросом: 3.938 MB

UPDATE joomla_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '85'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM joomla_content AS a

  INNER JOIN joomla_categories AS c 
  on c.id = a.catid

  LEFT JOIN joomla_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 85 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-11-19 07:45:12') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-19 07:45:12') 
  AND (a.state = 1 OR a.state =2)

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `joomla_contentitem_tag_map` AS m 

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

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	INDEX KEY не используется	NULL	NULL	19	5.26	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dandam_jm3.m.tag_id	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.99 ms После последнего запроса: 5.10 ms Память запроса: 0.027 MB. Память перед запросом: 4.141 MB Возвращено строк: 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 `joomla_categories` AS `s`

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 11

  ORDER BY c.lft

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:193
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 5.30 ms После последнего запроса: 0.41 ms Память запроса: 0.026 MB. Память перед запросом: 4.231 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 joomla_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:193
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM joomla_content AS a

  LEFT JOIN joomla_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 11 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-11-19 07:45:12') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-11-19 07:45:12')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
14	PlgContentPagenavigation->onContentBeforeDisplay()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:199
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT referreid 
  FROM joomla_alpha_userpoints
		 
  WHERE `userid`='255'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_altauserpoints/helper.php:1010
16	AltaUserPointsHelper::getAnyUserReferreID()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:81
15	plgContentSysplgaup_reader2author->reader2author()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:65
14	plgContentSysplgaup_reader2author->onContentAfterDisplay()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:202
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT referreid 
  FROM joomla_alpha_userpoints 
		
  WHERE `referreid`='Админ' 
  AND `published`='1'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla_alpha_userpoints	NULL	ref	referreid	referreid	482	const	1	10.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_altauserpoints/helper.php:900
16	AltaUserPointsHelper::checkExcludeUsers()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:82
15	plgContentSysplgaup_reader2author->reader2author()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:65
14	plgContentSysplgaup_reader2author->onContentAfterDisplay()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:202
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `method` 
  FROM joomla_alpha_userpoints_rules 
  WHERE `plugin_function`='sysplgaup_reader2author' 
  AND `published`='1'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_altauserpoints/helper.php:842
17	AltaUserPointsHelper::getMethod()	JROOT/components/com_altauserpoints/helper.php:850
16	AltaUserPointsHelper::buildKeyreference()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:88
15	plgContentSysplgaup_reader2author->reader2author()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:65
14	plgContentSysplgaup_reader2author->onContentAfterDisplay()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:202
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `id` 
  FROM joomla_alpha_userpoints_details 
  WHERE `keyreference`='85|18.97.9.172|691d7588c417c' 
  AND enabled='1'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:93
15	plgContentSysplgaup_reader2author->reader2author()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:65
14	plgContentSysplgaup_reader2author->onContentAfterDisplay()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:202
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM joomla_alpha_userpoints_rules 
  WHERE `plugin_function`='sysplgaup_reader2author' 
  AND `published`='1' 
  AND `access` IN (1,1,5) 
  AND (`rule_expire`>'2025-11-19 07:45:12' OR `rule_expire`='0000-00-00 00:00:00')

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:103
15	plgContentSysplgaup_reader2author->reader2author()	JROOT/plugins/content/sysplgaup_reader2author/sysplgaup_reader2author.php:65
14	plgContentSysplgaup_reader2author->onContentAfterDisplay()	Такой же, как вызов в строке ниже
13	call_user_func_array()	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/article/view.html.php:202
10	ContentViewArticle->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.98 ms После последнего запроса: 4.28 ms Память запроса: 0.025 MB. Память перед запросом: 4.394 MB Возвращено строк: 14

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

  FROM joomla_modules AS m

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

  LEFT JOIN joomla_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 <= '2025-11-19 07:45:12') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-11-19 07:45:12') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 313 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:91
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 12.82 ms После последнего запроса: 9.22 ms Память запроса: 0.038 MB. Память перед запросом: 4.629 MB Возвращено строк: 1

SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:12'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.id IN (4441) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0 
  ORDER BY i.name 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	const	PRIMARY,cat_id,published,blocked,date_exp	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	r	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	NULL
2	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:397
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.44 ms После последнего запроса: 0.13 ms Память запроса: 0.022 MB. Память перед запросом: 4.639 MB Возвращено строк: 1

SELECT img.* 
  FROM joomla_djcf_images img 
  WHERE img.item_id IN (4441) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:435
12	DJClassifiedsImage::getAdsImages()	JROOT/modules/mod_djclassifieds_items/helper.php:425
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.82 ms После последнего запроса: 0.31 ms Память запроса: 0.048 MB. Память перед запросом: 4.662 MB Возвращено строк: 20

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

SELECT * 
  FROM joomla_djcf_categories 
  WHERE published=1 
  AND access_view IN (1,1,5) 
  ORDER BY parent_id, ordering ASC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:549
15	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:563
14	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:316
13	DJClassifiedsCategory::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:76
12	DJClassifiedsSEO::getItemRoute()	JROOT/modules/mod_djclassifieds_items/tmpl/default.php:95
11	require JROOT/modules/mod_djclassifieds_items/tmpl/default.php	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:81
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.98 ms После последнего запроса: 0.17 ms Память запроса: 0.025 MB. Память перед запросом: 4.719 MB Возвращено строк: 13

SELECT cat_id, count(*) as items_count 
  FROM (SELECT i.cat_id 
  FROM joomla_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2025-11-19 10:00:00' ) v 
  GROUP BY cat_id

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ref	cat_id,published,blocked,date_exp	published	4	const	479	100.00	Using where; Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:520
15	DJClassifiedsCategory::setItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:564
14	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:316
13	DJClassifiedsCategory::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:76
12	DJClassifiedsSEO::getItemRoute()	JROOT/modules/mod_djclassifieds_items/tmpl/default.php:95
11	require JROOT/modules/mod_djclassifieds_items/tmpl/default.php	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:81
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT r.* 
  FROM joomla_djcf_regions r 
  ORDER BY r.parent_id, name ASC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:480
15	DJClassifiedsRegion::getAllRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:519
14	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:346
13	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
12	DJClassifiedsSEO::getItemRoute()	JROOT/modules/mod_djclassifieds_items/tmpl/default.php:95
11	require JROOT/modules/mod_djclassifieds_items/tmpl/default.php	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:81
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.64 ms После последнего запроса: 0.06 ms Память запроса: 0.024 MB. Память перед запросом: 4.745 MB Возвращено строк: 2

SELECT i.region_id, count(i.id) as items_count 
  FROM joomla_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2025-11-19 10:00:00' 
  GROUP BY i.region_id

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ref	region_id,published,blocked,date_exp	published	4	const	479	100.00	Using where; Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:448
15	DJClassifiedsRegion::setItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:520
14	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:346
13	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
12	DJClassifiedsSEO::getItemRoute()	JROOT/modules/mod_djclassifieds_items/tmpl/default.php:95
11	require JROOT/modules/mod_djclassifieds_items/tmpl/default.php	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:81
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.86 ms После последнего запроса: 3.95 ms Память запроса: 0.046 MB. Память перед запросом: 4.799 MB Возвращено строк: 20

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

SELECT * 
  FROM joomla_djcf_categories 
  WHERE published=1 
  AND access_view IN (1,1,5) 
  ORDER BY parent_id, ordering ASC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:549
13	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:588
12	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:336
11	DJClassifiedsCategory::getMenuCategories()	JROOT/modules/mod_djclassifieds_menu/mod_djclassifieds_menu.php:58
10	include JROOT/modules/mod_djclassifieds_menu/mod_djclassifieds_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.62 ms После последнего запроса: 0.20 ms Память запроса: 0.050 MB. Память перед запросом: 4.891 MB Возвращено строк: 21

SELECT * 
  FROM joomla_djcf_categories 
  ORDER BY parent_id, ordering ASC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:549
13	DJClassifiedsCategory::getAllCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:563
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276
11	DJClassifiedsCategory::getParentPath()	JROOT/modules/mod_djclassifieds_menu/mod_djclassifieds_menu.php:67
10	include JROOT/modules/mod_djclassifieds_menu/mod_djclassifieds_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id JOIN (SELECT CEIL(RAND() * (SELECT MAX(id) 
  FROM joomla_djcf_items)) AS num, @num:=@num+1 
  FROM (SELECT @num:=0) AS a, joomla_djcf_items 
  LIMIT 1) AS tmp 
  ON tmp.num = i.id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:12'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (1739) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
3	DERIVED	<derived5>	NULL	system	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	NULL
3	DERIVED	joomla_djcf_items	NULL	index	NULL	cat_id	4	NULL	382	100.00	Using index
5	DERIVED	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	No tables used
4	SUBQUERY	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Select tables optimized away
2	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:397
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 12.33 ms После последнего запроса: 0.07 ms Память запроса: 0.022 MB. Память перед запросом: 5.015 MB Возвращено строк: 1

SELECT count(*) 
  FROM (SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:12'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (1739) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0 ) v

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,published	INDEX KEY не используется	NULL	NULL	21	4.76	Using where
1	PRIMARY	i	NULL	ref	PRIMARY,cat_id,user_id,published,blocked,date_exp	cat_id	4	dandam_jm3.c.id	29	13.09	Using where
1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	dandam_jm3.i.id	10	100.00	NULL
1	PRIMARY	r	NULL	eq_ref	PRIMARY	PRIMARY	4	dandam_jm3.i.region_id	1	100.00	Using index
3	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.06 ms
statistics	0.21 ms
preparing	0.06 ms
executing	11.24 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.06 ms
closing tables	0.06 ms
freeing items	0.09 ms
cleaning up	0.05 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_djclassifieds_items/helper.php:402
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id JOIN (SELECT CEIL(RAND() * (SELECT MAX(id) 
  FROM joomla_djcf_items)) AS num, @num:=@num+1 
  FROM (SELECT @num:=0) AS a, joomla_djcf_items 
  LIMIT 1) AS tmp 
  ON tmp.num = i.id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:12'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (1739) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
3	DERIVED	<derived5>	NULL	system	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	NULL
3	DERIVED	joomla_djcf_items	NULL	index	NULL	cat_id	4	NULL	382	100.00	Using index
5	DERIVED	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	No tables used
4	SUBQUERY	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Select tables optimized away
2	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:405
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 13.27 ms После последнего запроса: 0.10 ms Память запроса: 0.038 MB. Память перед запросом: 5.028 MB Возвращено строк: 1

SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:12'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (1739) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0 
  ORDER BY rand() 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,published	INDEX KEY не используется	NULL	NULL	21	4.76	Using where; Using temporary; Используется сортировка файлов
1	PRIMARY	i	NULL	ref	PRIMARY,cat_id,user_id,published,blocked,date_exp	cat_id	4	dandam_jm3.c.id	29	13.09	Using where
1	PRIMARY	r	NULL	ALL	PRIMARY	INDEX KEY не используется	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	dandam_jm3.i.id	10	100.00	NULL
2	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:412
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.42 ms После последнего запроса: 0.17 ms Память запроса: 0.022 MB. Память перед запросом: 5.039 MB Возвращено строк: 1

SELECT img.* 
  FROM joomla_djcf_images img 
  WHERE img.item_id IN (4882) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:435
12	DJClassifiedsImage::getAdsImages()	JROOT/modules/mod_djclassifieds_items/helper.php:425
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.45 ms После последнего запроса: 0.12 ms Память запроса: 0.026 MB. Память перед запросом: 5.052 MB Возвращено строк: 22

SELECT * 
  FROM joomla_djcf_images 
  WHERE type='category'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joomla_djcf_images	NULL	ref	type	type	167	const	22	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:603
11	DJClassifiedsImage::getCatImages()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:69
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.15 ms После последнего запроса: 2.79 ms Память запроса: 0.061 MB. Память перед запросом: 5.054 MB Возвращено строк: 1109

SELECT DISTINCT(user_id)

  FROM joomla_usergroups as ug1

  INNER JOIN joomla_usergroups AS ug2 
  ON ug2.lft=ug1.lft 
  AND ug1.rgt=ug2.rgt

  INNER JOIN joomla_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id='2'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	ref	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	const,const	1	100.00	Using index
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	1089	10.00	Using where; Using index; Using join buffer (hash join)

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:1029
12	Joomla\CMS\Access\Access::getUsersByGroup()	JROOT/modules/mod_djclassifieds_items/helper.php:104
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id JOIN (SELECT CEIL(RAND() * (SELECT MAX(id) 
  FROM joomla_djcf_items)) AS num, @num:=@num+1 
  FROM (SELECT @num:=0) AS a, joomla_djcf_items 
  LIMIT 7) AS tmp 
  ON tmp.num = i.id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:13'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (262, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 372, 373, 375, 376, 377, 378, 380, 381, 383, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 396, 397, 398, 400, 401, 402, 403, 405, 406, 407, 408, 409, 410, 411, 413, 414, 415, 416, 419, 420, 421, 423, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 435, 436, 437, 438, 439, 441, 442, 443, 444, 445, 446, 447, 448, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 461, 462, 463, 464, 465, 466, 467, 469, 471, 472, 473, 474, 475, 476, 477, 478, 479, 483, 484, 485, 486, 487, 488, 490, 492, 493, 494, 495, 496, 497, 498, 499, 501, 502, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 515, 516, 517, 518, 519, 520, 521, 522, 524, 525, 526, 528, 531, 535, 536, 537, 538, 546, 551, 557, 561, 563, 564, 565, 566, 567, 569, 570, 571, 573, 575, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 593, 594, 595, 597, 598, 599, 600, 603, 604, 606, 607, 608, 611, 613, 614, 615, 616, 617, 618, 619, 620, 627, 628, 629, 630, 631, 633, 634, 635, 637, 638, 639, 640, 643, 645, 646, 647, 649, 651, 652, 653, 655, 656, 663, 665, 666, 667, 668, 671, 672, 675, 676, 677, 678, 679, 681, 683, 685, 686, 687, 688, 690, 691, 692, 693, 694, 695, 696, 697, 699, 700, 701, 702, 703, 704, 705, 706, 707, 709, 710, 711, 712, 713, 717, 718, 719, 721, 722, 724, 725, 726, 727, 728, 729, 730, 732, 733, 734, 735, 736, 737, 738, 739, 740, 743, 744, 749, 750, 751, 752, 753, 754, 755, 756, 758, 759, 760, 762, 763, 764, 765, 766, 767, 768, 769, 771, 773, 774, 776, 777, 778, 779, 780, 784, 785, 786, 789, 791, 793, 795, 796, 797, 798, 799, 800, 801, 804, 805, 807, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 820, 821, 822, 823, 825, 826, 829, 830, 831, 832, 833, 834, 835, 837, 840, 841, 842, 843, 845, 847, 848, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 861, 862, 864, 865, 866, 867, 868, 869, 870, 872, 873, 874, 875, 876, 879, 883, 886, 888, 890, 892, 895, 898, 900, 901, 903, 907, 912, 913, 914, 917, 919, 920, 921, 922, 923, 926, 928, 929, 930, 932, 933, 935, 936, 939, 940, 942, 943, 944, 946, 947, 949, 952, 953, 957, 959, 960, 962, 969, 970, 976, 977, 978, 981, 985, 987, 988, 991, 995, 996, 998, 999, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1017, 1019, 1020, 1021, 1022, 1023, 1024, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1041, 1043, 1044, 1045, 1046, 1048, 1049, 1050, 1051, 1053, 1055, 1056, 1057, 1058, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1069, 1070, 1073, 1075, 1077, 1081, 1083, 1084, 1088, 1089, 1091, 1092, 1093, 1094, 1096, 1097, 1098, 1099, 1102, 1103, 1105, 1107, 1108, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1121, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1131, 1132, 1133, 1134, 1137, 1139, 1140, 1141, 1142, 1143, 1144, 1146, 1147, 1149, 1150, 1152, 1154, 1156, 1158, 1159, 1161, 1162, 1163, 1165, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1182, 1184, 1185, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1198, 1200, 1202, 1204, 1205, 1206, 1207, 1209, 1210, 1211, 1212, 1213, 1215, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1241, 1243, 1249, 1250, 1251, 1257, 1262, 1264, 1265, 1268, 1269, 1270, 1271, 1275, 1280, 1281, 1282, 1285, 1294, 1295, 1298, 1299, 1300, 1302, 1303, 1304, 1306, 1307, 1310, 1311, 1314, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1332, 1333, 1334, 1335, 1336, 1337, 1339, 1340, 1341, 1342, 1345, 1346, 1348, 1349, 1350, 1351, 1353, 1354, 1355, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1421, 1422, 1424, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1439, 1440, 1441, 1442, 1443, 1445, 1446, 1447, 1448, 1449, 1450, 1452, 1453, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1469, 1470, 1471, 1472, 1473, 1474, 1476, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1489, 1490, 1491, 1492, 1493, 1494, 1496, 1497, 1498, 1499, 1500, 1502, 1503, 1507, 1508, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1521, 1523, 1524, 1525, 1526, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1538, 1539, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1551, 1552, 1553, 1554, 1555, 1557, 1558, 1559, 1560, 1561, 1562, 1564, 1565, 1567, 1568, 1569, 1570, 1571, 1573, 1574, 1575, 1576, 1578, 1580, 1581, 1582, 1584, 1585, 1586, 1587, 1588, 1591, 1594, 1596, 1597, 1598, 1599, 1601, 1602, 1604, 1605, 1609, 1612, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1622, 1623, 1626, 1627, 1628, 1630, 1632, 1634, 1636, 1639, 1642, 1644, 1645, 1647, 1652, 1657, 1658, 1661, 1665, 1666, 1667, 1668, 1669, 1670, 1671, 1673, 1676, 1680, 1686, 1691, 1697, 1701, 1702, 1703, 1708, 1710, 1711, 1712, 1714, 1715, 1716, 1720, 1721, 1722, 1724, 1725, 1727, 1728, 1732, 1735, 1737, 1738, 1739, 1743, 1744, 1745, 1746, 1748, 1749, 1751, 1752, 1753, 1754, 1757, 1765, 1767, 1776, 1778, 1779, 1780, 1787, 1788, 1789, 1790, 1792, 1795, 1798, 1801, 1818, 1889, 1891, 1938, 1974, 1976, 1978, 1983, 1986, 1998, 2001, 2088, 2129, 2137, 2139, 2143, 2147, 2150, 2157, 2166, 2175, 2207, 2209, 2218, 2229, 2241, 2243, 2244, 2264, 2265, 2276, 2371, 2433, 2491, 2502, 2667, 2718, 2719, 2777, 2779, 2785, 2786, 2814, 2841, 2874, 2916, 2943, 2946, 2948, 2949, 2950, 2956, 2958, 2968, 2971, 2975, 2977, 2979, 2980, 2982, 2984, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 2993, 2995, 2996, 2997, 2998, 2999, 3000, 3001, 3002, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived3>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	7	100.00	Using where
1	PRIMARY	i	NULL	eq_ref	PRIMARY,cat_id,user_id,published,blocked,date_exp	PRIMARY	4	tmp.num	1	100.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,published	PRIMARY	4	dandam_jm3.i.cat_id	1	5.00	Using where
1	PRIMARY	r	NULL	eq_ref	PRIMARY	PRIMARY	4	dandam_jm3.i.region_id	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key1>	<auto_key1>	4	tmp.num	19	33.33	Using where
3	DERIVED	<derived5>	NULL	system	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	NULL
3	DERIVED	joomla_djcf_items	NULL	index	NULL	cat_id	4	NULL	382	100.00	Using index
5	DERIVED	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	No tables used
4	SUBQUERY	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Select tables optimized away
2	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:397
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 18.58 ms После последнего запроса: 0.18 ms Память запроса: 0.022 MB. Память перед запросом: 5.185 MB Возвращено строк: 1

SELECT count(*) 
  FROM (SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:13'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (262, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 372, 373, 375, 376, 377, 378, 380, 381, 383, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 396, 397, 398, 400, 401, 402, 403, 405, 406, 407, 408, 409, 410, 411, 413, 414, 415, 416, 419, 420, 421, 423, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 435, 436, 437, 438, 439, 441, 442, 443, 444, 445, 446, 447, 448, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 461, 462, 463, 464, 465, 466, 467, 469, 471, 472, 473, 474, 475, 476, 477, 478, 479, 483, 484, 485, 486, 487, 488, 490, 492, 493, 494, 495, 496, 497, 498, 499, 501, 502, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 515, 516, 517, 518, 519, 520, 521, 522, 524, 525, 526, 528, 531, 535, 536, 537, 538, 546, 551, 557, 561, 563, 564, 565, 566, 567, 569, 570, 571, 573, 575, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 593, 594, 595, 597, 598, 599, 600, 603, 604, 606, 607, 608, 611, 613, 614, 615, 616, 617, 618, 619, 620, 627, 628, 629, 630, 631, 633, 634, 635, 637, 638, 639, 640, 643, 645, 646, 647, 649, 651, 652, 653, 655, 656, 663, 665, 666, 667, 668, 671, 672, 675, 676, 677, 678, 679, 681, 683, 685, 686, 687, 688, 690, 691, 692, 693, 694, 695, 696, 697, 699, 700, 701, 702, 703, 704, 705, 706, 707, 709, 710, 711, 712, 713, 717, 718, 719, 721, 722, 724, 725, 726, 727, 728, 729, 730, 732, 733, 734, 735, 736, 737, 738, 739, 740, 743, 744, 749, 750, 751, 752, 753, 754, 755, 756, 758, 759, 760, 762, 763, 764, 765, 766, 767, 768, 769, 771, 773, 774, 776, 777, 778, 779, 780, 784, 785, 786, 789, 791, 793, 795, 796, 797, 798, 799, 800, 801, 804, 805, 807, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 820, 821, 822, 823, 825, 826, 829, 830, 831, 832, 833, 834, 835, 837, 840, 841, 842, 843, 845, 847, 848, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 861, 862, 864, 865, 866, 867, 868, 869, 870, 872, 873, 874, 875, 876, 879, 883, 886, 888, 890, 892, 895, 898, 900, 901, 903, 907, 912, 913, 914, 917, 919, 920, 921, 922, 923, 926, 928, 929, 930, 932, 933, 935, 936, 939, 940, 942, 943, 944, 946, 947, 949, 952, 953, 957, 959, 960, 962, 969, 970, 976, 977, 978, 981, 985, 987, 988, 991, 995, 996, 998, 999, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1017, 1019, 1020, 1021, 1022, 1023, 1024, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1041, 1043, 1044, 1045, 1046, 1048, 1049, 1050, 1051, 1053, 1055, 1056, 1057, 1058, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1069, 1070, 1073, 1075, 1077, 1081, 1083, 1084, 1088, 1089, 1091, 1092, 1093, 1094, 1096, 1097, 1098, 1099, 1102, 1103, 1105, 1107, 1108, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1121, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1131, 1132, 1133, 1134, 1137, 1139, 1140, 1141, 1142, 1143, 1144, 1146, 1147, 1149, 1150, 1152, 1154, 1156, 1158, 1159, 1161, 1162, 1163, 1165, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1182, 1184, 1185, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1198, 1200, 1202, 1204, 1205, 1206, 1207, 1209, 1210, 1211, 1212, 1213, 1215, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1241, 1243, 1249, 1250, 1251, 1257, 1262, 1264, 1265, 1268, 1269, 1270, 1271, 1275, 1280, 1281, 1282, 1285, 1294, 1295, 1298, 1299, 1300, 1302, 1303, 1304, 1306, 1307, 1310, 1311, 1314, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1332, 1333, 1334, 1335, 1336, 1337, 1339, 1340, 1341, 1342, 1345, 1346, 1348, 1349, 1350, 1351, 1353, 1354, 1355, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1421, 1422, 1424, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1439, 1440, 1441, 1442, 1443, 1445, 1446, 1447, 1448, 1449, 1450, 1452, 1453, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1469, 1470, 1471, 1472, 1473, 1474, 1476, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1489, 1490, 1491, 1492, 1493, 1494, 1496, 1497, 1498, 1499, 1500, 1502, 1503, 1507, 1508, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1521, 1523, 1524, 1525, 1526, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1538, 1539, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1551, 1552, 1553, 1554, 1555, 1557, 1558, 1559, 1560, 1561, 1562, 1564, 1565, 1567, 1568, 1569, 1570, 1571, 1573, 1574, 1575, 1576, 1578, 1580, 1581, 1582, 1584, 1585, 1586, 1587, 1588, 1591, 1594, 1596, 1597, 1598, 1599, 1601, 1602, 1604, 1605, 1609, 1612, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1622, 1623, 1626, 1627, 1628, 1630, 1632, 1634, 1636, 1639, 1642, 1644, 1645, 1647, 1652, 1657, 1658, 1661, 1665, 1666, 1667, 1668, 1669, 1670, 1671, 1673, 1676, 1680, 1686, 1691, 1697, 1701, 1702, 1703, 1708, 1710, 1711, 1712, 1714, 1715, 1716, 1720, 1721, 1722, 1724, 1725, 1727, 1728, 1732, 1735, 1737, 1738, 1739, 1743, 1744, 1745, 1746, 1748, 1749, 1751, 1752, 1753, 1754, 1757, 1765, 1767, 1776, 1778, 1779, 1780, 1787, 1788, 1789, 1790, 1792, 1795, 1798, 1801, 1818, 1889, 1891, 1938, 1974, 1976, 1978, 1983, 1986, 1998, 2001, 2088, 2129, 2137, 2139, 2143, 2147, 2150, 2157, 2166, 2175, 2207, 2209, 2218, 2229, 2241, 2243, 2244, 2264, 2265, 2276, 2371, 2433, 2491, 2502, 2667, 2718, 2719, 2777, 2779, 2785, 2786, 2814, 2841, 2874, 2916, 2943, 2946, 2948, 2949, 2950, 2956, 2958, 2968, 2971, 2975, 2977, 2979, 2980, 2982, 2984, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 2993, 2995, 2996, 2997, 2998, 2999, 3000, 3001, 3002, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0 ) v

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,published	INDEX KEY не используется	NULL	NULL	21	4.76	Using where
1	PRIMARY	i	NULL	ref	PRIMARY,cat_id,user_id,published,blocked,date_exp	cat_id	4	dandam_jm3.c.id	29	100.00	Using where
1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	dandam_jm3.i.id	10	100.00	NULL
1	PRIMARY	r	NULL	eq_ref	PRIMARY	PRIMARY	4	dandam_jm3.i.region_id	1	100.00	Using index
3	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

Status	Duration
starting	0.74 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.44 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
Creating tmp table	0.33 ms
statistics	1.65 ms
preparing	0.26 ms
executing	14.64 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.05 ms
closing tables	0.07 ms
freeing items	0.16 ms
cleaning up	0.05 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_djclassifieds_items/helper.php:402
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 10.19 ms После последнего запроса: 0.27 ms Память запроса: 0.039 MB. Память перед запросом: 5.191 MB Возвращено строк: 2

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

SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id JOIN (SELECT CEIL(RAND() * (SELECT MAX(id) 
  FROM joomla_djcf_items)) AS num, @num:=@num+1 
  FROM (SELECT @num:=0) AS a, joomla_djcf_items 
  LIMIT 7) AS tmp 
  ON tmp.num = i.id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:13'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (262, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 372, 373, 375, 376, 377, 378, 380, 381, 383, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 396, 397, 398, 400, 401, 402, 403, 405, 406, 407, 408, 409, 410, 411, 413, 414, 415, 416, 419, 420, 421, 423, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 435, 436, 437, 438, 439, 441, 442, 443, 444, 445, 446, 447, 448, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 461, 462, 463, 464, 465, 466, 467, 469, 471, 472, 473, 474, 475, 476, 477, 478, 479, 483, 484, 485, 486, 487, 488, 490, 492, 493, 494, 495, 496, 497, 498, 499, 501, 502, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 515, 516, 517, 518, 519, 520, 521, 522, 524, 525, 526, 528, 531, 535, 536, 537, 538, 546, 551, 557, 561, 563, 564, 565, 566, 567, 569, 570, 571, 573, 575, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 593, 594, 595, 597, 598, 599, 600, 603, 604, 606, 607, 608, 611, 613, 614, 615, 616, 617, 618, 619, 620, 627, 628, 629, 630, 631, 633, 634, 635, 637, 638, 639, 640, 643, 645, 646, 647, 649, 651, 652, 653, 655, 656, 663, 665, 666, 667, 668, 671, 672, 675, 676, 677, 678, 679, 681, 683, 685, 686, 687, 688, 690, 691, 692, 693, 694, 695, 696, 697, 699, 700, 701, 702, 703, 704, 705, 706, 707, 709, 710, 711, 712, 713, 717, 718, 719, 721, 722, 724, 725, 726, 727, 728, 729, 730, 732, 733, 734, 735, 736, 737, 738, 739, 740, 743, 744, 749, 750, 751, 752, 753, 754, 755, 756, 758, 759, 760, 762, 763, 764, 765, 766, 767, 768, 769, 771, 773, 774, 776, 777, 778, 779, 780, 784, 785, 786, 789, 791, 793, 795, 796, 797, 798, 799, 800, 801, 804, 805, 807, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 820, 821, 822, 823, 825, 826, 829, 830, 831, 832, 833, 834, 835, 837, 840, 841, 842, 843, 845, 847, 848, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 861, 862, 864, 865, 866, 867, 868, 869, 870, 872, 873, 874, 875, 876, 879, 883, 886, 888, 890, 892, 895, 898, 900, 901, 903, 907, 912, 913, 914, 917, 919, 920, 921, 922, 923, 926, 928, 929, 930, 932, 933, 935, 936, 939, 940, 942, 943, 944, 946, 947, 949, 952, 953, 957, 959, 960, 962, 969, 970, 976, 977, 978, 981, 985, 987, 988, 991, 995, 996, 998, 999, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1017, 1019, 1020, 1021, 1022, 1023, 1024, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1041, 1043, 1044, 1045, 1046, 1048, 1049, 1050, 1051, 1053, 1055, 1056, 1057, 1058, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1069, 1070, 1073, 1075, 1077, 1081, 1083, 1084, 1088, 1089, 1091, 1092, 1093, 1094, 1096, 1097, 1098, 1099, 1102, 1103, 1105, 1107, 1108, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1121, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1131, 1132, 1133, 1134, 1137, 1139, 1140, 1141, 1142, 1143, 1144, 1146, 1147, 1149, 1150, 1152, 1154, 1156, 1158, 1159, 1161, 1162, 1163, 1165, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1182, 1184, 1185, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1198, 1200, 1202, 1204, 1205, 1206, 1207, 1209, 1210, 1211, 1212, 1213, 1215, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1241, 1243, 1249, 1250, 1251, 1257, 1262, 1264, 1265, 1268, 1269, 1270, 1271, 1275, 1280, 1281, 1282, 1285, 1294, 1295, 1298, 1299, 1300, 1302, 1303, 1304, 1306, 1307, 1310, 1311, 1314, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1332, 1333, 1334, 1335, 1336, 1337, 1339, 1340, 1341, 1342, 1345, 1346, 1348, 1349, 1350, 1351, 1353, 1354, 1355, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1421, 1422, 1424, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1439, 1440, 1441, 1442, 1443, 1445, 1446, 1447, 1448, 1449, 1450, 1452, 1453, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1469, 1470, 1471, 1472, 1473, 1474, 1476, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1489, 1490, 1491, 1492, 1493, 1494, 1496, 1497, 1498, 1499, 1500, 1502, 1503, 1507, 1508, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1521, 1523, 1524, 1525, 1526, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1538, 1539, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1551, 1552, 1553, 1554, 1555, 1557, 1558, 1559, 1560, 1561, 1562, 1564, 1565, 1567, 1568, 1569, 1570, 1571, 1573, 1574, 1575, 1576, 1578, 1580, 1581, 1582, 1584, 1585, 1586, 1587, 1588, 1591, 1594, 1596, 1597, 1598, 1599, 1601, 1602, 1604, 1605, 1609, 1612, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1622, 1623, 1626, 1627, 1628, 1630, 1632, 1634, 1636, 1639, 1642, 1644, 1645, 1647, 1652, 1657, 1658, 1661, 1665, 1666, 1667, 1668, 1669, 1670, 1671, 1673, 1676, 1680, 1686, 1691, 1697, 1701, 1702, 1703, 1708, 1710, 1711, 1712, 1714, 1715, 1716, 1720, 1721, 1722, 1724, 1725, 1727, 1728, 1732, 1735, 1737, 1738, 1739, 1743, 1744, 1745, 1746, 1748, 1749, 1751, 1752, 1753, 1754, 1757, 1765, 1767, 1776, 1778, 1779, 1780, 1787, 1788, 1789, 1790, 1792, 1795, 1798, 1801, 1818, 1889, 1891, 1938, 1974, 1976, 1978, 1983, 1986, 1998, 2001, 2088, 2129, 2137, 2139, 2143, 2147, 2150, 2157, 2166, 2175, 2207, 2209, 2218, 2229, 2241, 2243, 2244, 2264, 2265, 2276, 2371, 2433, 2491, 2502, 2667, 2718, 2719, 2777, 2779, 2785, 2786, 2814, 2841, 2874, 2916, 2943, 2946, 2948, 2949, 2950, 2956, 2958, 2968, 2971, 2975, 2977, 2979, 2980, 2982, 2984, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 2993, 2995, 2996, 2997, 2998, 2999, 3000, 3001, 3002, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived3>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	7	100.00	Using where
1	PRIMARY	i	NULL	eq_ref	PRIMARY,cat_id,user_id,published,blocked,date_exp	PRIMARY	4	tmp.num	1	100.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,published	PRIMARY	4	dandam_jm3.i.cat_id	1	5.00	Using where
1	PRIMARY	r	NULL	eq_ref	PRIMARY	PRIMARY	4	dandam_jm3.i.region_id	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key1>	<auto_key1>	4	tmp.num	19	33.33	Using where
3	DERIVED	<derived5>	NULL	system	NULL	INDEX KEY не используется	NULL	NULL	1	100.00	NULL
3	DERIVED	joomla_djcf_items	NULL	index	NULL	cat_id	4	NULL	382	100.00	Using index
5	DERIVED	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	No tables used
4	SUBQUERY	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Select tables optimized away
2	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

Status	Duration
starting	0.83 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.36 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
optimizing	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
optimizing	0.35 ms
statistics	1.83 ms
preparing	0.25 ms
executing	0.09 ms
executing	5.80 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.05 ms
closing tables	0.07 ms
freeing items	0.13 ms
cleaning up	0.05 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:405
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 24.77 ms После последнего запроса: 0.19 ms Память запроса: 0.061 MB. Память перед запросом: 5.218 MB Возвращено строк: 7

SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img
									
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  LEFT JOIN joomla_djcf_regions r 
  ON r.id=i.region_id 
  WHERE  i.published=1 
  AND i.date_exp > '2025-11-19 10:45:13'  
  AND i.blocked=0 
  AND c.published != 0  
  AND i.user_id IN (262, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 372, 373, 375, 376, 377, 378, 380, 381, 383, 384, 386, 387, 388, 389, 390, 391, 392, 393, 394, 396, 397, 398, 400, 401, 402, 403, 405, 406, 407, 408, 409, 410, 411, 413, 414, 415, 416, 419, 420, 421, 423, 424, 425, 426, 427, 428, 429, 431, 432, 433, 434, 435, 436, 437, 438, 439, 441, 442, 443, 444, 445, 446, 447, 448, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 461, 462, 463, 464, 465, 466, 467, 469, 471, 472, 473, 474, 475, 476, 477, 478, 479, 483, 484, 485, 486, 487, 488, 490, 492, 493, 494, 495, 496, 497, 498, 499, 501, 502, 504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 515, 516, 517, 518, 519, 520, 521, 522, 524, 525, 526, 528, 531, 535, 536, 537, 538, 546, 551, 557, 561, 563, 564, 565, 566, 567, 569, 570, 571, 573, 575, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 593, 594, 595, 597, 598, 599, 600, 603, 604, 606, 607, 608, 611, 613, 614, 615, 616, 617, 618, 619, 620, 627, 628, 629, 630, 631, 633, 634, 635, 637, 638, 639, 640, 643, 645, 646, 647, 649, 651, 652, 653, 655, 656, 663, 665, 666, 667, 668, 671, 672, 675, 676, 677, 678, 679, 681, 683, 685, 686, 687, 688, 690, 691, 692, 693, 694, 695, 696, 697, 699, 700, 701, 702, 703, 704, 705, 706, 707, 709, 710, 711, 712, 713, 717, 718, 719, 721, 722, 724, 725, 726, 727, 728, 729, 730, 732, 733, 734, 735, 736, 737, 738, 739, 740, 743, 744, 749, 750, 751, 752, 753, 754, 755, 756, 758, 759, 760, 762, 763, 764, 765, 766, 767, 768, 769, 771, 773, 774, 776, 777, 778, 779, 780, 784, 785, 786, 789, 791, 793, 795, 796, 797, 798, 799, 800, 801, 804, 805, 807, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 820, 821, 822, 823, 825, 826, 829, 830, 831, 832, 833, 834, 835, 837, 840, 841, 842, 843, 845, 847, 848, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 861, 862, 864, 865, 866, 867, 868, 869, 870, 872, 873, 874, 875, 876, 879, 883, 886, 888, 890, 892, 895, 898, 900, 901, 903, 907, 912, 913, 914, 917, 919, 920, 921, 922, 923, 926, 928, 929, 930, 932, 933, 935, 936, 939, 940, 942, 943, 944, 946, 947, 949, 952, 953, 957, 959, 960, 962, 969, 970, 976, 977, 978, 981, 985, 987, 988, 991, 995, 996, 998, 999, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1017, 1019, 1020, 1021, 1022, 1023, 1024, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1041, 1043, 1044, 1045, 1046, 1048, 1049, 1050, 1051, 1053, 1055, 1056, 1057, 1058, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1069, 1070, 1073, 1075, 1077, 1081, 1083, 1084, 1088, 1089, 1091, 1092, 1093, 1094, 1096, 1097, 1098, 1099, 1102, 1103, 1105, 1107, 1108, 1110, 1111, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1121, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1131, 1132, 1133, 1134, 1137, 1139, 1140, 1141, 1142, 1143, 1144, 1146, 1147, 1149, 1150, 1152, 1154, 1156, 1158, 1159, 1161, 1162, 1163, 1165, 1168, 1169, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1182, 1184, 1185, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1198, 1200, 1202, 1204, 1205, 1206, 1207, 1209, 1210, 1211, 1212, 1213, 1215, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1241, 1243, 1249, 1250, 1251, 1257, 1262, 1264, 1265, 1268, 1269, 1270, 1271, 1275, 1280, 1281, 1282, 1285, 1294, 1295, 1298, 1299, 1300, 1302, 1303, 1304, 1306, 1307, 1310, 1311, 1314, 1316, 1317, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1325, 1326, 1327, 1328, 1329, 1330, 1332, 1333, 1334, 1335, 1336, 1337, 1339, 1340, 1341, 1342, 1345, 1346, 1348, 1349, 1350, 1351, 1353, 1354, 1355, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1366, 1367, 1368, 1369, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1380, 1381, 1382, 1383, 1384, 1385, 1386, 1387, 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1403, 1404, 1405, 1406, 1407, 1409, 1410, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1421, 1422, 1424, 1426, 1427, 1428, 1429, 1430, 1431, 1433, 1434, 1435, 1436, 1437, 1439, 1440, 1441, 1442, 1443, 1445, 1446, 1447, 1448, 1449, 1450, 1452, 1453, 1455, 1456, 1457, 1458, 1459, 1460, 1461, 1462, 1463, 1464, 1465, 1466, 1467, 1469, 1470, 1471, 1472, 1473, 1474, 1476, 1478, 1479, 1480, 1481, 1482, 1483, 1485, 1486, 1487, 1489, 1490, 1491, 1492, 1493, 1494, 1496, 1497, 1498, 1499, 1500, 1502, 1503, 1507, 1508, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1517, 1518, 1519, 1521, 1523, 1524, 1525, 1526, 1527, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1538, 1539, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1551, 1552, 1553, 1554, 1555, 1557, 1558, 1559, 1560, 1561, 1562, 1564, 1565, 1567, 1568, 1569, 1570, 1571, 1573, 1574, 1575, 1576, 1578, 1580, 1581, 1582, 1584, 1585, 1586, 1587, 1588, 1591, 1594, 1596, 1597, 1598, 1599, 1601, 1602, 1604, 1605, 1609, 1612, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1622, 1623, 1626, 1627, 1628, 1630, 1632, 1634, 1636, 1639, 1642, 1644, 1645, 1647, 1652, 1657, 1658, 1661, 1665, 1666, 1667, 1668, 1669, 1670, 1671, 1673, 1676, 1680, 1686, 1691, 1697, 1701, 1702, 1703, 1708, 1710, 1711, 1712, 1714, 1715, 1716, 1720, 1721, 1722, 1724, 1725, 1727, 1728, 1732, 1735, 1737, 1738, 1739, 1743, 1744, 1745, 1746, 1748, 1749, 1751, 1752, 1753, 1754, 1757, 1765, 1767, 1776, 1778, 1779, 1780, 1787, 1788, 1789, 1790, 1792, 1795, 1798, 1801, 1818, 1889, 1891, 1938, 1974, 1976, 1978, 1983, 1986, 1998, 2001, 2088, 2129, 2137, 2139, 2143, 2147, 2150, 2157, 2166, 2175, 2207, 2209, 2218, 2229, 2241, 2243, 2244, 2264, 2265, 2276, 2371, 2433, 2491, 2502, 2667, 2718, 2719, 2777, 2779, 2785, 2786, 2814, 2841, 2874, 2916, 2943, 2946, 2948, 2949, 2950, 2956, 2958, 2968, 2971, 2975, 2977, 2979, 2980, 2982, 2984, 2986, 2987, 2988, 2989, 2990, 2991, 2992, 2993, 2995, 2996, 2997, 2998, 2999, 3000, 3001, 3002, 3003, 3004, 3005, 3006, 3007, 3008, 3009, 3010, 3011, 3012, 3013, 3014, 3015, 3016) 
  AND img.img_c>0  
  AND c.access_view IN (0,1,1,5)  
  AND c.restriction_18=0 
  ORDER BY rand() 
  LIMIT 7

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,published	INDEX KEY не используется	NULL	NULL	21	4.76	Using where; Using temporary; Используется сортировка файлов
1	PRIMARY	i	NULL	ref	PRIMARY,cat_id,user_id,published,blocked,date_exp	cat_id	4	dandam_jm3.c.id	29	100.00	Using where
1	PRIMARY	r	NULL	ALL	PRIMARY	INDEX KEY не используется	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	dandam_jm3.i.id	10	100.00	NULL
2	DERIVED	img	NULL	ref	item_id,type	type	167	const	1153	100.00	Using temporary

Профиль

Status	Duration
starting	0.76 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.30 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.34 ms
statistics	1.79 ms
preparing	0.20 ms
Creating tmp table	0.28 ms
executing	20.52 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.14 ms
closing tables	0.05 ms
freeing items	0.15 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:412
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.73 ms После последнего запроса: 0.19 ms Память запроса: 0.025 MB. Память перед запросом: 5.252 MB Возвращено строк: 18

SELECT img.* 
  FROM joomla_djcf_images img 
  WHERE img.item_id IN (5104,5176,5266,3165,5246,4889,244) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	img	NULL	range	item_id,type	item_id	4	NULL	18	91.95	Using index condition; Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:435
12	DJClassifiedsImage::getAdsImages()	JROOT/modules/mod_djclassifieds_items/helper.php:425
11	modDjClassifiedsItems::getItems()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:62
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.47 ms После последнего запроса: 0.55 ms Память запроса: 0.024 MB. Память перед запросом: 5.272 MB Возвращено строк: 16

SELECT * 
  FROM joomla_djcf_types 
  WHERE published=1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_items/helper.php:466
11	modDjClassifiedsItems::getTypes()	JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php:66
10	include JROOT/modules/mod_djclassifieds_items/mod_djclassifieds_items.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *
 
  FROM joomla_jmap_metainfo
 
  WHERE `linkurl` = 'https://moskodos.ru/index.php/podskazka-dlya-novichkov'
 
  AND `published` = 1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:514
13	plgSystemJMap->onBeforeCompileHead()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *
 
  FROM joomla_jmap_canonicals
 
  WHERE `linkurl` = 'https://moskodos.ru/index.php/podskazka-dlya-novichkov'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:593
13	plgSystemJMap->onBeforeCompileHead()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.47 ms После последнего запроса: 0.36 ms Память запроса: 0.025 MB. Память перед запросом: 5.163 MB Возвращено строк: 1

SELECT *

  FROM `joomla_extensions`

  WHERE `element` = 'com_gsd' 
  AND `type` = 'component'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:124
19	NRFramework\Extension::get()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:176
18	NRFramework\Extension::isEnabled()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:159
17	NRFramework\Extension::componentIsEnabled()	JROOT/plugins/system/gsd/gsd.php:484
16	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
15	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
14	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
13	plgSystemGSD->onBeforeCompileHead()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.72 ms После последнего запроса: 0.50 ms Память запроса: 0.032 MB. Память перед запросом: 5.186 MB Возвращено строк: 2

SHOW FULL COLUMNS 
  FROM `joomla_gsd_config`

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:26
19	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:412
17	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
16	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
15	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
14	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
13	plgSystemGSD->onBeforeCompileHead()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.37 ms После последнего запроса: 0.15 ms Память запроса: 0.025 MB. Память перед запросом: 5.207 MB Возвращено строк: 1

SELECT *

  FROM joomla_gsd_config

  WHERE `name` = 'config'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:413
17	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
16	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
15	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
14	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
13	plgSystemGSD->onBeforeCompileHead()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM joomla_content AS a

  INNER JOIN joomla_categories AS c 
  on c.id = a.catid

  LEFT JOIN joomla_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 85 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-11-19 07:45:12') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-19 07:45:12') 
  AND (a.state = 1 OR a.state =2)

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
23	ContentModelArticle->getItem()	JROOT/plugins/gsd/content/content.php:55
22	plgGSDContent->viewArticle()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:319
21	GSD\PluginBase->getPayload()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155
20	GSD\PluginBase->onGSDBeforeRender()	Такой же, как вызов в строке ниже
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
15	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
14	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
13	plgSystemGSD->onBeforeCompileHead()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*

  FROM joomla_gsd a

  WHERE a.state = 1 
  AND a.plugin = 'content'

  ORDER BY a.id desc

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	state,plugin	state,plugin	1,152	NULL	1	100.00	Using intersect(state,plugin); Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	1.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	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/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_gsd/models/items.php:158
22	GSDModelItems->getItems()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220
21	GSD\PluginBase->getSnippets()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161
20	GSD\PluginBase->onGSDBeforeRender()	Такой же, как вызов в строке ниже
19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
15	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
14	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
13	plgSystemGSD->onBeforeCompileHead()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *
 
  FROM joomla_jmap_headings
 
  WHERE `linkurl` = 'https://moskodos.ru/index.php/podskazka-dlya-novichkov'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:909
8	plgSystemJMap->onAfterRender()	Такой же, как вызов в строке ниже
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

7 × SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img

3 × SELECT img.* 
  FROM joomla_djcf_images img

3 × SELECT * 
  FROM joomla_djcf_categories

2 × SELECT referreid 
  FROM joomla_alpha_userpoints

2 × SELECT count(*) 
  FROM (SELECT i.*, c.id as c_id, c.name as c_name, c.alias as c_alias, r.id as r_id, r.name as r_name, r.alias as r_alias 
  FROM joomla_djcf_items i JOIN joomla_djcf_categories c 
  ON c.id=i.cat_id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM joomla_djcf_images img

2 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM joomla_content AS a 
  INNER JOIN joomla_categories AS c 
  on c.id = a.catid 
  LEFT JOIN joomla_users AS u 
  on u.id = a.created_by 
  LEFT JOIN joomla_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN joomla_content_rating AS v 
  ON a.id = v.content_id

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

2 × SELECT * 
  FROM `joomla_realtimeanalytics_eventstats`

2 × SELECT `ip`,`reason` 
  FROM joomla_rsfirewall_lists

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

1 × SELECT DISTINCT(user_id) 
  FROM joomla_usergroups as ug1 
  INNER JOIN joomla_usergroups AS ug2 
  ON ug2.lft=ug1.lft 
  AND ug1.rgt=ug2.rgt 
  INNER JOIN joomla_user_usergroup_map AS m 
  ON ug2.id=m.group_id

1 × SELECT * 
  FROM joomla_djcf_images

1 × SELECT * 
  FROM joomla_djcf_types

1 × SELECT `id` 
  FROM joomla_alpha_userpoints_details

1 × SELECT i.region_id, count(i.id) as items_count 
  FROM joomla_djcf_items i

1 × SELECT r.* 
  FROM joomla_djcf_regions r

1 × SELECT cat_id, count(*) as items_count 
  FROM (SELECT i.cat_id 
  FROM joomla_djcf_items i

1 × SELECT *  
  FROM joomla_jmap_metainfo

1 × SELECT *  
  FROM joomla_jmap_canonicals

1 × SELECT * 
  FROM `joomla_extensions`

1 × SELECT * 
  FROM joomla_gsd_config

```
1 × SELECT a.* 
  FROM joomla_gsd a
```

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

1 × SELECT * 
  FROM joomla_alpha_userpoints_rules

1 × SELECT `data` 
  FROM `joomla_session`

1 × 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 joomla_fields AS a 
  LEFT JOIN `joomla_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN joomla_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN joomla_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN joomla_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN joomla_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `joomla_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `method` 
  FROM joomla_alpha_userpoints_rules

1 × SELECT * 
  FROM joomla_rsfirewall_hashes

1 × SELECT id, rules 
  FROM `joomla_viewlevels

1 × SELECT b.id 
  FROM joomla_usergroups AS a 
  LEFT JOIN joomla_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 joomla_extensions

1 × SELECT `path` 
  FROM joomla_rsfirewall_ignored

1 × SELECT `file` 
  FROM joomla_rsfirewall_hashes

1 × SELECT * 
  FROM joomla_rsfirewall_configuratio

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 joomla_menu AS m 
  LEFT JOIN joomla_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM joomla_rsfirewall_snapshots

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM joomla_content AS a 
  LEFT JOIN joomla_categories AS cc 
  ON cc.id = a.catid

1 × SELECT * 
  FROM joomla_rsfirewall_exceptions

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

```
1 × SELECT * 
  FROM joomla_session
```
```
1 × SELECT * 
  FROM joomla_languages
```

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `joomla_contentitem_tag_map` AS m  
  INNER JOIN `joomla_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

1 × SELECT `session_id` 
  FROM `joomla_session`

1 × SELECT *  
  FROM joomla_jmap_headings

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

1 × INSERT INTO `joomla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6636333632646235326562353231396339643866626137346661663933626531', 1, 1763538312, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `joomla_rsfirewall_logs

1 × UPDATE `joomla_extensions` 
  SET `params` = '{\"mediaversion\":\"62a3226dc94d255d7952061fe74bf56b\"}'

1 × SHOW FULL COLUMNS 
  FROM `joomla_session

1 × SHOW FULL COLUMNS 
  FROM `joomla_content

1 × UPDATE joomla_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `joomla_gsd_config