Warning: A non-numeric value encountered in /home/r/rttech/public_html/templates/theme3165/includes/includes.php on line 131

Warning: A non-numeric value encountered in /home/r/rttech/public_html/templates/theme3165/includes/includes.php on line 131
RT TECHNOLOGY GROUP

Предупреждение

JUser: :_load: Не удалось загрузить пользователя с ID 50217.

Внимание

COM_KUNENA_PROFILEPAGE_NOT_ALLOWED_FOR_GUESTS

Warning: count(): Parameter must be an array or an object that implements Countable in /home/r/rttech/public_html/libraries/cms/application/cms.php on line 471

COM_KUNENA_POWEREDBY COM_KUNENA

Контакты:

Телефон: +7 (495) 256-49-50
E-mail: info@rt-tech.ru

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1634971762,
                "last": 1634971762,
                "now": 1634971762
            }
        },
        "registry": {
            "com_kunena": {
                "user0_read": null
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

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

Время

Память

Время: 13.69 ms / 13.69 ms Память: 0.455 MB / 0.79 MB Application: afterLoad

Время: 62.29 ms / 75.98 ms Память: 4.272 MB / 5.06 MB Application: afterInitialise

Время: 15.30 ms / 91.28 ms Память: 0.923 MB / 5.99 MB Application: afterRoute

Время: 4.35 ms / 95.63 ms Память: 0.191 MB / 6.18 MB Application: beforeRenderComponent com_kunena

Время: 12.69 ms / 108.33 ms Память: 0.596 MB / 6.77 MB Application: Start JAccess::getAssetRules Old (com_kunena)

Время: 1.43 ms / 109.76 ms Память: 0.034 MB / 6.81 MB Application: Finish JAccess::getAssetRules Old (com_kunena)

Время: 2.63 ms / 112.39 ms Память: 0.026 MB / 6.83 MB Application: Start JAccess::getAssetRules Old (com_kunena)

Время: 0.58 ms / 112.98 ms Память: 0.014 MB / 6.85 MB Application: Finish JAccess::getAssetRules Old (com_kunena)

Время: 35.00 ms / 147.97 ms Память: 1.715 MB / 8.56 MB Application: afterRenderComponent com_kunena

Время: 1.61 ms / 149.58 ms Память: 0.097 MB / 8.66 MB Application: afterDispatch

Время: 5.30 ms / 154.88 ms Память: 0.218 MB / 8.88 MB Application: beforeRenderModule mod_articles_single (Контакты:)

Время: 4.96 ms / 159.83 ms Память: 0.298 MB / 9.17 MB Application: Start JAccess::getAssetRules Old (1)

Время: 0.28 ms / 160.12 ms Память: 0.014 MB / 9.19 MB Application: Finish JAccess::getAssetRules Old (1)

Время: 0.02 ms / 160.14 ms Память: 0.000 MB / 9.18 MB Application: Start JAccess::preload(components)

Время: 2.08 ms / 162.22 ms Память: 0.237 MB / 9.42 MB Application: Finish JAccess::preload(components)

Время: 18.06 ms / 180.28 ms Память: 0.564 MB / 9.98 MB Application: afterRenderModule mod_articles_single (Контакты:)

Время: 0.04 ms / 180.33 ms Память: 0.000 MB / 9.97 MB Application: beforeRenderModule mod_articles_single (footer logo)

Время: 5.97 ms / 186.30 ms Память: 0.024 MB / 10.00 MB Application: afterRenderModule mod_articles_single (footer logo)

Время: 0.07 ms / 186.37 ms Память: 0.000 MB / 9.99 MB Application: beforeRenderModule mod_menu (Social media)

Время: 2.08 ms / 188.45 ms Память: 0.099 MB / 10.09 MB Application: afterRenderModule mod_menu (Social media)

Время: 0.08 ms / 188.53 ms Память: 0.000 MB / 10.08 MB Application: beforeRenderModule mod_icemegamenu (IceMegaMenu Module)

Время: 10.04 ms / 198.58 ms Память: 0.311 MB / 10.40 MB Application: afterRenderModule mod_icemegamenu (IceMegaMenu Module)

Время: 0.08 ms / 198.65 ms Память: 0.000 MB / 10.39 MB Application: beforeRenderModule mod_custom (telefon)

Время: 2.33 ms / 200.99 ms Память: 0.006 MB / 10.40 MB Application: afterRenderModule mod_custom (telefon)

Время: 5.20 ms / 206.19 ms Память: 0.128 MB / 10.52 MB Application: afterRender

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

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

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

Зафиксировано 37 SQL-запросов 20.73 ms

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

2 повторов: #18 #20

Время запроса: 0.12 ms Память запроса: 0.022 MB Память до запроса: 2.237 MB Выбрано строк: 0

SELECT `data`

  FROM `vbadh_session`

  WHERE `session_id` = '1cdbec662a99ead7a25cad657430a1c1'

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

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

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

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Так же, как вызов в строке ниже.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:780
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:415
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:54

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

Время запроса: 0.08 ms После последнего запроса: 2.03 ms Память запроса: 0.019 MB Память до запроса: 2.353 MB Выбрано строк: 0

SELECT `session_id`

  FROM `vbadh_session`

  WHERE `session_id` = '1cdbec662a99ead7a25cad657430a1c1' 
  LIMIT 1

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:806
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:415
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:54

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

Время запроса: 0.44 ms После последнего запроса: 0.05 ms Память запроса: 0.003 MB Память до запроса: 2.358 MB

INSERT INTO `vbadh_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('1cdbec662a99ead7a25cad657430a1c1', 0, 1, '1634971762', 0, '')

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

EXPLAIN недоступен для запроса: INSERT INTO `vbadh_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('1cdbec662a99ead7a25cad657430a1c1', 0, 1, '1634971762', 0, '')

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

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.07 ms
end	0.00 ms
query end	0.27 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:213
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:806
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:415
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:54

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

Время запроса: 0.34 ms После последнего запроса: 2.69 ms Память запроса: 0.023 MB Память до запроса: 2.529 MB Выбрано строк: 39

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

  FROM `vbadh_extensions`

  WHERE `type` = 'component'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vbadh_extensions	NULL	ref	extension	extension	82	const	39	100.00	NULL

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT b.id

  FROM vbadh_usergroups AS a

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

  WHERE a.id = 9

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT id, rules

  FROM `vbadh_viewlevels`

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

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

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

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.53 ms После последнего запроса: 0.04 ms Память запроса: 0.025 MB Память до запроса: 2.773 MB Выбрано строк: 85

SELECT folder AS type, element AS name, params

  FROM vbadh_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vbadh_extensions	NULL	ref	extension	extension	82	const	109	0.60	Using index condition; Using where; Используется filesort

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.38 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.18 ms После последнего запроса: 24.40 ms Память запроса: 0.021 MB Память до запроса: 4.552 MB Выбрано строк: 10

SELECT * 
  FROM vbadh_loginradius_settings

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58
9	plgSystemSocialLoginTools::sociallogin_getsettings()	JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51
8	plgSystemSocialLoginAndSocialShare->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:677
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.61 ms После последнего запроса: 3.34 ms Память запроса: 0.028 MB Память до запроса: 4.812 MB Выбрано строк: 10

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

  LEFT JOIN vbadh_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	15	10.00	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	rttech_db.m.component_id	1	100.00	Using where

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

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.26 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:446
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:542
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:32
8	plgSystemDropfiles->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:677
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.32 ms После последнего запроса: 12.99 ms Память запроса: 0.025 MB Память до запроса: 5.713 MB Выбрано строк: 2

SHOW FULL COLUMNS 
  FROM `vbadh_komento_configs`

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
13	KomentoTableConfigs->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/cms/router/site.php:738
6	JRouterSite->getComponentRouter()	JROOT/libraries/cms/router/site.php:123
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1123
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT *

  FROM vbadh_komento_configs

  WHERE `component` = 'com_komento'

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_komento/helpers/helper.php:229
9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/cms/router/site.php:738
6	JRouterSite->getComponentRouter()	JROOT/libraries/cms/router/site.php:123
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1123
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

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

  FROM `vbadh_extensions`

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

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.43 ms После последнего запроса: 0.08 ms Память запроса: 0.005 MB Память до запроса: 6.013 MB

UPDATE `vbadh_extensions`

  SET `params` = '{\"mediaversion\":\"0f5d308b7f5489508d2569be27d2cfa1\"}'

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	vbadh_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.05 ms
end	0.00 ms
query end	0.27 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT *

  FROM vbadh_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.22 ms После последнего запроса: 0.12 ms Память запроса: 0.019 MB Память до запроса: 6.157 MB Выбрано строк: 4

SELECT id, home, template, s.params

  FROM vbadh_template_styles as s

  LEFT JOIN vbadh_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	Индекс не используется	NULL	NULL	6	16.67	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	rttech_db.s.template,const	1	4.57	Using index condition; Using where

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT * 
  FROM vbadh_kunena_configuration 
  WHERE id=1

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.67 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:287
8	KunenaConfig->load()	JROOT/libraries/kunena/config.php:241
7	KunenaConfig::getInstance()	JROOT/components/com_kunena/kunena.php:26
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 1.08 ms После последнего запроса: 7.26 ms Память запроса: 0.035 MB Память до запроса: 6.605 MB Выбрано строк: 38

SHOW FULL COLUMNS 
  FROM `vbadh_kunena_users`

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.49 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
18	JTable->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:238
17	TableKunenaUsers->__construct()	JROOT/libraries/joomla/table/table.php:308
16	JTable::getInstance()	JROOT/libraries/kunena/user/user.php:138
15	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:159
14	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:82
13	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:35
12	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
11	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:626
10	JLoader::_load()	JROOT/libraries/loader.php:595
9	JLoader::_autoload()	Так же, как вызов в строке ниже.
8	spl_autoload_call()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

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

SELECT b.rules

  FROM vbadh_assets AS a

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

  WHERE (a.name = 'com_kunena' OR a.parent_id=0)

  ORDER BY b.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	2	100.00	Using union(idx_asset_name,idx_parent_id); Using where; Using temporary; Используется filesort
1	SIMPLE	b	NULL	ALL	idx_lft_rgt	Индекс не используется	NULL	NULL	365	100.00	Range checked for each record (index map: 0x4)

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Creating tmp table	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.32 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
14	JAccess::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:374
13	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:190
12	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:85
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT DISTINCT(user_id)

  FROM vbadh_usergroups as ug1

  INNER JOIN vbadh_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

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

  WHERE ug1.id IN (8)

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

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

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

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
Creating tmp table	0.01 ms
executing	0.00 ms
Sending data	1.59 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:356
14	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:397
13	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:190
12	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:85
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

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

SELECT b.rules

  FROM vbadh_assets AS a

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

  WHERE (a.name = 'com_kunena' OR a.parent_id=0)

  ORDER BY b.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	2	100.00	Using union(idx_asset_name,idx_parent_id); Using where; Using temporary; Используется filesort
1	SIMPLE	b	NULL	ALL	idx_lft_rgt	Индекс не используется	NULL	NULL	365	100.00	Range checked for each record (index map: 0x4)

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
14	JAccess::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:374
13	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:190
12	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:85
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT DISTINCT(user_id)

  FROM vbadh_usergroups as ug1

  INNER JOIN vbadh_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

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

  WHERE ug1.id IN (7)

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	6	33.33	Using where; Using index
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	2106	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
executing	0.00 ms
Sending data	1.64 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:356
14	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:397
13	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:190
12	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:85
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT user_id, category_id, role 
  FROM vbadh_kunena_user_categories 
  WHERE role IN (1,2)

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vbadh_kunena_user_categories	NULL	index	role	role	1	NULL	1	100.00	Using where; Using index

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:92
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.56 ms После последнего запроса: 0.80 ms Память запроса: 0.025 MB Память до запроса: 6.938 MB Выбрано строк: 5

SHOW FULL COLUMNS 
  FROM `vbadh_kunena_sessions`

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.28 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:29
13	TableKunenaSessions->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/libraries/kunena/session.php:71
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:85
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:23
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:41
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:55
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.18 ms После последнего запроса: 17.22 ms Память запроса: 0.023 MB Память до запроса: 8.021 MB Выбрано строк: 1

SELECT template 
  FROM vbadh_template_styles 
  WHERE client_id = 0 
  AND home = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vbadh_template_styles	NULL	ALL	idx_home	Индекс не используется	NULL	NULL	6	16.67	Using where

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_kunena/template/custom/initialize.php:19
12	require_once JROOT/components/com_kunena/template/custom/initialize.php	JROOT/components/com_kunena/template/custom/template.php:34
11	KunenaTemplateCustom->initialize()	JROOT/libraries/kunena/view.php:79
10	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
9	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:43
8	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.47 ms После последнего запроса: 5.06 ms Память запроса: 0.026 MB Память до запроса: 8.254 MB Выбрано строк: 0

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM vbadh_users AS u
			
  LEFT JOIN vbadh_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 50217

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:265
22	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:162
21	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:82
20	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:72
19	KunenaUserHelper::get()	JROOT/components/com_kunena/router.php:142
18	KunenaBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/libraries/kunena/route/route.php:118
11	KunenaRoute::_()	JROOT/libraries/kunena/view.php:84
10	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
9	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:43
8	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.56 ms После последнего запроса: 5.83 ms Память запроса: 0.030 MB Память до запроса: 8.518 MB Выбрано строк: 16

SHOW FULL COLUMNS 
  FROM `vbadh_users`

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
22	JTable->__construct()	JROOT/libraries/joomla/table/user.php:40
21	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
20	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:583
19	JUser::getTable()	JROOT/libraries/joomla/user/user.php:858
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_kunena/views/user/view.html.php:68
14	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:20
13	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:128
12	KunenaView->displayLayout()	JROOT/components/com_kunena/template/custom/html/display.php:22
11	include JROOT/components/com_kunena/template/custom/html/display.php	JROOT/libraries/kunena/view.php:85
10	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
9	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:43
8	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.14 ms После последнего запроса: 0.09 ms Память запроса: 0.026 MB Память до запроса: 8.548 MB Выбрано строк: 0

SELECT *

  FROM `vbadh_users`

  WHERE `id` = 50217

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:86
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:861
18	JUser->load()	JROOT/libraries/joomla/user/user.php:243
17	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
16	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
15	JFactory::getUser()	JROOT/components/com_kunena/views/user/view.html.php:68
14	KunenaViewUser->displayCommon()	JROOT/components/com_kunena/views/user/view.html.php:20
13	KunenaViewUser->displayDefault()	JROOT/libraries/kunena/view.php:128
12	KunenaView->displayLayout()	JROOT/components/com_kunena/template/custom/html/display.php:22
11	include JROOT/components/com_kunena/template/custom/html/display.php	JROOT/libraries/kunena/view.php:85
10	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
9	KunenaController->display()	JROOT/components/com_kunena/controllers/user.php:43
8	KunenaControllerUser->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:268
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT template 
  FROM vbadh_template_styles 
  WHERE client_id = 1 
  AND home = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vbadh_template_styles	NULL	ALL	idx_home	Индекс не используется	NULL	NULL	6	16.67	Using where

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/templates/theme3165/includes/includes.php:31
8	include_once JROOT/templates/theme3165/includes/includes.php	JROOT/templates/theme3165/index.php:3
7	require JROOT/templates/theme3165/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1079
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 1.08 ms После последнего запроса: 1.19 ms Память запроса: 0.024 MB Память до запроса: 8.851 MB Выбрано строк: 5

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

  FROM vbadh_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-10-23 06:49:22') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-10-23 06:49:22') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	15	1.60	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	rttech_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	rttech_db.m.id	2	40.00	Using where; Using index

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

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.34 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.07 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:434
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:370
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
9	JDocumentHtml->countModules()	JROOT/templates/theme3165/includes/includes.php:118
8	include_once JROOT/templates/theme3165/includes/includes.php	JROOT/templates/theme3165/index.php:3
7	require JROOT/templates/theme3165/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1079
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.46 ms После последнего запроса: 5.08 ms Память запроса: 0.027 MB Память до запроса: 9.147 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `vbadh_assets`

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
18	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
17	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
16	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
15	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
14	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
13	JUser->authorise()	JROOT/components/com_content/models/article.php:128
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT *

  FROM vbadh_assets

  WHERE `id` = '1'

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
16	JTable->load()	JROOT/libraries/joomla/access/access.php:697
15	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
14	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
13	JUser->authorise()	JROOT/components/com_content/models/article.php:128
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT a.rules

  FROM vbadh_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
14	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
13	JUser->authorise()	JROOT/components/com_content/models/article.php:128
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

SELECT element

  FROM vbadh_extensions

  WHERE type = 'component' 
  AND enabled = '1'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vbadh_extensions	NULL	ref	extension	extension	82	const	39	10.00	Using where

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
14	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
13	JUser->authorise()	JROOT/components/com_content/models/article.php:128
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 1.18 ms После последнего запроса: 0.07 ms Память запроса: 0.026 MB Память до запроса: 9.207 MB Выбрано строк: 39

SELECT a.name, a.rules

  FROM vbadh_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dropeditor','com_dropfiles','com_droppics','com_finder','com_installer','com_joomgallery','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_socialloginandsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.20 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.77 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
14	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
13	JUser->authorise()	JROOT/components/com_content/models/article.php:128
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 1.48 ms После последнего запроса: 0.59 ms Память запроса: 0.023 MB Память до запроса: 9.420 MB Выбрано строк: 1

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

  FROM vbadh_content AS a

  LEFT JOIN vbadh_categories AS c 
  on c.id = a.catid

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM vbadh_categories AS cat JOIN vbadh_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 119 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-10-23 06:49:22') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-10-23 06:49:22')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	Индекс не используется	NULL	NULL	43	74.42	Using where; Using temporary; Используется filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	43	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

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

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.64 ms
init	0.09 ms
System lock	0.00 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 1.13 ms После последнего запроса: 1.28 ms Память запроса: 0.023 MB Память до запроса: 9.501 MB Выбрано строк: 1

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

  FROM vbadh_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM vbadh_categories AS cat JOIN vbadh_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN vbadh_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	43	9.04	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	rttech_db.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	Индекс не используется	NULL	NULL	43	76.74	Using where; Using temporary; Используется filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	43	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

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

Status	Duration
starting	0.14 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.00 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.22 ms
Creating sort index	0.25 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.03 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
12	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_single/helper.php:30
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

Время запроса: 0.97 ms После последнего запроса: 14.41 ms Память запроса: 0.023 MB Память до запроса: 10.005 MB Выбрано строк: 1

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

  FROM vbadh_content AS a

  LEFT JOIN vbadh_categories AS c 
  on c.id = a.catid

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM vbadh_categories AS cat JOIN vbadh_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 118 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-10-23 06:49:22') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-10-23 06:49:22')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using index
2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	Индекс не используется	NULL	NULL	43	74.42	Using where; Using temporary; Используется filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	43	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

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

Status	Duration
starting	0.18 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.09 ms
System lock	0.00 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.06 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/modules/mod_articles_single/helper.php:26
11	modArticlesSingleHelper::getItem()	JROOT/modules/mod_articles_single/mod_articles_single.php:13
10	include JROOT/modules/mod_articles_single/mod_articles_single.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1093
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:274
1	JApplicationCms->execute()	JROOT/index.php:57

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

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

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

2 × SELECT b.rules 
  FROM vbadh_assets AS a 
  LEFT JOIN vbadh_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

2 × SELECT DISTINCT(user_id) 
  FROM vbadh_usergroups as ug1 
  INNER JOIN vbadh_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN vbadh_user_usergroup_map AS m 
  ON ug2.id=m.group_id

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

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

2 × SELECT template 
  FROM vbadh_template_styles

1 × SELECT a.name, a.rules 
  FROM vbadh_assets AS a

1 × SELECT element 
  FROM vbadh_extensions

1 × SELECT a.rules 
  FROM vbadh_assets AS a

```
1 × SELECT * 
  FROM vbadh_assets
```

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

```
1 × SELECT * 
  FROM `vbadh_users`
```

1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*    
  FROM vbadh_users AS u    
  LEFT JOIN vbadh_kunena_users AS ku 
  ON u.id = ku.userid

1 × SELECT user_id, category_id, role 
  FROM vbadh_kunena_user_categories

1 × SELECT `data` 
  FROM `vbadh_session`

1 × SELECT `session_id` 
  FROM `vbadh_session`

1 × SELECT * 
  FROM vbadh_kunena_configuration

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

```
1 × SELECT * 
  FROM vbadh_languages
```

1 × SELECT * 
  FROM vbadh_komento_configs

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

1 × SELECT * 
  FROM vbadh_loginradius_setting

1 × SELECT folder AS type, element AS name, params 
  FROM vbadh_extensions

1 × SELECT id, rules 
  FROM `vbadh_viewlevels

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

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

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

1 × INSERT INTO `vbadh_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('1cdbec662a99ead7a25cad657430a1c1', 0, 1, '1634971762', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `vbadh_komento_configs

1 × UPDATE `vbadh_extensions` 
  SET `params` = '{\"mediaversion\":\"0f5d308b7f5489508d2569be27d2cfa1\"}'

1 × SHOW FULL COLUMNS 
  FROM `vbadh_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `vbadh_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `vbadh_users

1 × SHOW FULL COLUMNS 
  FROM `vbadh_assets