номер категории Luxe однокомнатный - СПА-отель «Прометей Клуб» Лазаревское

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

Сессия

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1774199145,
                "last": 1774199145,
                "now": 1774199149
            },
            "token": "yEBUvue0ydGMNKNPVlVjqeFpXWoiZtcs"
        },
        "registry": {
            "com_djcatalog2": {
                "items": {
                    "recent": [
                        40
                    ]
                }
            }
        },
        "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
        },
        "com_rsfirewall": {
            "geoip": "US"
        }
    }
}

Результаты профилирования

Время

Память

Время: 8.47 ms / 8.47 ms Память: 1.675 MB / 2.06 MB Application: afterLoad

Время: 46.81 ms / 55.28 ms Память: 6.665 MB / 8.72 MB Application: afterInitialise

Время: 14.22 ms / 69.50 ms Память: 2.077 MB / 10.80 MB Application: Before Access::preloadComponents (all components)

Время: 0.61 ms / 70.12 ms Память: 0.060 MB / 10.86 MB Application: After Access::preloadComponents (all components)

Время: 0.02 ms / 70.14 ms Память: -0.003 MB / 10.86 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Время: 0.32 ms / 70.46 ms Память: 0.026 MB / 10.88 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Время: 9.32 ms / 79.78 ms Память: 1.194 MB / 12.08 MB Application: afterRoute

Время: 0.67 ms / 80.46 ms Память: 0.086 MB / 12.16 MB Application: beforeRenderComponent com_djcatalog2

Время: 31.87 ms / 112.33 ms Память: 3.770 MB / 15.93 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.03 ms / 112.36 ms Память: 0.007 MB / 15.94 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 4.66 ms / 117.02 ms Память: 0.218 MB / 16.16 MB Application: Before Access::getAssetRules (id:448 name:com_djcatalog2)

Время: 0.03 ms / 117.05 ms Память: 0.007 MB / 16.16 MB Application: After Access::getAssetRules (id:448 name:com_djcatalog2)

Время: 11.73 ms / 128.79 ms Память: 0.722 MB / 16.89 MB Application: afterRenderComponent com_djcatalog2

Время: 3.12 ms / 131.91 ms Память: 0.205 MB / 17.09 MB Application: afterDispatch

Время: 20.35 ms / 152.26 ms Память: 1.671 MB / 18.76 MB Application: beforeRenderModule mod_djmediatools (Все номера отеля страница внизу)

Время: 38.19 ms / 190.45 ms Память: 0.520 MB / 19.28 MB Application: afterRenderModule mod_djmediatools (Все номера отеля страница внизу)

Время: 0.14 ms / 190.59 ms Память: -0.089 MB / 19.19 MB Application: beforeRenderModule mod_custom (Бронирование номера на страницах)

Время: 0.64 ms / 191.23 ms Память: 0.008 MB / 19.20 MB Application: afterRenderModule mod_custom (Бронирование номера на страницах)

Время: 0.04 ms / 191.27 ms Память: -0.002 MB / 19.20 MB Application: beforeRenderModule mod_menu (Номера)

Время: 44.47 ms / 235.74 ms Память: 0.171 MB / 19.37 MB Application: afterRenderModule mod_menu (Номера)

Время: 0.04 ms / 235.78 ms Память: -0.003 MB / 19.37 MB Application: beforeRenderModule mod_custom (На карте)

Время: 0.14 ms / 235.92 ms Память: 0.003 MB / 19.37 MB Application: afterRenderModule mod_custom (На карте)

Время: 2.99 ms / 238.91 ms Память: 0.500 MB / 19.87 MB Application: beforeRenderModule mod_jm_social_icons (JM Social Icons)

Время: 0.85 ms / 239.76 ms Память: 0.039 MB / 19.91 MB Application: afterRenderModule mod_jm_social_icons (JM Social Icons)

Время: 0.06 ms / 239.82 ms Память: -0.025 MB / 19.88 MB Application: beforeRenderModule mod_custom (Яндекс-Метрика)

Время: 0.14 ms / 239.96 ms Память: 0.003 MB / 19.89 MB Application: afterRenderModule mod_custom (Яндекс-Метрика)

Время: 0.01 ms / 239.97 ms Память: -0.001 MB / 19.89 MB Application: beforeRenderModule mod_custom (Copyrights)

Время: 0.10 ms / 240.07 ms Память: 0.003 MB / 19.89 MB Application: afterRenderModule mod_custom (Copyrights)

Время: 0.04 ms / 240.11 ms Память: 0.001 MB / 19.89 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Время: 0.66 ms / 240.77 ms Память: 0.024 MB / 19.92 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Время: 0.04 ms / 240.81 ms Память: -0.004 MB / 19.91 MB Application: beforeRenderModule mod_custom (fonts)

Время: 0.12 ms / 240.93 ms Память: 0.003 MB / 19.91 MB Application: afterRenderModule mod_custom (fonts)

Время: 0.03 ms / 240.96 ms Память: -0.001 MB / 19.91 MB Application: beforeRenderModule mod_custom (Живосайт)

Время: 0.10 ms / 241.06 ms Память: 0.006 MB / 19.92 MB Application: afterRenderModule mod_custom (Живосайт)

Время: 0.03 ms / 241.09 ms Память: -0.001 MB / 19.92 MB Application: beforeRenderModule mod_custom (Телефон отдела бронирования)

Время: 0.13 ms / 241.22 ms Память: 0.003 MB / 19.92 MB Application: afterRenderModule mod_custom (Телефон отдела бронирования)

Время: 0.02 ms / 241.23 ms Память: 0.003 MB / 19.92 MB Application: beforeRenderModule mod_djc2frontpage (Header Frontpage)

Время: 0.45 ms / 241.68 ms Память: 0.026 MB / 19.95 MB Application: afterRenderModule mod_djc2frontpage (Header Frontpage)

Время: 0.04 ms / 241.72 ms Память: -0.007 MB / 19.94 MB Application: beforeRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)

Время: 0.39 ms / 242.12 ms Память: 0.007 MB / 19.95 MB Application: afterRenderModule mod_jm_offcanvas_button (JM Offcanvas Button)

Время: 0.04 ms / 242.15 ms Память: 0.009 MB / 19.96 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu)

Время: 1.49 ms / 243.64 ms Память: 0.208 MB / 20.17 MB Application: beforeRenderModule mod_menu (Коттеджи)

Время: 0.83 ms / 244.47 ms Память: 0.014 MB / 20.18 MB Application: afterRenderModule mod_menu (Коттеджи)

Время: 0.04 ms / 244.50 ms Память: -0.001 MB / 20.18 MB Application: beforeRenderModule mod_menu (Главный корпус)

Время: 2.52 ms / 247.02 ms Память: 0.016 MB / 20.20 MB Application: afterRenderModule mod_menu (Главный корпус)

Время: 0.04 ms / 247.06 ms Память: -0.000 MB / 20.20 MB Application: beforeRenderModule mod_menu (Морские Коттеджи)

Время: 0.53 ms / 247.59 ms Память: 0.009 MB / 20.20 MB Application: afterRenderModule mod_menu (Морские Коттеджи)

Время: 0.04 ms / 247.63 ms Память: -0.001 MB / 20.20 MB Application: beforeRenderModule mod_menu (Мини-сити)

Время: 0.66 ms / 248.29 ms Память: 0.012 MB / 20.22 MB Application: afterRenderModule mod_menu (Мини-сити)

Время: 3.80 ms / 252.09 ms Память: -0.023 MB / 20.19 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu)

Время: 0.03 ms / 252.11 ms Память: -0.021 MB / 20.17 MB Application: beforeRenderModule mod_custom (Телефоны сверху)

Время: 0.14 ms / 252.25 ms Память: 0.003 MB / 20.17 MB Application: afterRenderModule mod_custom (Телефоны сверху)

Время: 0.05 ms / 252.30 ms Память: 0.004 MB / 20.18 MB Application: beforeRenderModule mod_menu (Отель)

Время: 0.65 ms / 252.95 ms Память: 0.011 MB / 20.19 MB Application: afterRenderModule mod_menu (Отель)

Время: 0.03 ms / 252.98 ms Память: 0.008 MB / 20.20 MB Application: beforeRenderModule mod_djmegamenu (коттеджи мега меню справа)

Время: 4.05 ms / 257.03 ms Память: 0.066 MB / 20.26 MB Application: afterRenderModule mod_djmegamenu (коттеджи мега меню справа)

Время: 35.94 ms / 292.97 ms Память: 0.947 MB / 21.21 MB Application: afterRender

Всего SQL-запросов: 27.16 ms

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

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

56 SQL-запросов зафиксировано 27.16 ms

6 повторяющийся запрос!

2 повторов: #32 #35

2 повторов: #33 #36

2 повторов: #34 #37

Время запроса: 0.51 ms Память запроса: 0.020 MB Память до запроса: 3.917 MB Выбрано строк: 1

SELECT `session_id`

  FROM `y4vey_session`

  WHERE `session_id` = X'6f746f333569656a737672376530686775636e6572706d683471' 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_session	const	PRIMARY	PRIMARY	194	const	1	Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:834
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:392
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.55 ms После последнего запроса: 1.75 ms Память запроса: 0.040 MB Память до запроса: 4.200 MB Выбрано строк: 44

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

  FROM `y4vey_extensions`

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 1.37 ms Память запроса: 0.021 MB Память до запроса: 4.408 MB Выбрано строк: 5

SELECT id, rules

  FROM `y4vey_viewlevels`

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

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

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

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

Стек вызовов

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

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

Время запроса: 0.35 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB Память до запроса: 4.420 MB Выбрано строк: 2

SELECT b.id

  FROM y4vey_usergroups AS a

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

  WHERE a.id = 9

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

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

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

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

Стек вызовов

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

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

Время запроса: 0.65 ms После последнего запроса: 0.43 ms Память запроса: 0.046 MB Память до запроса: 4.488 MB Выбрано строк: 123

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

  FROM y4vey_extensions

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

  ORDER BY ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_extensions	ALL	extension	Индекс не используется	NULL	NULL	302	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.51 ms После последнего запроса: 4.26 ms Память запроса: 0.021 MB Память до запроса: 5.326 MB Выбрано строк: 1

SELECT `path`

  FROM y4vey_rsfirewall_ignored

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_rsfirewall_ignored	system	NULL	Индекс не используется	NULL	NULL	1

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

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

Стек вызовов

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

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

Время запроса: 0.24 ms После последнего запроса: 0.03 ms Память запроса: 0.021 MB Память до запроса: 5.332 MB Выбрано строк: 0

SELECT `file`

  FROM y4vey_rsfirewall_hashes

  WHERE `type`='protect'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

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

Время запроса: 0.27 ms После последнего запроса: 0.02 ms Память запроса: 0.025 MB Память до запроса: 5.337 MB Выбрано строк: 62

SELECT *

  FROM y4vey_rsfirewall_configuration

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

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

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

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

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

Время запроса: 0.79 ms После последнего запроса: 3.35 ms Память запроса: 0.025 MB Память до запроса: 5.802 MB Выбрано строк: 10

SHOW FULL COLUMNS 
  FROM `y4vey_rsfirewall_logs`

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

EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `y4vey_rsfirewall_logs`

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:312
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:57
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:673
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.33 ms После последнего запроса: 21.85 ms Память запроса: 0.324 MB Память до запроса: 8.917 MB Выбрано строк: 155

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

  LEFT JOIN y4vey_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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	157	Using index condition; Using where; Используется filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rusturclub_prom.m.component_id	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/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:423
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:539
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:1147
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.40 ms После последнего запроса: 6.19 ms Память запроса: 0.020 MB Память до запроса: 10.350 MB Выбрано строк: 0

SELECT *

  FROM y4vey_rsfirewall_hashes

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1025
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.21 ms Память запроса: 0.021 MB Память до запроса: 10.377 MB Выбрано строк: 0

SELECT *

  FROM y4vey_rsfirewall_snapshots

  WHERE `type`='protect'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1048
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.32 ms После последнего запроса: 0.03 ms Память запроса: 0.021 MB Память до запроса: 10.382 MB Выбрано строк: 0

SELECT `ip`,`reason`

  FROM y4vey_rsfirewall_lists

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1084
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.28 ms После последнего запроса: 0.03 ms Память запроса: 0.021 MB Память до запроса: 10.388 MB Выбрано строк: 0

SELECT `ip`,`reason`

  FROM y4vey_rsfirewall_lists

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_rsfirewall_lists	ref	published,type,ip	type	1	const	4	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1088
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.24 ms После последнего запроса: 0.49 ms Память запроса: 0.021 MB Память до запроса: 10.494 MB Выбрано строк: 0

SELECT *

  FROM y4vey_rsfirewall_exceptions

  WHERE `published`='1'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:691
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1219
8	plgSystemRsfirewall->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.32 ms После последнего запроса: 0.55 ms Память запроса: 0.024 MB Память до запроса: 10.532 MB Выбрано строк: 1

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

  FROM `y4vey_extensions`

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 0.08 ms Память запроса: 0.007 MB Память до запроса: 10.526 MB

UPDATE `y4vey_extensions`

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.51 ms После последнего запроса: 1.90 ms Память запроса: 0.027 MB Память до запроса: 10.805 MB Выбрано строк: 43

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

  FROM `y4vey_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_advancedtemplates','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dbreplacer','com_djcatalog2','com_djmediatools','com_djtabs','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_rsfirewall','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_assets	ALL	idx_asset_name	Индекс не используется	NULL	NULL	265	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:78
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:189
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.30 ms После последнего запроса: 0.93 ms Память запроса: 0.022 MB Память до запроса: 10.912 MB Выбрано строк: 5

SELECT s.*

  FROM y4vey_template_styles as s

  WHERE s.client_id = 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	Индекс не используется	NULL	NULL	7	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedtemplates/src/Document.php:193
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyles()	JROOT/plugins/system/advancedtemplates/src/Document.php:121
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:86
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:189
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.27 ms После последнего запроса: 0.03 ms Память запроса: 0.024 MB Память до запроса: 10.934 MB Выбрано строк: 1

SELECT a.params

  FROM y4vey_advancedtemplates AS a

  WHERE a.styleid = 4

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:86
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:189
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.26 ms После последнего запроса: 0.90 ms Память запроса: 0.024 MB Память до запроса: 11.057 MB Выбрано строк: 1

SELECT a.params

  FROM y4vey_advancedtemplates AS a

  WHERE a.styleid = 7

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:86
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:189
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 0.04 ms Память запроса: 0.024 MB Память до запроса: 11.068 MB Выбрано строк: 1

SELECT a.params

  FROM y4vey_advancedtemplates AS a

  WHERE a.styleid = 27

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:86
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:189
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 0.03 ms Память запроса: 0.024 MB Память до запроса: 11.076 MB Выбрано строк: 1

SELECT a.params

  FROM y4vey_advancedtemplates AS a

  WHERE a.styleid = 28

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:86
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:189
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.51 ms После последнего запроса: 5.69 ms Память запроса: 0.021 MB Память до запроса: 12.048 MB Выбрано строк: 4

SELECT id, home, template, s.params

  FROM y4vey_template_styles as s

  LEFT JOIN y4vey_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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	Индекс не используется	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:2182
10	JMFTemplate::getTemplateStyleId()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:136
9	JMFTemplate->__construct()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:297
8	plgSystemEF4_JMFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.32 ms После последнего запроса: 0.47 ms Память запроса: 0.019 MB Память до запроса: 12.146 MB Выбрано строк: 1

SELECT *

  FROM y4vey_languages

  WHERE published=1

  ORDER BY ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_languages	ALL	NULL	Индекс не используется	NULL	NULL	1	Using where; Используется filesort

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

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

Стек вызовов

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

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

Время запроса: 0.49 ms После последнего запроса: 8.53 ms Память запроса: 0.023 MB Память до запроса: 13.414 MB Выбрано строк: 5

SELECT a.id

  FROM y4vey_viewlevels AS a

  ORDER BY a.ordering ASC, a.id ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	Индекс не используется	NULL	NULL	5	Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:53
13	Djc2CategoryNode->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:168
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70
10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.44 ms После последнего запроса: 0.03 ms Память запроса: 0.073 MB Память до запроса: 13.419 MB Выбрано строк: 11

SELECT c.*  
  FROM y4vey_djc2_categories AS c  
  WHERE c.published=1 
  AND c.access IN (1,5)  
  ORDER BY c.parent_id ASC, c.ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	idx_published,idx_published_parent_ordering,idx_access	Индекс не используется	NULL	NULL	11	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:298
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70
10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.68 ms После последнего запроса: 0.04 ms Память запроса: 0.023 MB Память до запроса: 13.494 MB Выбрано строк: 3

SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath

  FROM y4vey_djc2_categories as i

  INNER JOIN y4vey_djc2_images as img 
  on img.id=(select id 
  from y4vey_djc2_images 
  where type='category' 
  and item_id=i.id 
  order by ordering asc 
  limit 1)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	i	index	NULL	idx_parent_id	4	NULL	11	Using index
1	PRIMARY	img	eq_ref	PRIMARY	PRIMARY	4	func	1	Using where
2	DEPENDENT SUBQUERY	y4vey_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	198	rusturclub_prom.i.id,const	1	Using where; Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:305
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70
10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 1.45 ms Память запроса: 0.021 MB Память до запроса: 13.656 MB Выбрано строк: 5

select alias 
  from y4vey_djc2_items_extra_fields 
  where type='checkbox' or type='radio' or type='select'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_djc2_items_extra_fields	ALL	idx_type	Индекс не используется	NULL	NULL	5	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/controller.php:98
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.84 ms После последнего запроса: 1.90 ms Память запроса: 0.024 MB Память до запроса: 13.970 MB Выбрано строк: 4

SELECT f.*, group_concat(fo.id separator '|') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id

  FROM y4vey_djc2_items_extra_fields as f

  LEFT JOIN y4vey_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

  LEFT JOIN y4vey_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

  WHERE (f.visibility = 1 or f.visibility = 3) 
  and f.published = 1

  GROUP BY f.id

  ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	index	idx_published	PRIMARY	4	NULL	5	Using where; Using temporary; Используется filesort
1	SIMPLE	fo	ref	idx_field_id	idx_field_id	4	rusturclub_prom.f.id	2	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	rusturclub_prom.f.group_id	1

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:254
13	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/models/item.php:137
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.52 ms После последнего запроса: 0.06 ms Память запроса: 0.039 MB Память до запроса: 13.985 MB Выбрано строк: 1

SELECT i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name 

  FROM y4vey_djc2_items as i

  LEFT JOIN y4vey_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN y4vey_djc2_producers AS p 
  ON p.id = i.producer_id

  LEFT JOIN y4vey_users AS ua 
  ON ua.id = i.created_by

  LEFT JOIN y4vey_djc2_countries AS countries 
  ON countries.id = i.country

  WHERE i.id =40 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-03-22 17:05:49') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-03-22 17:05:49')

  GROUP BY i.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	countries	const	PRIMARY	PRIMARY	2	const	0	Unique row not found

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:166
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.51 ms После последнего запроса: 0.03 ms Память запроса: 0.023 MB Память до запроса: 14.022 MB Выбрано строк: 4

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

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value

  FROM y4vey_djc2_items_extra_fields_values_int as fieldvalues

  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  LEFT JOIN y4vey_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

  WHERE fieldvalues.item_id=40 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc, fieldoptions.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Используется filesort
1	SIMPLE	fields	ALL	PRIMARY,idx_published	Индекс не используется	NULL	NULL	5	Using where
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	8	const,rusturclub_prom.fields.id	1
1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	rusturclub_prom.fieldvalues.value	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:290
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.34 ms После последнего запроса: 0.02 ms Память запроса: 0.024 MB Память до запроса: 14.039 MB Выбрано строк: 0

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

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM y4vey_djc2_items_extra_fields_values_text as fieldvalues

  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=40 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	rusturclub_prom.fieldvalues.field_id	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:292
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 0.01 ms Память запроса: 0.023 MB Память до запроса: 14.047 MB Выбрано строк: 0

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

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM y4vey_djc2_items_extra_fields_values_date as fieldvalues

  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=40 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Используется filesort
1	SIMPLE	fieldvalues	ref	item_field	item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	rusturclub_prom.fieldvalues.field_id	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:294
13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
12	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.45 ms После последнего запроса: 1.58 ms Память запроса: 0.023 MB Память до запроса: 14.849 MB Выбрано строк: 4

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

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value

  FROM y4vey_djc2_items_extra_fields_values_int as fieldvalues

  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  LEFT JOIN y4vey_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

  WHERE fieldvalues.item_id=40 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc, fieldoptions.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Используется filesort
1	SIMPLE	fields	ALL	PRIMARY,idx_published	Индекс не используется	NULL	NULL	5	Using where
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	8	const,rusturclub_prom.fields.id	1
1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	rusturclub_prom.fieldvalues.value	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:290
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.33 ms После последнего запроса: 0.02 ms Память запроса: 0.023 MB Память до запроса: 14.859 MB Выбрано строк: 0

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

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM y4vey_djc2_items_extra_fields_values_text as fieldvalues

  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=40 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	rusturclub_prom.fieldvalues.field_id	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:292
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.38 ms После последнего запроса: 0.02 ms Память запроса: 0.023 MB Память до запроса: 14.867 MB Выбрано строк: 0

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

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM y4vey_djc2_items_extra_fields_values_date as fieldvalues

  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=40 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Используется filesort
1	SIMPLE	fieldvalues	ref	item_field	item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	rusturclub_prom.fieldvalues.field_id	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:294
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
12	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.30 ms После последнего запроса: 0.32 ms Память запроса: 0.023 MB Память до запроса: 14.886 MB Выбрано строк: 24

select id, producer_id 
  from y4vey_djc2_items 
  where published=1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_djc2_items	ref	idx_published	idx_published	4	const	24

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:77
11	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:100
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.29 ms После последнего запроса: 7.89 ms Память запроса: 0.022 MB Память до запроса: 15.661 MB Выбрано строк: 0

SELECT related_item

  FROM y4vey_djc2_items_related

  WHERE item_id=40

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_djc2_items_related	ref	item_related	item_related	4	const	1	Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:213
11	DJCatalog2ModelItem->getRelatedItems()	JROOT/components/com_djcatalog2/views/item/view.html.php:165
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.76 ms После последнего запроса: 0.04 ms Память запроса: 0.022 MB Память до запроса: 15.669 MB Выбрано строк: 1

SELECT subq.position 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM y4vey_djc2_items AS i  
  LEFT JOIN y4vey_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN y4vey_djc2_producers as p 
  ON p.id = i.producer_id  
  WHERE i.parent_id = 0 
  AND i.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-03-22 17:05:49') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-03-22 17:05:49') 
  AND c.published = 1  
  AND i.cat_id=12 
  ORDER BY  i.ordering asc, c.ordering asc) as k) as subq 
  WHERE subq.id = 40 
  ORDER BY subq.position DESC 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	Индекс не используется	NULL	NULL	4	Using where; Используется filesort
2	DERIVED	<derived3>	system	NULL	Индекс не используется	NULL	NULL	1
2	DERIVED	<derived4>	ALL	NULL	Индекс не используется	NULL	NULL	4
4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
4	DERIVED	i	index_merge	idx_cat_id,idx_parent_id,idx_published	idx_cat_id,idx_published	4,4	NULL	4	Using intersect(idx_cat_id,idx_published); Using where; Используется filesort
3	DERIVED	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	No tables used

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:416
11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:167
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.68 ms После последнего запроса: 0.01 ms Память запроса: 0.022 MB Память до запроса: 15.676 MB Выбрано строк: 0

SELECT subq.* 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM y4vey_djc2_items AS i  
  LEFT JOIN y4vey_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN y4vey_djc2_producers as p 
  ON p.id = i.producer_id  
  WHERE i.parent_id = 0 
  AND i.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-03-22 17:05:49') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-03-22 17:05:49') 
  AND c.published = 1  
  AND i.cat_id=12 
  ORDER BY  i.ordering asc, c.ordering asc) as k) as subq 
  WHERE subq.position < 1 
  ORDER BY subq.position DESC 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	Индекс не используется	NULL	NULL	4	Using where; Используется filesort
2	DERIVED	<derived3>	system	NULL	Индекс не используется	NULL	NULL	1
2	DERIVED	<derived4>	ALL	NULL	Индекс не используется	NULL	NULL	4
4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
4	DERIVED	i	index_merge	idx_cat_id,idx_parent_id,idx_published	idx_cat_id,idx_published	4,4	NULL	4	Using intersect(idx_cat_id,idx_published); Using where; Используется filesort
3	DERIVED	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	No tables used

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:428
11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:167
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.67 ms После последнего запроса: 0.01 ms Память запроса: 0.022 MB Память до запроса: 15.683 MB Выбрано строк: 1

SELECT subq.* 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM y4vey_djc2_items AS i  
  LEFT JOIN y4vey_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN y4vey_djc2_producers as p 
  ON p.id = i.producer_id  
  WHERE i.parent_id = 0 
  AND i.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-03-22 17:05:49') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-03-22 17:05:49') 
  AND c.published = 1  
  AND i.cat_id=12 
  ORDER BY  i.ordering asc, c.ordering asc) as k) as subq 
  WHERE subq.position > 1 
  ORDER BY subq.position ASC 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	Индекс не используется	NULL	NULL	4	Using where; Используется filesort
2	DERIVED	<derived3>	system	NULL	Индекс не используется	NULL	NULL	1
2	DERIVED	<derived4>	ALL	NULL	Индекс не используется	NULL	NULL	4
4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
4	DERIVED	i	index_merge	idx_cat_id,idx_parent_id,idx_published	idx_cat_id,idx_published	4,4	NULL	4	Using intersect(idx_cat_id,idx_published); Using where; Используется filesort
3	DERIVED	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	No tables used

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:436
11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:167
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.50 ms После последнего запроса: 1.66 ms Память запроса: 0.026 MB Память до запроса: 15.943 MB Выбрано строк: 5

SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id

  FROM y4vey_djc2_items_extra_fields as f

  LEFT JOIN y4vey_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

  WHERE f.published = 1

  ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	idx_published	Индекс не используется	NULL	NULL	5	Using where; Using temporary; Используется filesort
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	rusturclub_prom.f.group_id	1

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:877
16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:270
15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:489
11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:169
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.29 ms После последнего запроса: 0.03 ms Память запроса: 0.026 MB Память до запроса: 15.962 MB Выбрано строк: 27

SELECT o.id, o.field_id

  FROM y4vey_djc2_items_extra_fields_options AS o

  ORDER BY o.field_id asc, o.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	o	ALL	NULL	Индекс не используется	NULL	NULL	27	Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:887
16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:270
15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:489
11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:169
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.93 ms После последнего запроса: 0.06 ms Память запроса: 0.023 MB Память до запроса: 15.975 MB Выбрано строк: 0

SELECT distinct i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name,states.name as state_name

  FROM y4vey_djc2_items as i

  LEFT JOIN y4vey_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN y4vey_djc2_producers AS p 
  ON p.id = i.producer_id

  LEFT JOIN y4vey_users AS ua 
  ON ua.id = i.created_by

  LEFT JOIN y4vey_djc2_countries AS countries 
  ON countries.id = i.country

  LEFT JOIN y4vey_djc2_countries_states AS states 
  ON states.id = i.state

  WHERE c.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-03-22 17:05:49') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-03-22 17:05:49') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=40

  ORDER BY  i.ordering asc, c.ordering asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_cat_id,idx_parent_id,idx_published,idx_access	idx_parent_id	4	const	1	Using where; Using temporary; Используется filesort
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	rusturclub_prom.i.producer_id	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	rusturclub_prom.i.created_by	1
1	SIMPLE	c	eq_ref	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	rusturclub_prom.i.cat_id	1	Using where
1	SIMPLE	countries	eq_ref	PRIMARY	PRIMARY	2	rusturclub_prom.i.country	1	Using where
1	SIMPLE	states	eq_ref	PRIMARY	PRIMARY	4	rusturclub_prom.i.state	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:199
13	DJCatalog2ModelItems->_getList()	JROOT/components/com_djcatalog2/models/items.php:217
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:489
11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:169
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 0.74 ms Память запроса: 0.023 MB Память до запроса: 16.029 MB Выбрано строк: 3

SELECT *  
  FROM y4vey_djc2_images  
  WHERE item_id=40 	
  AND type='item' 
  AND exclude=0 
  ORDER BY ordering ASC, name ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	198	const,const	3	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/image.php:93
12	DJCatalog2ImageHelper::getImages()	JROOT/components/com_djcatalog2/views/item/view.html.php:316
11	DJCatalog2ViewItem->_prepareDocument()	JROOT/components/com_djcatalog2/views/item/view.html.php:188
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.47 ms После последнего запроса: 0.71 ms Память запроса: 0.006 MB Память до запроса: 16.047 MB

UPDATE y4vey_djc2_items 
  SET hits = hits + 1 
  WHERE id = 40

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

EXPLAIN недоступен для запроса: UPDATE y4vey_djc2_items SET hits = hits + 1 WHERE id = 40

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_djcatalog2/models/item.php:500
11	DJCatalog2ModelItem->hit()	JROOT/components/com_djcatalog2/views/item/view.html.php:190
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.82 ms После последнего запроса: 9.66 ms Память запроса: 0.028 MB Память до запроса: 16.959 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 y4vey_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_djcatalog2.item.description' 
  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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
17	JHtmlContent::prepare()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:238
13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:192
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.73 ms После последнего запроса: 0.98 ms Память запроса: 0.027 MB Память до запроса: 16.970 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 y4vey_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_djcatalog2.item.extra_fields' 
  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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
17	JHtmlContent::prepare()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:260
13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:192
10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.31 ms После последнего запроса: 7.90 ms Память запроса: 0.021 MB Память до запроса: 17.222 MB Выбрано строк: 7

SELECT id 
  FROM y4vey_template_styles 
  ORDER BY id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_template_styles	index	NULL	PRIMARY	4	NULL	7	Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:329
9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126
8	JMFTemplate->__construct()	JROOT/templates/jm-hotel-ef4/index.php:18
7	require JROOT/templates/jm-hotel-ef4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.37 ms После последнего запроса: 5.52 ms Память запроса: 0.124 MB Память до запроса: 18.119 MB Выбрано строк: 91

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM y4vey_modules AS m

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

  LEFT JOIN y4vey_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds	published	1	const	98	Using index condition; Using where; Используется filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	rusturclub_prom.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	rusturclub_prom.m.module,const	1	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:413
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:127
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476
11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469
10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711
9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
8	JMFTemplate->__construct()	JROOT/templates/jm-hotel-ef4/index.php:18
7	require JROOT/templates/jm-hotel-ef4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.76 ms После последнего запроса: 9.53 ms Память запроса: 0.030 MB Память до запроса: 18.918 MB Выбрано строк: 14

SHOW FULL COLUMNS 
  FROM `y4vey_djmt_albums`

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

EXPLAIN недоступен для запроса: SHOW FULL COLUMNS FROM `y4vey_djmt_albums`

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
21	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_djmediatools/tables/categories.php:32
20	DJMediatoolsTableCategories->__construct()	JROOT/libraries/src/Table/Table.php:312
19	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_djmediatools/models/categories.php:164
18	DJMediatoolsModelCategories->getItem()	JROOT/components/com_djmediatools/models/categories.php:210
17	DJMediatoolsModelCategories->getParams()	JROOT/modules/mod_djmediatools/mod_djmediatools.php:43
16	include JROOT/modules/mod_djmediatools/mod_djmediatools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php:63
12	include JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-hotel-ef4/tpl/default.php:63
10	include JROOT/templates/jm-hotel-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-hotel-ef4/index.php:19
7	require JROOT/templates/jm-hotel-ef4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.33 ms После последнего запроса: 0.08 ms Память запроса: 0.027 MB Память до запроса: 18.947 MB Выбрано строк: 1

SELECT *

  FROM y4vey_djmt_albums

  WHERE `id` = '13'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
19	Joomla\CMS\Table\Table->load()	JROOT/components/com_djmediatools/models/categories.php:167
18	DJMediatoolsModelCategories->getItem()	JROOT/components/com_djmediatools/models/categories.php:210
17	DJMediatoolsModelCategories->getParams()	JROOT/modules/mod_djmediatools/mod_djmediatools.php:43
16	include JROOT/modules/mod_djmediatools/mod_djmediatools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php:63
12	include JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-hotel-ef4/tpl/default.php:63
10	include JROOT/templates/jm-hotel-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-hotel-ef4/index.php:19
7	require JROOT/templates/jm-hotel-ef4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.33 ms После последнего запроса: 0.37 ms Память запроса: 0.026 MB Память до запроса: 18.958 MB Выбрано строк: 1

SELECT manifest_cache 
  FROM y4vey_extensions 
  WHERE element='com_djmediatools' 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_djmediatools/helpers/helper.php:82
18	DJMediatoolsLayoutHelper->__construct()	JROOT/components/com_djmediatools/helpers/helper.php:67
17	DJMediatoolsLayoutHelper::getInstance()	JROOT/modules/mod_djmediatools/mod_djmediatools.php:54
16	include JROOT/modules/mod_djmediatools/mod_djmediatools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php:63
12	include JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-hotel-ef4/tpl/default.php:63
10	include JROOT/templates/jm-hotel-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-hotel-ef4/index.php:19
7	require JROOT/templates/jm-hotel-ef4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.51 ms После последнего запроса: 0.08 ms Память запроса: 0.050 MB Память до запроса: 18.971 MB Выбрано строк: 24

SELECT a.*

  FROM y4vey_djmt_items AS a, y4vey_djmt_albums AS c

  WHERE a.catid = 13 
  AND a.catid = c.id 
  AND c.published = 1 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-03-22 17:05:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-03-22 17:05:49')

  ORDER BY a.ordering ASC 
  LIMIT 50

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	a	ALL	catid	Индекс не используется	NULL	NULL	82	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_djmediatools/helpers/helper.php:327
18	DJMediatoolsLayoutHelper->getImagesFromDJMediatools()	JROOT/components/com_djmediatools/helpers/helper.php:161
17	DJMediatoolsLayoutHelper->getSlides()	JROOT/modules/mod_djmediatools/mod_djmediatools.php:60
16	include JROOT/modules/mod_djmediatools/mod_djmediatools.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php:63
12	include JROOT/templates/jm-hotel-ef4/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/jm-hotel-ef4/tpl/default.php:63
10	include JROOT/templates/jm-hotel-ef4/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/jm-hotel-ef4/index.php:19
7	require JROOT/templates/jm-hotel-ef4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.55 ms После последнего запроса: 92.55 ms Память запроса: 0.022 MB Память до запроса: 20.193 MB Выбрано строк: 1

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	y4vey_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_djmegamenu/helper.php:313
11	modDJMMHelper::getVersion()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:80
10	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

4 × SELECT a.params 
  FROM y4vey_advancedtemplates AS a

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

2 × SELECT subq.* 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM y4vey_djc2_items AS i  
  LEFT JOIN y4vey_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN y4vey_djc2_producers as p 
  ON p.id = i.producer_id

2 × SELECT manifest_cache 
  FROM y4vey_extensions

2 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value 
  FROM y4vey_djc2_items_extra_fields_values_int as fieldvalues 
  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id 
  LEFT JOIN y4vey_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

2 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value 
  FROM y4vey_djc2_items_extra_fields_values_text as fieldvalues 
  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

2 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value 
  FROM y4vey_djc2_items_extra_fields_values_date as fieldvalues 
  INNER JOIN y4vey_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN y4vey_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM y4vey_fields AS a 
  LEFT JOIN `y4vey_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN y4vey_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN y4vey_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN y4vey_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN y4vey_fields_groups AS g 
  ON g.id = a.group_id

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

1 × select id, producer_id 
  from y4vey_djc2_items

1 × SELECT related_item 
  FROM y4vey_djc2_items_related

1 × SELECT subq.position 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM y4vey_djc2_items AS i  
  LEFT JOIN y4vey_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN y4vey_djc2_producers as p 
  ON p.id = i.producer_id

1 × SELECT `session_id` 
  FROM `y4vey_session`

1 × SELECT i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name  
  FROM y4vey_djc2_items as i 
  LEFT JOIN y4vey_djc2_categories AS c 
  ON c.id = i.cat_id 
  LEFT JOIN y4vey_djc2_producers AS p 
  ON p.id = i.producer_id 
  LEFT JOIN y4vey_users AS ua 
  ON ua.id = i.created_by 
  LEFT JOIN y4vey_djc2_countries AS countries 
  ON countries.id = i.country

1 × SELECT o.id, o.field_id 
  FROM y4vey_djc2_items_extra_fields_options AS o

1 × SELECT distinct i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name,states.name as state_name 
  FROM y4vey_djc2_items as i 
  LEFT JOIN y4vey_djc2_categories AS c 
  ON c.id = i.cat_id 
  LEFT JOIN y4vey_djc2_producers AS p 
  ON p.id = i.producer_id 
  LEFT JOIN y4vey_users AS ua 
  ON ua.id = i.created_by 
  LEFT JOIN y4vey_djc2_countries AS countries 
  ON countries.id = i.country 
  LEFT JOIN y4vey_djc2_countries_states AS states 
  ON states.id = i.state

1 × SELECT *  
  FROM y4vey_djc2_images

1 × SELECT id 
  FROM y4vey_template_styles

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM y4vey_modules AS m 
  LEFT JOIN y4vey_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN y4vey_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT * 
  FROM y4vey_djmt_albums

1 × SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id 
  FROM y4vey_djc2_items_extra_fields as f 
  LEFT JOIN y4vey_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

1 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath 
  FROM y4vey_djc2_categories as i 
  INNER JOIN y4vey_djc2_images as img 
  on img.id=(select id 
  from y4vey_djc2_images

1 × SELECT f.*, group_concat(fo.id separator '|') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id 
  FROM y4vey_djc2_items_extra_fields as f 
  LEFT JOIN y4vey_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id 
  LEFT JOIN y4vey_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

1 × SELECT * 
  FROM y4vey_rsfirewall_hashes

1 × SELECT id, rules 
  FROM `y4vey_viewlevels

1 × SELECT b.id 
  FROM y4vey_usergroups AS a 
  LEFT JOIN y4vey_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 y4vey_extensions

1 × SELECT `path` 
  FROM y4vey_rsfirewall_ignored

1 × SELECT `file` 
  FROM y4vey_rsfirewall_hashes

1 × SELECT * 
  FROM y4vey_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 y4vey_menu AS m 
  LEFT JOIN y4vey_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM y4vey_rsfirewall_snapshots

1 × select alias 
  from y4vey_djc2_items_extra_fields

1 × SELECT * 
  FROM y4vey_rsfirewall_exceptions

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `y4vey_assets`

1 × SELECT s.* 
  FROM y4vey_template_styles as s

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

```
1 × SELECT * 
  FROM y4vey_languages
```

1 × SELECT a.id 
  FROM y4vey_viewlevels AS a

1 × SELECT c.*  
  FROM y4vey_djc2_categories AS c

1 × SELECT a.* 
  FROM y4vey_djmt_items AS a, y4vey_djmt_albums AS c

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

1 × SHOW FULL COLUMNS 
  FROM `y4vey_rsfirewall_logs

1 × UPDATE `y4vey_extensions` 
  SET `params` = '{\"mediaversion\":\"9d9ebba0750eccd4c9e79a649daa6379\"}'

1 × UPDATE y4vey_djc2_items 
  SET hits = hits + 1

1 × SHOW FULL COLUMNS 
  FROM `y4vey_djmt_albums

Категория номера	Тип размещения	Стоимость на человека в сутки по системе «все включено», руб.
Категория номера	Тип размещения	19/05 – 08/06 20/09 – 01/10	08/06 – 01/07	01/07 – 01/08	01/08 – 25/08	25/08 – 20/09
Люкс 1 комн.	DBL	6100	6800	9400	11050	6800
	3-ий взр.	4450	5800	7400	8650	5800
	реб. (2-12) с 2взр.	2800	3200	3950	4250	3200

Корпус	Коттеджи
Категория номера	Люкс
Количество комнат	Однокомнатные
Максимальное	возможное размещение — 3 человека

Отель

Коттеджи

Главный корпус

Морские Коттеджи

Мини-сити

ТЕЛЕФОН ОТДЕЛА БРОНИРОВАНИЯ: (862) 300-03-84

Luxe

Коттеджи

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

Сессия

Результаты профилирования

Время

Память

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

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

56 SQL-запросов зафиксировано 27.16 ms

6 повторяющийся запрос!

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

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

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