Образование за рубежом
с UniStudy

Изучение английского языка по скайп /ватсап

Языковая школа Unistudy рада предложить вам услугу изучение английского языка по скайп /ватсап. Вам не надо больше тратить время и деньги на дорогу, занятия проходят в удобное для Вас время.

Подробнее...

Семинар с представителем The University of Law (Великобритания)

в г. Астана, по адресу: Кенесары 40, БЦ "7 Континент", 8й этаж, офис 808,

17 ноября в 15.00

Предварительная регистрация по тел 8 777 626 091

Подробнее...

Индивидуальные консультации по обучению в Великобритании

От представителя London South Bank University (Лондон).

Где: г. Астана, Hilton Garden INN

Когда: 19 ноября 2018, в 19.00

Предварительная регистрация по тел 8 777 626 0915

Подробнее...

Предуниверситетская подготовка

Оставить заявку

Подробнее

MBA

Оставить заявку

Подробнее

Мы поможем Вам:

Найти подходящую программу обучения, учебное заведение, страну, в соответствии с Вашими требованиями и финансовыми возможностями
С зачислением в выбранный Вами институт, языковую школу, колледж и т.д.
С визой
С переводом и нотариальным заверением всех необходимых документов для поступления и визы
С проживанием и встречой в аэропорту

Компания "UniStudy" была образована в 2008 году. Каждый год сотни студентов уезжают на учебу за границу через нашу компанию. Наше агентство было создано для тех, кто нуждается в квалифицированной помощи при выборе учебного заведения за рубежом. В нашей компании работают профессионалы в области международного образования. Будущие студенты получают подробную информацию о стране, в которой им предстоит получить образование, об учебном заведении и дальнейших перспективах карьеры.

"UniStudy" имеет связи с ведущими учебными заведениями Англии, Канады, Ирландии, Австралии, США, Голландии, Малайзии и Кипра, которые признаны такими профессиональными организациями как British Council, EnglishUK (Великобритания), ELICOS (Австралия).

"UniStudy" гарантирует широкий выбор программ обучения за рубежом. Наши специалисты всегда помогут с выбором учебного заведения, с зачислением на учебную программу, получением визы и подберут оптимальные условия проживания. Наши сотрудники продолжают курировать студентов во время их обучения за рубежом.

"UniStudy" осуществит Вашу мечту о качественном образовании за рубежом! Достаточно позвонить нам!

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

Сессия

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

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

Время

Память

Время: 53.25 ms / 53.25 ms Память: 0.203 MB / 0.43 MB Application: afterLoad

Время: 256.19 ms / 309.43 ms Память: 2.036 MB / 2.46 MB Application: afterInitialise

Время: 42.56 ms / 351.99 ms Память: 0.305 MB / 2.77 MB Application: Start JAccess::getAssetRules Old (1)

Время: 3.14 ms / 355.13 ms Память: 0.039 MB / 2.81 MB Application: Finish JAccess::getAssetRules Old (1)

Время: 0.06 ms / 355.19 ms Память: 0.000 MB / 2.80 MB Application: Start JAccess::preload(components)

Время: 6.52 ms / 361.71 ms Память: 0.294 MB / 3.10 MB Application: Finish JAccess::preload(components)

Время: 24.58 ms / 386.29 ms Память: 0.238 MB / 3.33 MB Application: afterRoute

Время: 3.55 ms / 389.84 ms Память: 0.146 MB / 3.48 MB Application: beforeRenderComponent com_content

Время: 34.03 ms / 423.87 ms Память: 0.312 MB / 3.79 MB Application: afterRenderComponent com_content

Время: 14.14 ms / 438.01 ms Память: 0.053 MB / 3.84 MB Application: afterDispatch

Время: 90.13 ms / 528.14 ms Память: 0.456 MB / 4.30 MB Application: beforeRenderModule mod_custom (Sections)

Время: 23.45 ms / 551.60 ms Память: 0.107 MB / 4.41 MB Application: afterRenderModule mod_custom (Sections)

Время: 0.59 ms / 552.19 ms Память: 0.057 MB / 4.46 MB Application: beforeRenderModule mod_news_pro_gk5 (Наши программы)

Время: 623.36 ms / 1175.54 ms Память: 1.558 MB / 6.02 MB Application: afterRenderModule mod_news_pro_gk5 (Наши программы)

Время: 0.27 ms / 1175.81 ms Память: 0.000 MB / 5.83 MB Application: beforeRenderModule mod_custom (Обучение за рубежом)

Время: 1.57 ms / 1177.38 ms Память: 0.007 MB / 5.84 MB Application: afterRenderModule mod_custom (Обучение за рубежом)

Время: 0.06 ms / 1177.45 ms Память: 0.000 MB / 5.84 MB Application: beforeRenderModule mod_custom (Видео на главной)

Время: 1.40 ms / 1178.84 ms Память: 0.008 MB / 5.85 MB Application: afterRenderModule mod_custom (Видео на главной)

Время: 0.13 ms / 1178.97 ms Память: 0.000 MB / 5.85 MB Application: beforeRenderModule mod_articles_news (Последние новости)

Время: 20.27 ms / 1199.24 ms Память: 0.260 MB / 6.11 MB Application: afterRenderModule mod_articles_news (Последние новости)

Время: 0.20 ms / 1199.45 ms Память: 0.000 MB / 6.01 MB Application: beforeRenderModule mod_custom (Главная)

Время: 1.37 ms / 1200.81 ms Память: 0.007 MB / 6.02 MB Application: afterRenderModule mod_custom (Главная)

Время: 0.12 ms / 1200.94 ms Память: 0.000 MB / 6.01 MB Application: beforeRenderModule mod_custom (Конакты сверху)

Время: 1.31 ms / 1202.25 ms Память: 0.007 MB / 6.02 MB Application: afterRenderModule mod_custom (Конакты сверху)

Время: 48.36 ms / 1250.60 ms Память: 0.088 MB / 6.11 MB Application: afterRender

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

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

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

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

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

8 повторов: #28 #29 #30 #31 #32 #33 #34 #35

Время запроса: 0.91 ms Память запроса: 0.019 MB Память до запроса: 0.941 MB Выбрано строк: 0

SELECT `data`

  FROM `nvphe_session`

  WHERE `session_id` = 'c1cgfeu8bnso0v1jdrd1qpc505'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nvphe_session	const	PRIMARY	PRIMARY	575	const	1

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 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:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:49

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

Время запроса: 0.59 ms После последнего запроса: 8.97 ms Память запроса: 0.012 MB Память до запроса: 1.009 MB Выбрано строк: 0

SELECT `session_id`

  FROM `nvphe_session`

  WHERE `session_id` = 'c1cgfeu8bnso0v1jdrd1qpc505' 
  LIMIT 1

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

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

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

Время запроса: 0.60 ms После последнего запроса: 0.22 ms Память запроса: 0.009 MB Память до запроса: 1.024 MB

INSERT INTO `nvphe_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('c1cgfeu8bnso0v1jdrd1qpc505', 0, 1, '1545055376', 0, '')

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

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

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

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
update	0.10 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Стек вызовов

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

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

Время запроса: 1.34 ms После последнего запроса: 11.08 ms Память запроса: 0.022 MB Память до запроса: 1.084 MB Выбрано строк: 37

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

  FROM `nvphe_extensions`

  WHERE `type` = 'component'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nvphe_extensions	ref	extension	extension	62	const	37	Using index condition

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.08 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.69 ms После последнего запроса: 5.98 ms Память запроса: 0.015 MB Память до запроса: 1.160 MB Выбрано строк: 2

SELECT b.id

  FROM nvphe_usergroups AS a

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

  WHERE a.id = 9

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.68 ms После последнего запроса: 2.06 ms Память запроса: 0.015 MB Память до запроса: 1.181 MB Выбрано строк: 4

SELECT id, rules

  FROM `nvphe_viewlevels`

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.22 ms После последнего запроса: 0.20 ms Память запроса: 0.014 MB Память до запроса: 1.199 MB Выбрано строк: 62

SELECT folder AS type, element AS name, params

  FROM nvphe_extensions

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

  ORDER BY ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nvphe_extensions	ref	extension	extension	62	const	106	Using index condition; Using where; Используется filesort

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.43 ms После последнего запроса: 47.53 ms Память запроса: 0.026 MB Память до запроса: 1.709 MB Выбрано строк: 7

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

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

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

  ORDER BY m.lft

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.05 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
8	JApplicationSite->getTemplate()	JROOT/plugins/system/gavickExtCache/gavickExtCache.php:35
7	plgSystemGavickExtCache->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.81 ms После последнего запроса: 1.00 ms Память запроса: 0.015 MB Память до запроса: 1.816 MB Выбрано строк: 3

SELECT id, home, template, s.params

  FROM nvphe_template_styles as s

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

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

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

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

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
8	JApplicationSite->getTemplate()	JROOT/plugins/system/gavickExtCache/gavickExtCache.php:35
7	plgSystemGavickExtCache->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.32 ms После последнего запроса: 141.32 ms Память запроса: 0.032 MB Память до запроса: 2.688 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `nvphe_assets`

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.46 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
18	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Так же, как вызов в строке ниже.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
10	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
9	PlgSystemAdvancedModules->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

SELECT *

  FROM nvphe_assets

  WHERE `id` = '1'

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

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

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
17	JTable->load()	JROOT/libraries/joomla/access/access.php:697
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Так же, как вызов в строке ниже.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
10	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
9	PlgSystemAdvancedModules->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

SELECT a.rules

  FROM nvphe_assets AS a

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

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

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

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Так же, как вызов в строке ниже.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
10	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
9	PlgSystemAdvancedModules->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.71 ms После последнего запроса: 2.54 ms Память запроса: 0.024 MB Память до запроса: 2.805 MB Выбрано строк: 37

SELECT element

  FROM nvphe_extensions

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nvphe_extensions	ref	extension	extension	62	const	37	Using index condition; Using where

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Так же, как вызов в строке ниже.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
10	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
9	PlgSystemAdvancedModules->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 2.81 ms После последнего запроса: 0.31 ms Память запроса: 0.025 MB Память до запроса: 2.836 MB Выбрано строк: 35

SELECT a.name, a.rules

  FROM nvphe_assets AS a

  WHERE (a.name IN ('com_admin','com_advancedmodules','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_jursspublisher','com_k2','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_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') OR a.name = 'root.1')

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

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

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.18 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
13	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
12	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Так же, как вызов в строке ниже.
11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
10	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
9	PlgSystemAdvancedModules->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

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

  FROM `nvphe_extensions`

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

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	Так же, как вызов в строке ниже.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
9	plgSystemK2->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.75 ms После последнего запроса: 0.42 ms Память запроса: 0.018 MB Память до запроса: 3.122 MB

UPDATE `nvphe_extensions`

  SET `params` = '{\"mediaversion\":\"3ad1a3f0f95c1621c4353fab3eefa95a\"}'

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

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

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

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

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.08 ms
updating	0.08 ms
end	0.05 ms
Waiting for query cache lock	0.01 ms
end	0.05 ms
query end	0.11 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
9	plgSystemK2->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

SELECT *

  FROM nvphe_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:274
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:55
10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:478
9	plgSystemK2->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	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:1125
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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 2.47 ms После последнего запроса: 29.21 ms Память запроса: 0.032 MB Память до запроса: 3.732 MB Выбрано строк: 0

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

  FROM nvphe_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nvphe_categories AS cat JOIN nvphe_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

  WHERE a.featured = 1 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-17 14:02:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-17 14:02:57')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 12

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_featured_catid	idx_featured_catid	1	const	1	Using where; Using temporary; Используется filesort
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	profici1_uni.c.id	4	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Используется filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	20	Using where; Using index; Using join buffer (flat, BNL join)

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.23 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
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.13 ms
optimizing	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.07 ms
preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.72 ms
Creating sort index	0.04 ms
removing tmp table	0.13 ms
Creating sort index	0.01 ms
removing tmp table	0.01 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.05 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
15	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
14	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
12	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

SELECT COUNT(*)

  FROM nvphe_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nvphe_categories AS cat JOIN nvphe_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

  WHERE a.featured = 1 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-17 14:02:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-17 14:02:57')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_featured_catid	idx_featured_catid	1	const	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.catid	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	profici1_uni.c.id	4	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Используется filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	20	Using where; Using index; Using join buffer (flat, BNL join)

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 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.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.02 ms
Sending data	0.03 ms
removing tmp table	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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:261
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.69 ms После последнего запроса: 56.98 ms Память запроса: 0.038 MB Память до запроса: 3.978 MB Выбрано строк: 12

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

  FROM nvphe_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.31 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:404
17	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	Так же, как вызов в строке ниже.
15	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:164
14	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
13	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:356
12	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
11	JModuleHelper::getModules()	JROOT/templates/gk_news/layouts/default.php:32
10	include JROOT/templates/gk_news/layouts/default.php	JROOT/templates/gk_news/lib/gk.framework.php:145
9	GKTemplate->getLayout()	JROOT/templates/gk_news/lib/gk.framework.php:91
8	GKTemplate->__construct()	JROOT/templates/gk_news/index.php:29
7	require JROOT/templates/gk_news/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:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.07 ms После последнего запроса: 94.15 ms Память запроса: 0.018 MB Память до запроса: 4.790 MB Выбрано строк: 1

select enabled 
  from nvphe_extensions 
  where type="component" 
  and element = "com_k2"

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:89
11	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:27
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.85 ms После последнего запроса: 2.35 ms Память запроса: 0.020 MB Память до запроса: 4.813 MB Выбрано строк: 13

SELECT 
					c.id AS CID
				
  FROM 
					nvphe_k2_categories AS c
				
  LEFT JOIN 
					nvphe_k2_items AS content 
					
  ON 
					c.id = content.catid 	
				 
				
  WHERE 
					1=1 
					 
  AND ( c.id = 2) 
					
  AND 
					c.published = 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,category,published	PRIMARY	4	const	1
1	SIMPLE	content	ref	catid	catid	4	const	13	Using index

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
13	NSP_GK5_com_k2_Model::getSources()	Так же, как вызов в строке ниже.
12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:115
11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.14 ms После последнего запроса: 0.38 ms Память запроса: 0.021 MB Память до запроса: 4.835 MB Выбрано строк: 8

SELECT
			content.id AS id				
		
  FROM 
			nvphe_k2_items AS content 
			
			
		
  WHERE 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2018-12-17 20:02:57' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2018-12-17 20:02:57' )
			 
  AND (  content.catid = 2 ) 
			
			 
			
			
		
			
		
		
  ORDER BY 
			 content.hits DESC 
		
  LIMIT
			0,16;

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	ref	item,catid	catid	4	const	13	Using where; Используется filesort

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.01 ms
Creating sort index	0.35 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
13	NSP_GK5_com_k2_Model::getArticles()	Так же, как вызов в строке ниже.
12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:129
11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.52 ms После последнего запроса: 0.15 ms Память запроса: 0.026 MB Память до запроса: 4.862 MB Выбрано строк: 8

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text,
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname, 
			categories.image AS cat_image,
			categories.alias AS cat_alias,
			users.email AS author_email,
			content.created_by_alias AS author_alias,
			users.name AS author_username,
			content.created_by AS author_id,
			content_rating.rating_sum AS rating_sum,
			content_rating.rating_count AS rating_count		
		
  FROM 
			nvphe_k2_items AS content 
			
  LEFT JOIN 
				nvphe_k2_categories AS categories 
				
  ON categories.id = content.catid 
			
  LEFT JOIN 
				nvphe_users AS users 
				
  ON users.id = content.created_by 			
			
  LEFT JOIN 
				nvphe_k2_rating AS content_rating 
				
  ON content_rating.itemID = content.id
		
  WHERE 
			1=1
			 
  AND ( content.id = 102 OR  content.id = 98 OR  content.id = 104 OR  content.id = 99 OR  content.id = 101 OR  content.id = 100 OR  content.id = 103 OR  content.id = 105)
		
  ORDER BY 
			 content.hits DESC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content_rating	system	PRIMARY	Индекс не используется	NULL	NULL	0	const row not found
1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	8	Using index condition; Using where; Используется filesort
1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.content.catid	1	Using where
1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.content.created_by	1

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.53 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
13	NSP_GK5_com_k2_Model::getArticles()	Так же, как вызов в строке ниже.
12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:129
11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:31
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 1.93 ms После последнего запроса: 77.84 ms Память запроса: 0.037 MB Память до запроса: 4.956 MB Выбрано строк: 16

SHOW FULL COLUMNS 
  FROM `nvphe_users`

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.57 ms
After opening tables	0.01 ms
System lock	0.05 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Filling schema table	0.04 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 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.02 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.14 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 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:39
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: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_k2/helpers/route.php:75
14	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:84
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.82 ms После последнего запроса: 0.41 ms Память запроса: 0.031 MB Память до запроса: 5.026 MB Выбрано строк: 1

SELECT *

  FROM `nvphe_users`

  WHERE `id` = 723

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

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

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
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_k2/helpers/route.php:75
14	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:84
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

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

  FROM `nvphe_usergroups` AS g

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

  WHERE `m`.`user_id` = 723

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
19	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
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_k2/helpers/route.php:75
14	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:84
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

Повторяющиеся запросы: #29 #30 #31 #32 #33 #34 #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

Повторяющиеся запросы: #28 #30 #31 #32 #33 #34 #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.61 ms После последнего запроса: 63.06 ms Память запроса: 0.025 MB Память до запроса: 5.891 MB Выбрано строк: 0

Повторяющиеся запросы: #28 #29 #31 #32 #33 #34 #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.07 ms
updating status	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

Повторяющиеся запросы: #28 #29 #30 #32 #33 #34 #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 0.42 ms После последнего запроса: 70.08 ms Память запроса: 0.025 MB Память до запроса: 5.941 MB Выбрано строк: 0

Повторяющиеся запросы: #28 #29 #30 #31 #33 #34 #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

Повторяющиеся запросы: #28 #29 #30 #31 #32 #34 #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

Повторяющиеся запросы: #28 #29 #30 #31 #32 #33 #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.04 ms
checking permissions	0.02 ms
sending cached result to clien	0.06 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

Повторяющиеся запросы: #28 #29 #30 #31 #32 #33 #34

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users 
  WHERE userID=723

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

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

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

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.07 ms
updating status	0.02 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
14	K2HelperUtilities::getAvatar()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:87
13	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:195
11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 2.22 ms После последнего запроса: 10.66 ms Память запроса: 0.032 MB Память до запроса: 5.906 MB Выбрано строк: 3

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

  FROM nvphe_content AS a

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

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

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

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nvphe_categories AS cat JOIN nvphe_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

  WHERE 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (20) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-12-17 14:02:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-12-17 14:02:57')

  ORDER BY a.publish_up DESC 
  LIMIT 3

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_catid	idx_catid	4	const	5	Using where; Используется filesort
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	profici1_uni.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	profici1_uni.c.id	4	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Используется filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	20	Using where; Using index; Using join buffer (flat, BNL join)

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

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.27 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
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.13 ms
optimizing	0.07 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.17 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
removing tmp table	0.01 ms
Creating sort index	0.14 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.07 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:74
11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
10	include JROOT/modules/mod_articles_news/mod_articles_news.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

Время запроса: 2.60 ms После последнего запроса: 5.36 ms Память запроса: 0.028 MB Память до запроса: 6.084 MB Выбрано строк: 2

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

  FROM nvphe_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM nvphe_categories AS cat JOIN nvphe_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 nvphe_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=20

  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	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Используется filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	20	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	profici1_uni.c.id	4	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Используется filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	20	Using where; Using index; Using join buffer (flat, BNL join)

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.09 ms
optimizing	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
removing tmp table	0.01 ms
Creating sort index	0.84 ms
Creating sort index	0.09 ms
removing tmp table	0.19 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.04 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 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_news/helper.php:85
11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
10	include JROOT/modules/mod_articles_news/mod_articles_news.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:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:52

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

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

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

8 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM nvphe_k2_users

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

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

1 × select enabled 
  from nvphe_extensions

1 × SELECT 
      c.id AS CID
     
  FROM 
      nvphe_k2_categories AS c
     
  LEFT JOIN 
      nvphe_k2_items AS content 
      
  ON 
      c.id = content.catid

1 × SELECT COUNT(*) 
  FROM nvphe_content AS a 
  LEFT JOIN nvphe_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN nvphe_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN nvphe_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN nvphe_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN nvphe_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM nvphe_categories AS cat JOIN nvphe_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

```
1 × SELECT * 
  FROM `nvphe_users`
```

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 nvphe_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM nvphe_categories AS cat JOIN nvphe_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT
    content.id AS id,
    content.alias AS alias,
    content.title AS title, 
    content.introtext AS text,
    content.created AS date, 
    content.publish_up AS date_publish,
    content.hits AS hits,
    content.featured AS frontpage,
    content.access AS access,
    content.catid AS cid,
    content.video AS video,
    content.plugins AS plugins,
    categories.name AS catname, 
    categories.image AS cat_image,
    categories.alias AS cat_alias,
    users.email AS author_email,
    content.created_by_alias AS author_alias,
    users.name AS author_username,
    content.created_by AS author_id,
    content_rating.rating_sum AS rating_sum,
    content_rating.rating_count AS rating_count  
   
  FROM 
    nvphe_k2_items AS content 
    
  LEFT JOIN 
     nvphe_k2_categories AS categories 
     
  ON categories.id = content.catid 
    
  LEFT JOIN 
     nvphe_users AS users 
     
  ON users.id = content.created_by    
    
  LEFT JOIN 
     nvphe_k2_rating AS content_rating 
     
  ON content_rating.itemID = content.id

1 × SELECT
    content.id AS id    
   
  FROM 
    nvphe_k2_items AS content

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

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

1 × SELECT id, rules 
  FROM `nvphe_viewlevels

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

1 × SELECT `session_id` 
  FROM `nvphe_session`

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

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

1 × SELECT `data` 
  FROM `nvphe_session`

1 × SELECT element 
  FROM nvphe_extensions

1 × SELECT a.rules 
  FROM nvphe_assets AS a

```
1 × SELECT * 
  FROM nvphe_assets
```
```
1 × SELECT * 
  FROM nvphe_languages
```

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

1 × SHOW FULL COLUMNS 
  FROM `nvphe_users

1 × UPDATE `nvphe_extensions` 
  SET `params` = '{\"mediaversion\":\"3ad1a3f0f95c1621c4353fab3eefa95a\"}'

1 × SHOW FULL COLUMNS 
  FROM `nvphe_assets

1 × INSERT INTO `nvphe_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('c1cgfeu8bnso0v1jdrd1qpc505', 0, 1, '1545055376', 0, ''

Образование за рубежом
с UniStudy

Изучение английского языка по скайп /ватсап

Семинар с представителем The University of Law (Великобритания)

Индивидуальные консультации по обучению в Великобритании

Наши программы

Бакалавриат

Языковые курсы за рубежом

Магистратура

Каникулы за рубежом

Предуниверситетская подготовка

Школьное образование

Трансферные программы

MBA

Обучение за рубежом

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

Сессия

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

Время

Память

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

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

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

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

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

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

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

Образование за рубежом с UniStudy

Изучение английского языка по скайп /ватсап

Семинар с представителем The University of Law (Великобритания)

Индивидуальные консультации по обучению в Великобритании

Наши программы

Обучение за рубежом

Получить консультацию

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

Сессия

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

Время

Память

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

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

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

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

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

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

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

Образование за рубежом
с UniStudy