Шахунская ЦКС - Лужайский СДК

^Наверх

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

Июль 2019

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

Опрос

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

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

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

Все для Joomla. Беспланые шаблоны и расширения.

Лужайский СДК

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

Вахтанина Ирина Олеговна - заведующая Лужайским сельским домом культуры.

Лужайский сельский Дом Культуры был построен в 1954 году.
(Вернее был собран из привезённых в 1953 году из Сухобезводного разобранных немецких бараков, а 1954 году весной был собран в п. Лужайки, в нём располагались клуб, библиотека, ателье)
Лужайский СДК работает для всех категорий населения и по нескольким направлениям:
-Возрождение народных традиций,
-Патриотическое воспитание,
-Работа с семьёй,
-Работа с детьми и подростками.
-Работа с молодёжью, пропаганда здорового образа жизни,
-Работа с пожилыми, в том числе социально – незащищёнными группами населения,
-Досуговая деятельность.
СДК работает в тесном сотрудничестве с социальными партнёрами ( МБОУ ОШ, библиотека, МБДОУ «Малыш», ФАП, территориальный отдел.)
В Доме Культуры работают кружки и любительские объединения. В которых насчитывается 127 человек.
Приоритетным направлением в работе учреждения является проектная деятельность.
Лужайский СДК участвует во всех окружных фестивалях и конкурсах, где занимаем призовые места, а так же стараемся принять участие в областных конкурсах.
В 2013 году Лужайский СДК стал победителем в смотре – конкурсе лучших клубных учреждений городского округа г. Шахунья.

Наш адрес:

606910 п. Лужайки ул. Центральная д.8

тел: 8(83152)38-1-34

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

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

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

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

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

ОК

Extension Joomla

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

Extension Joomla

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1563508454,
                "last": 1563508454,
                "now": 1563508454
            },
            "token": "4D8CjIsGreIYhLBbN4wFrz7BZHpIViNW"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "21e8f31b384b47c8a2d39cebefef92844431ad81": {
                    "link": "http:\/\/shahcks.ru\/filialy\/luzhajskij-sdk",
                    "expiry": 1563508454
                }
            }
        }
    }
}

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

Время

Память

Время: 2.95 ms / 2.95 ms Память: 0.562 MB / 0.93 MB Application: afterLoad

Время: 33.36 ms / 36.30 ms Память: 1.730 MB / 2.66 MB Application: afterInitialise

Время: 7.79 ms / 44.09 ms Память: 0.464 MB / 3.13 MB Application: afterRoute

Время: 2.43 ms / 46.53 ms Память: 0.127 MB / 3.25 MB Application: beforeRenderComponent com_content

Время: 5.44 ms / 51.97 ms Память: 0.058 MB / 3.31 MB Application: Before Access::preloadComponents (all components)

Время: 1.11 ms / 53.08 ms Память: 0.068 MB / 3.38 MB Application: After Access::preloadComponents (all components)

Время: 0.03 ms / 53.11 ms Память: 0.000 MB / 3.38 MB Application: Before Access::preloadPermissions (com_content)

Время: 0.75 ms / 53.85 ms Память: 0.221 MB / 3.60 MB Application: After Access::preloadPermissions (com_content)

Время: 0.04 ms / 53.89 ms Память: 0.000 MB / 3.59 MB Application: Before Access::getAssetRules (id:113 name:com_content.article.30)

Время: 0.30 ms / 54.18 ms Память: 0.010 MB / 3.60 MB Application: After Access::getAssetRules (id:113 name:com_content.article.30)

Время: 12.83 ms / 67.01 ms Память: 0.671 MB / 4.27 MB Application: afterRenderComponent com_content

Время: 1.55 ms / 68.56 ms Память: 0.087 MB / 4.35 MB Application: afterDispatch

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

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

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

Время: 0.36 ms / 72.04 ms Память: 0.013 MB / 4.47 MB Application: afterRenderModule mod_jlgrouppro (Социальные группы)

Время: 0.11 ms / 72.15 ms Память: 0.003 MB / 4.47 MB Application: beforeRenderModule mod_roksprocket (Слайдер анонс)

Время: 5.01 ms / 77.16 ms Память: 0.266 MB / 4.74 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Время: 0.04 ms / 77.20 ms Память: 0.007 MB / 4.74 MB Application: After Access::getAssetRules (id:8 name:com_content)

Время: 3.95 ms / 81.15 ms Память: 0.090 MB / 4.83 MB Application: afterRenderModule mod_roksprocket (Слайдер анонс)

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

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

Время: 0.02 ms / 81.97 ms Память: 0.000 MB / 4.83 MB Application: beforeRenderModule mod_sexypolling (Опрос)

Время: 14.56 ms / 96.53 ms Память: 0.189 MB / 5.02 MB Application: afterRenderModule mod_sexypolling (Опрос)

Время: 0.07 ms / 96.60 ms Память: 0.038 MB / 5.06 MB Application: beforeRenderModule mod_jevents_cal (ПЛАНИРУЕМЫЕ МЕРОПРИЯТИЯ)

Время: 1.52 ms / 98.12 ms Память: 0.253 MB / 5.31 MB Application: Before Access::getAssetRules (id:308 name:com_jevents)

Время: 0.04 ms / 98.16 ms Память: 0.007 MB / 5.32 MB Application: After Access::getAssetRules (id:308 name:com_jevents)

Время: 7.87 ms / 106.03 ms Память: 0.294 MB / 5.61 MB Application: afterRenderModule mod_jevents_cal (ПЛАНИРУЕМЫЕ МЕРОПРИЯТИЯ)

Время: 0.07 ms / 106.10 ms Память: 0.009 MB / 5.62 MB Application: beforeRenderModule mod_menu (Главное меню)

Время: 6.30 ms / 112.39 ms Память: 0.326 MB / 5.95 MB Application: afterRenderModule mod_menu (Главное меню)

Время: 723.40 ms / 835.79 ms Память: 4.418 MB / 10.36 MB Application: afterRender

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

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

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

49 SQL-запросов зафиксировано 274.58 ms

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

2 повторов: #8 #9

2 повторов: #14 #16

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

2 повторов: #38 #39

2 повторов: #40 #41

Время запроса: 0.20 ms Память запроса: 0.025 MB Память до запроса: 1.203 MB Выбрано строк: 0

SELECT `data`

  FROM `jpcxt_session`

  WHERE `session_id` = 'c4fc73295a8548250cdddcb639b9c1d4'

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

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

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

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

Стек вызовов

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

SELECT `session_id`

  FROM `jpcxt_session`

  WHERE `session_id` = 'c4fc73295a8548250cdddcb639b9c1d4' 
  LIMIT 1

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

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

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

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

Стек вызовов

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.19 ms После последнего запроса: 0.07 ms Память запроса: 0.004 MB Память до запроса: 1.286 MB

INSERT INTO `jpcxt_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('c4fc73295a8548250cdddcb639b9c1d4', 1, 1563508454, 0, '', 0)

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

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

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

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

Стек вызовов

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.46 ms После последнего запроса: 0.63 ms Память запроса: 0.036 MB Память до запроса: 1.321 MB Выбрано строк: 47

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

  FROM `jpcxt_extensions`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_extensions	ref	extension	extension	82	const	47	100.00	Using index condition; Using where

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

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

Стек вызовов

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id, rules

  FROM `jpcxt_viewlevels`

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

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

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

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

Стек вызовов

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.24 ms После последнего запроса: 0.08 ms Память запроса: 0.022 MB Память до запроса: 1.386 MB Выбрано строк: 2

SELECT b.id

  FROM jpcxt_usergroups AS a

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

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

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

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.73 ms После последнего запроса: 0.15 ms Память запроса: 0.034 MB Память до запроса: 1.409 MB Выбрано строк: 111

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

  FROM jpcxt_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	filtered	Extra
1	SIMPLE	jpcxt_extensions	ref	extension	extension	82	const	137	100.00	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT template

  FROM jpcxt_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

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

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

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

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

Стек вызовов

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT template

  FROM jpcxt_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 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
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT extension, file, type

  FROM jpcxt_rokcommon_configs

  ORDER BY priority

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

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

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

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

Стек вызовов

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `enabled`

  FROM `jpcxt_extensions`

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

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

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	402	const	1	100.00	Using index condition; Using where

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 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
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:71
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.55 ms После последнего запроса: 4.43 ms Память запроса: 0.029 MB Память до запроса: 2.355 MB Выбрано строк: 18

SHOW FULL COLUMNS 
  FROM `jpcxt_extensions`

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

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

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

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

Стек вызовов

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `extension_id`

  FROM `jpcxt_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

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

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	402	const	1	100.00	Using index condition; Using where

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 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
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT *

  FROM jpcxt_extensions

  WHERE `extension_id` = '10035'

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

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

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

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

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `extension_id`

  FROM `jpcxt_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

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

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	402	const	1	100.00	Using index condition; Using where

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 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
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT *

  FROM jpcxt_extensions

  WHERE `extension_id` = '10035'

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

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

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

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

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.84 ms После последнего запроса: 10.52 ms Память запроса: 0.098 MB Память до запроса: 2.694 MB Выбрано строк: 58

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

  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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	74	100.00	Using index condition; Using where; Используется filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.m.component_id	1	100.00	Using where

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

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

Стек вызовов

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `jpcxt_extensions`

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

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

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	extension	484	const,const	1	100.00	Using index condition

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

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

Стек вызовов

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.22 ms После последнего запроса: 0.13 ms Память запроса: 0.005 MB Память до запроса: 3.136 MB

UPDATE `jpcxt_extensions`

  SET `params` = '{\"mediaversion\":\"a228038208a26cdb6c01016b8d13757f\"}'

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

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

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

Стек вызовов

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM jpcxt_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

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

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

Стек вызовов

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.37 ms После последнего запроса: 0.17 ms Память запроса: 0.022 MB Память до запроса: 3.247 MB Выбрано строк: 10

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	Индекс не используется	NULL	NULL	12	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	shahcks_shahcks.s.template,const	1	100.00	Using index condition; Using where

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

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

Стек вызовов

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.92 ms После последнего запроса: 5.81 ms Память запроса: 0.031 MB Память до запроса: 3.315 MB Выбрано строк: 47

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

  FROM `jpcxt_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomgallery','com_joomlaupdate','com_jsecure','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokgallery','com_roksprocket','com_search','com_sexypolling','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

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

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

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

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

Стек вызовов

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.42 ms После последнего запроса: 0.18 ms Память запроса: 0.065 MB Память до запроса: 3.377 MB Выбрано строк: 228

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

  FROM `jpcxt_assets`

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

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

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

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

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

Стек вызовов

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.69 ms После последнего запроса: 0.86 ms Память запроса: 0.035 MB Память до запроса: 3.601 MB Выбрано строк: 31

SHOW FULL COLUMNS 
  FROM `jpcxt_content`

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

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

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

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

Стек вызовов

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM jpcxt_content

  WHERE `id` = '30'

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

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

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

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

Стек вызовов

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

UPDATE jpcxt_content

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

  WHERE `id` = '30'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jpcxt_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

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

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

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.48 ms После последнего запроса: 0.45 ms Память запроса: 0.036 MB Память до запроса: 3.790 MB Выбрано строк: 1

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

  FROM jpcxt_content AS a

  INNER 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

  WHERE a.id = 30 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-07-19 03:54:14') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-19 03:54:14') 
  AND (a.state = 1 OR a.state =2)

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

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

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

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

Стек вызовов

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.26 ms После последнего запроса: 0.83 ms Память запроса: 0.034 MB Память до запроса: 3.857 MB Выбрано строк: 0

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

  FROM `jpcxt_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.59 ms После последнего запроса: 2.56 ms Память запроса: 0.046 MB Память до запроса: 4.017 MB Выбрано строк: 18

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 `s`

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

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

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	63	57.14	Using where

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

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

Стек вызовов

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.46 ms После последнего запроса: 0.37 ms Память запроса: 0.037 MB Память до запроса: 4.108 MB Выбрано строк: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jpcxt_fields AS a

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

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

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

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

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

  LEFT JOIN `jpcxt_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (19,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

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

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

Стек вызовов

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.53 ms После последнего запроса: 1.33 ms Память запроса: 0.027 MB Память до запроса: 4.239 MB Выбрано строк: 15

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

  WHERE a.catid = 19 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-07-19 03:54:14') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-07-19 03:54:14')

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	15	100.00	Using where; Используется filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

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

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

Стек вызовов

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:159
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-07-19 03:54:14') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-07-19 03:54:14') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 150 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

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

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

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

Стек вызовов

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/dd_musicpassion_30/library/Artx/Page.php:43
8	ArtxPage->containsModules()	JROOT/templates/dd_musicpassion_30/index.php:107
7	require JROOT/templates/dd_musicpassion_30/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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 
  where module_id = 112) rsi 
  on a.id = rsi.provider_id

  WHERE ((a.access IN(1,1,5) 
  AND (a.state = 1 or a.state = 2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-07-19 03:54:14') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-19 03:54:14') 
  AND (a.state != -2)) 
  AND a.id IN (190,189))

  GROUP BY id

  ORDER BY IF(ISNULL(rsi.
  order),1,0),rsi.
  order,a.title ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	range	PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias	PRIMARY	4	NULL	2	100.00	Using where; Using temporary; Используется filesort
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.catid	1	100.00	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.created_by	1	100.00	Using where
1	PRIMARY	um	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.modified_by	1	100.00	Using where
1	PRIMARY	v	ALL	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	vl	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.access	1	100.00	NULL
1	PRIMARY	l	ALL	idx_langcode	Индекс не используется	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	ct	index	NULL	idx_core_content_id	4	NULL	1	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.ct.tag_id	1	100.00	Using index
1	PRIMARY	<derived2>	ALL	NULL	Индекс не используется	NULL	NULL	38	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	rsi	ALL	idx_module,idx_module_order	Индекс не используется	NULL	NULL	38	100.00	Using where

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

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

Стек вызовов

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT i.provider_id as id, i.
  order, i.params

  FROM jpcxt_roksprocket_items as i

  WHERE i.module_id = '112' 
  AND i.provider = 'joomla'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	1	100.00	Using index condition; Using where

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

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

Стек вызовов

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.83 ms После последнего запроса: 3.23 ms Память запроса: 0.041 MB Память до запроса: 4.865 MB Выбрано строк: 3

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 
  WHERE sp.published = '1' 
  AND sp.id_category = 2 
  ORDER BY sp.ordering,sp.name,sa.ordering,sa.name

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sp	ref	PRIMARY,id_category	id_category	3	const	1	100.00	Using where; Using temporary; Используется filesort
1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	3	shahcks_shahcks.sp.id_template	1	100.00	NULL
1	SIMPLE	sa	ref	id_poll	id_poll	4	shahcks_shahcks.sp.id	3	100.00	Using where

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

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

Стек вызовов

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_sexypolling/helpers/helper.php:133
12	SexypollingHelper->get_data()	JROOT/components/com_sexypolling/helpers/helper.php:160
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT `rules` 
  FROM jpcxt_viewlevels 
  WHERE id = '6'

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_sexypolling/helpers/helper.php:241
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT `rules` 
  FROM jpcxt_viewlevels 
  WHERE id = '6'

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

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

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

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

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/components/com_sexypolling/helpers/helper.php:242
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT `rules` 
  FROM jpcxt_viewlevels 
  WHERE id = '1'

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

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

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

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

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_sexypolling/helpers/helper.php:254
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT `rules` 
  FROM jpcxt_viewlevels 
  WHERE id = '1'

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

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

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

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

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/components/com_sexypolling/helpers/helper.php:255
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT sv.`ip`,sv.`date` 
  FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa 
  ON sa.id_poll = '2' 
  WHERE sv.id_answer = sa.id 
  AND sv.ip = '18.209.104.7' 
  ORDER BY sv.`date` DESC 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sa	ref	PRIMARY,id_poll	id_poll	4	const	2	100.00	Using temporary; Используется filesort
1	SIMPLE	sv	ref	id_answer	id_answer	4	shahcks_shahcks.sa.id	29	100.00	Using where

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

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

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_sexypolling/helpers/helper.php:303
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

SELECT sv.`ip`,sv.`date` 
  FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa 
  ON sa.id_poll = '2' 
  WHERE sv.id_answer = sa.id 
  AND sv.ip = '18.209.104.7' 
  ORDER BY sv.`date` DESC 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sa	ref	PRIMARY,id_poll	id_poll	4	const	2	100.00	Using temporary; Используется filesort
1	SIMPLE	sv	ref	id_answer	id_answer	4	shahcks_shahcks.sa.id	29	100.00	Using where

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

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

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_sexypolling/helpers/helper.php:305
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB Память до запроса: 4.970 MB Выбрано строк: 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' 
  WHERE sv.id_answer = sa.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sa	ref	PRIMARY,id_poll	id_poll	4	const	2	100.00	NULL
1	SIMPLE	sv	ref	id_answer	id_answer	4	shahcks_shahcks.sa.id	29	100.00	NULL

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

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

Стек вызовов

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_sexypolling/helpers/helper.php:444
11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.45 ms После последнего запроса: 13.72 ms Память запроса: 0.034 MB Память до запроса: 5.376 MB Выбрано строк: 18

SHOW FULL COLUMNS 
  FROM `jpcxt_jev_users`

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
21	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2308
20	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1201
19	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
18	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2337
15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2712
14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:487
11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.44 ms После последнего запроса: 0.66 ms Память запроса: 0.047 MB Память до запроса: 5.498 MB Выбрано строк: 10

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`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

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

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

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

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

Стек вызовов

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:47
22	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:77
20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
19	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
18	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2337
15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2712
14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:487
11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 0.19 ms Память запроса: 0.028 MB Память до запроса: 5.552 MB Выбрано строк: 9

SELECT c.id

  FROM jpcxt_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('ru-RU','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	10	100.00	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
21	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:186
20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
19	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
18	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2337
15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2712
14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:487
11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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
 
  INNER JOIN jpcxt_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN jpcxt_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER 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
 
  WHERE ev.catid IN(-1,54,55,56,57,58,59,60,61,62)
 
  AND rpt.endrepeat >= '2019-07-01 00:00:00' 
  AND rpt.startrepeat <= '2019-07-31 23:59:59'
 
  AND NOT (rpt.startrepeat < '2019-07-01 00:00:00' 
  AND det.multiday=0)  
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	Индекс не используется	NULL	NULL	1	100.00	NULL
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	2	100.00	Using index condition; Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	shahcks_shahcks.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	shahcks_shahcks.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	shahcks_shahcks.rpt.eventid	1	100.00	NULL

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

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

Стек вызовов

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
16	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2533
15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2712
14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:487
11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 256.46 ms После последнего запроса: 13.67 ms Память запроса: 93.509 MB Память до запроса: 6.194 MB Выбрано строк: 278248

select * 
  from jpcxt_jvcounter_logs

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

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

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

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

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvcounter/jvcounter.php:107
9	plgSystemJVCounter->getDataLogs()	JROOT/plugins/system/jvcounter/jvcounter.php:48
8	plgSystemJVCounter->saveData()	JROOT/plugins/system/jvcounter/jvcounter.php:24
7	plgSystemJVCounter->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

select * 
  from jpcxt_session  
  where session_id = 'c4fc73295a8548250cdddcb639b9c1d4' 
  and client_id=0

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 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.02 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvcounter/jvcounter.php:123
9	plgSystemJVCounter->getSession()	JROOT/plugins/system/jvcounter/jvcounter.php:50
8	plgSystemJVCounter->saveData()	JROOT/plugins/system/jvcounter/jvcounter.php:24
7	plgSystemJVCounter->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.68 ms После последнего запроса: 0.07 ms Память запроса: 0.005 MB Память до запроса: 471.478 MB

INSERT INTO jpcxt_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl) 
  VALUES('c4fc73295a8548250cdddcb639b9c1d4','0','18.209.104.7','1563508454','1563508454','0','CCBot/2.0 (https://commoncrawl.org/faq/)','','')

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

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

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

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

Стек вызовов

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/jvcounter/jvcounter.php:95
8	plgSystemJVCounter->saveData()	JROOT/plugins/system/jvcounter/jvcounter.php:24
7	plgSystemJVCounter->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

4 × SELECT `rules` 
  FROM jpcxt_viewlevels

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`

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

2 × SELECT template 
  FROM jpcxt_template_styles as s

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

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 i.provider_id as id, i.
  order, i.params 
  FROM jpcxt_roksprocket_items as i

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 `data` 
  FROM `jpcxt_session`

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 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 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`

1 × SELECT c.id 
  FROM jpcxt_categories AS c

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  
  INNER JOIN jpcxt_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN jpcxt_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER 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 * 
  from jpcxt_jvcounter_log

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

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM jpcxt_fields AS a 
  LEFT JOIN `jpcxt_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jpcxt_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jpcxt_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jpcxt_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jpcxt_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jpcxt_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT `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 `session_id` 
  FROM `jpcxt_session`

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

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_languages
```

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 `enabled` 
  FROM `jpcxt_extensions`

1 × SELECT extension, file, type 
  FROM jpcxt_rokcommon_configs

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

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 id, rules 
  FROM `jpcxt_viewlevels

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

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

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

1 × SHOW FULL COLUMNS 
  FROM `jpcxt_extensions

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

1 × SHOW FULL COLUMNS 
  FROM `jpcxt_content

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('c4fc73295a8548250cdddcb639b9c1d4','0','18.209.104.7','1563508454','1563508454','0','CCBot/2.0 (https://commoncrawl.org/faq/)','',''