^Наверх

ПЛАНИРУЕМЫЕ МЕРОПРИЯТИЯ

Июнь 2018

ДЕЯТЕЛЬНОСТЬ ДВОРЦА КУЛЬТУРЫ

Опрос

Посещаете ли Вы ДК?

Да, конечно.
Голоса: (0%)
Иногда.
Голоса: (0%)
Нет, никогда.
Голоса: (0%)

Всего голосов:
Первый голос:
Последний голос:

Шаблоны Joomla 3 тут

Щербажский СК

Опубликовано: 13.10.2015 09:17 | Автор: Татьяна | Печать | E-mail | Просмотров: 1254

Наш адрес:

606910 д. Щербаж, ул. 8 марта д. 24а

Режим работы:

Понедельник	Выходной
Вторник	15.00-19.00
Среда	15.00-19.00
Черверг	15.00-19.00
Пятница	15.00-19.00
Суббота	14.00-16.00 20.00-24.00
Воскресенье	14.00-17.00

Смотреть клубные формирования Щербажского СК

Категория: Филиалы

Социальные группы

ОК

Extension Joomla

КИНОзал Шахунского ДК

Extension Joomla

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

Сессия

{"__default":{"session":{"counter":1,"timer":{"start":1529583538,"last":1529583538,"now":1529583538},"token":"faypHfIsjQwzRGo6h2Z4VAyV0yAN5Wk4"},"registry":{"separator":"."},"user":{"id":0,"name":null,"username":null,"email":null,"password":null,"password_clear":"","block":null,"sendEmail":0,"registerDate":null,"lastvisitDate":null,"activation":null,"params":null,"groups":[],"guest":1,"lastResetTime":null,"resetCount":null,"requireReset":null,"aid":0},"com_mailto":{"links":{"a9a1d3c4bdbdeb04e12e652012ef6d996863177e":{"link":"http:\/\/shahcks.ru\/filialy\/shcherbazhskij-sk","expiry":1529583538}}}}}

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

Время

Память

Время: 3.86 ms / 3.86 ms Память: 0.286 MB / 0.89 MB Application: afterLoad

Время: 54.58 ms / 58.44 ms Память: 3.372 MB / 4.26 MB Application: afterInitialise

Время: 16.32 ms / 74.76 ms Память: 1.623 MB / 5.88 MB Application: afterRoute

Время: 4.68 ms / 79.44 ms Память: 0.242 MB / 6.13 MB Application: beforeRenderComponent com_content

Время: 3.76 ms / 83.20 ms Память: 0.420 MB / 6.55 MB Application: Start JAccess::getAssetRules Old (1)

Время: 0.72 ms / 83.92 ms Память: 0.041 MB / 6.59 MB Application: Finish JAccess::getAssetRules Old (1)

Время: 0.04 ms / 83.96 ms Память: 0.000 MB / 6.58 MB Application: Start JAccess::preload(components)

Время: 3.81 ms / 87.78 ms Память: 0.510 MB / 7.09 MB Application: Finish JAccess::preload(components)

Время: 17.58 ms / 105.35 ms Память: 0.969 MB / 8.06 MB Application: New JAccess Preloading Process(com_content.article)

Время: 0.77 ms / 106.12 ms Память: 0.178 MB / 8.24 MB Application: After preloadPermissionsParentIdMapping (com_content.article)

Время: 1.84 ms / 107.96 ms Память: 0.281 MB / 8.52 MB Application: After preloadPermissions (com_content.article)

Время: 0.02 ms / 107.98 ms Память: 0.002 MB / 8.52 MB Application: End New JAccess Preloading Process(com_content.article)

Время: 0.02 ms / 108.00 ms Память: 0.002 MB / 8.52 MB Application: Start JAccess::getAssetRules New (com_content.article.37)

Время: 0.15 ms / 108.15 ms Память: 0.012 MB / 8.53 MB Application: Finish JAccess::getAssetRules New (com_content.article.37)

Время: 7.46 ms / 115.61 ms Память: 0.278 MB / 8.81 MB Application: afterRenderComponent com_content

Время: 2.79 ms / 118.40 ms Память: 0.180 MB / 8.99 MB Application: afterDispatch

Время: 4.42 ms / 122.81 ms Память: 0.283 MB / 9.27 MB Application: beforeRenderModule mod_jlgrouppro (КИНОзал Шахунского ДК)

Время: 1.94 ms / 124.75 ms Память: 0.055 MB / 9.33 MB Application: afterRenderModule mod_jlgrouppro (КИНОзал Шахунского ДК)

Время: 0.13 ms / 124.88 ms Память: 0.000 MB / 9.31 MB Application: beforeRenderModule mod_jlgrouppro (Социальные группы)

Время: 1.09 ms / 125.97 ms Память: 0.030 MB / 9.34 MB Application: afterRenderModule mod_jlgrouppro (Социальные группы)

Время: 0.30 ms / 126.27 ms Память: 0.000 MB / 9.32 MB Application: beforeRenderModule mod_roksprocket (Слайдер анонс)

Время: 19.35 ms / 145.62 ms Память: 1.200 MB / 10.52 MB Application: afterRenderModule mod_roksprocket (Слайдер анонс)

Время: 0.14 ms / 145.76 ms Память: 0.000 MB / 10.48 MB Application: beforeRenderModule mod_menu (ДЕЯТЕЛЬНОСТЬ ДВОРЦА КУЛЬТУРЫ)

Время: 1.92 ms / 147.69 ms Память: 0.034 MB / 10.51 MB Application: afterRenderModule mod_menu (ДЕЯТЕЛЬНОСТЬ ДВОРЦА КУЛЬТУРЫ)

Время: 0.05 ms / 147.74 ms Память: 0.000 MB / 10.50 MB Application: beforeRenderModule mod_sexypolling (Опрос)

Время: 15.70 ms / 163.44 ms Память: 0.272 MB / 10.77 MB Application: afterRenderModule mod_sexypolling (Опрос)

Время: 0.20 ms / 163.64 ms Память: 0.000 MB / 10.76 MB Application: beforeRenderModule mod_jevents_cal (ПЛАНИРУЕМЫЕ МЕРОПРИЯТИЯ)

Время: 24.39 ms / 188.02 ms Память: 1.003 MB / 11.76 MB Application: afterRenderModule mod_jevents_cal (ПЛАНИРУЕМЫЕ МЕРОПРИЯТИЯ)

Время: 0.21 ms / 188.23 ms Память: 0.000 MB / 11.76 MB Application: beforeRenderModule mod_menu (Главное меню)

Время: 18.16 ms / 206.39 ms Память: 0.281 MB / 12.04 MB Application: afterRenderModule mod_menu (Главное меню)

Время: 1578.43 ms / 1784.82 ms Память: 15.941 MB / 27.98 MB Application: afterRender

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.00 ms
storing result in query cache	0.34 ms
cleaning up	0.01 ms

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
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:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_session	range	time	time	45	const	3	100.00	Using where

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/session/storage/database.php:155
12	JSessionStorageDatabase->gc()	Same as call in the line below.
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:46

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.15 ms
cleaning up	0.00 ms

#	Caller	File and line number
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:46

#	Caller	File and line number
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:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_extensions	ref	extension	extension	62	const	43	100.00	Using index condition

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
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:49

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

#	Caller	File and line number
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:49

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

#	Caller	File and line number
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:49

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.48 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
freeing items	0.00 ms
storing result in query cache	0.06 ms
cleaning up	0.00 ms

#	Caller	File and line number
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:49

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__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:49

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

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__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:49

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

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__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:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.10 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
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:49

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
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:670
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:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.00 ms

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
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:670
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:49

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
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:670
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:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; Using where

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

EXPLAIN не доступен для запроса: INSERT INTO jpcxt_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl) VALUES('b057805f1504575566de3364b2058bfd','0','54.158.30.219','1529583538','1529583538','0','CCBot/2.0 (http://commoncrawl.org/faq/)','','')

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.26 ms
Waiting for query cache lock	0.01 ms
update	0.00 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/jvcounter/jvcounter.php:95
9	plgSystemJVCounter->saveData()	JROOT/plugins/system/jvcounter/jvcounter.php:24
8	plgSystemJVCounter->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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:49

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

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

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

4 × SELECT `rules` 
  FROM jpcxt_viewlevels

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

2 × SELECT sv.`ip`,sv.`date` 
  FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa 
  ON sa.id_poll = '2'

2 × SELECT template 
  FROM jpcxt_template_styles as s

2 × SELECT `extension_id` 
  FROM `jpcxt_extensions`

```
2 × SELECT * 
  FROM jpcxt_extensions
```

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

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title 
  FROM jpcxt_content as a 
  LEFT JOIN jpcxt_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jpcxt_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jpcxt_users AS um 
  ON um.id = a.modified_by 
  LEFT JOIN jpcxt_content_rating AS v 
  ON a.id = v.content_id 
  LEFT JOIN jpcxt_viewlevels AS vl 
  ON a.access = vl.id 
  LEFT JOIN jpcxt_languages AS l 
  ON a.language = l.lang_code 
  LEFT JOIN jpcxt_contentitem_tag_map AS ct 
  ON ct.content_item_id = a.id 
  LEFT JOIN jpcxt_tags AS t 
  ON t.id = ct.tag_id 
  LEFT 
  OUTER JOIN (select rsi.provider_id, rsi.
  order 
  from jpcxt_roksprocket_items as rsi

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

1 × SELECT a.id, a.name, a.rules 
  FROM jpcxt_assets AS a

```
1 × select * 
  from jpcxt_session
```

1 × SELECT a.id, a.parent_id 
  FROM jpcxt_assets AS a

1 × SELECT ct.content_item_id as article_id, t.title as tag 
  FROM jpcxt_contentitem_tag_map as ct 
  LEFT JOIN jpcxt_tags AS t 
  ON t.id = ct.tag_id

1 × SELECT i.provider_id as id, i.
  order, i.params 
  FROM jpcxt_roksprocket_items as i

1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM jpcxt_jevents_repetition as rpt  
  LEFT JOIN jpcxt_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  LEFT JOIN jpcxt_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  LEFT JOIN jpcxt_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN jpcxt_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT COUNT(sv.`id_answer`) total_count, MAX(sv.`date`) max_date,MIN(sv.`date`) min_date 
  FROM `jpcxt_sexy_votes` sv JOIN `jpcxt_sexy_answers` sa 
  ON sa.id_poll = '2'

1 × select * 
  from jpcxt_jvcounter_log

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

1 × SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.showresultsduringpoll showresultsduringpoll, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name 
  FROM `jpcxt_sexy_polls` sp JOIN `jpcxt_sexy_answers` sa 
  ON sa.id_poll = sp.id 
  AND sa.published = '1' 
  LEFT JOIN `jpcxt_sexy_templates` st 
  ON st.id = sp.id_template

1 × SELECT c.id 
  FROM jpcxt_categories AS c

```
1 × SELECT * 
  FROM jpcxt_content
```

1 × SELECT extension, file, type 
  FROM jpcxt_rokcommon_configs

1 × SELECT `enabled` 
  FROM `jpcxt_extensions`

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

1 × SELECT id, rules 
  FROM `jpcxt_viewlevels

1 × SELECT `session_id` 
  FROM `jpcxt_session`

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

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

```
1 × SELECT * 
  FROM jpcxt_languages
```

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

1 × SELECT `data` 
  FROM `jpcxt_session`

1 × SELECT element 
  FROM jpcxt_extensions

1 × SELECT a.rules 
  FROM jpcxt_assets AS a

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

```
1 × SELECT * 
  FROM jpcxt_assets
```

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

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

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

1 × SHOW FULL COLUMNS 
  FROM `jpcxt_jev_users

1 × INSERT INTO jpcxt_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl) 
  VALUES('b057805f1504575566de3364b2058bfd','0','54.158.30.219','1529583538','1529583538','0','CCBot/2.0 (http://commoncrawl.org/faq/)','',''

1 × SHOW FULL COLUMNS 
  FROM `jpcxt_content

1 × SHOW FULL COLUMNS 
  FROM `jpcxt_assets

1 × INSERT INTO `jpcxt_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('b057805f1504575566de3364b2058bfd', 0, 1, '1529583538', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `jpcxt_extensions

1 × UPDATE `jpcxt_extensions` 
  SET `params` = '{\"mediaversion\":\"2769d9809de91255ad41c10d39cc1fa3\"}'

```
1 × DELETE  
  FROM `jpcxt_session`
```

#	Caller	File and line number
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/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
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:49

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49