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

Сессия

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

Время

Память

Время: 0.0 ms / 0.0 ms Память: 1.219 MB / 1.22 MB Application: afterLoad

Время: 65.6 ms / 65.6 ms Память: 13.457 MB / 14.68 MB Application: afterInitialise

Время: 21.9 ms / 87.5 ms Память: 2.077 MB / 16.75 MB Application: afterRoute

Время: 116.1 ms / 203.5 ms Память: 13.176 MB / 29.93 MB Application: afterDispatch

Время: 15.5 ms / 219.0 ms Память: 2.385 MB / 32.31 MB Application: beforeRenderModule mod_custom (Лого футер)

Время: 4.9 ms / 224.0 ms Память: 0.098 MB / 32.41 MB Application: afterRenderModule mod_custom (Лого футер)

Время: 0.1 ms / 224.1 ms Память: 0.000 MB / 32.41 MB Application: beforeRenderModule mod_menu (Заказать мероприятие)

Время: 4.6 ms / 228.7 ms Память: 0.130 MB / 32.54 MB Application: afterRenderModule mod_menu (Заказать мероприятие)

Время: 0.1 ms / 228.8 ms Память: 0.000 MB / 32.53 MB Application: beforeRenderModule mod_custom (Телефон в Сочи)

Время: 0.3 ms / 229.1 ms Память: 0.008 MB / 32.54 MB Application: afterRenderModule mod_custom (Телефон в Сочи)

Время: 0.1 ms / 229.2 ms Память: 0.000 MB / 32.54 MB Application: beforeRenderModule mod_custom (Меню в футере)

Время: 0.2 ms / 229.4 ms Память: 0.008 MB / 32.54 MB Application: afterRenderModule mod_custom (Меню в футере)

Время: 0.1 ms / 229.5 ms Память: 0.002 MB / 32.55 MB Application: beforeRenderModule mod_jbzoo_search (Подобрать конференц-залы)

Время: 35.5 ms / 264.9 ms Память: 1.605 MB / 34.15 MB Application: afterRenderModule mod_jbzoo_search (Подобрать конференц-залы)

Время: 0.2 ms / 265.1 ms Память: 0.000 MB / 34.01 MB Application: beforeRenderModule mod_zooitem (Отели для мероприятий)

Время: 88.0 ms / 353.2 ms Память: 2.633 MB / 36.65 MB Application: afterRenderModule mod_zooitem (Отели для мероприятий)

Время: 0.2 ms / 353.4 ms Память: 0.000 MB / 36.52 MB Application: beforeRenderModule mod_menu (Верхнее меню на страницах Площадки)

Время: 1.5 ms / 354.9 ms Память: 0.022 MB / 36.54 MB Application: afterRenderModule mod_menu (Верхнее меню на страницах Площадки)

Время: 0.1 ms / 355.1 ms Память: 0.000 MB / 36.53 MB Application: beforeRenderModule mod_custom (в Сочи:)

Время: 0.3 ms / 355.3 ms Память: 0.008 MB / 36.54 MB Application: afterRenderModule mod_custom (в Сочи:)

Время: 0.1 ms / 355.4 ms Память: 0.000 MB / 36.54 MB Application: beforeRenderModule mod_menu (Заказать мероприятие в шапке)

Время: 0.9 ms / 356.3 ms Память: 0.058 MB / 36.60 MB Application: afterRenderModule mod_menu (Заказать мероприятие в шапке)

Время: 60.2 ms / 416.6 ms Память: 3.135 MB / 39.73 MB Application: afterRender

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

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

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

95 SQL-запросов зафиксировано 36.1 ms

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

2 повторов: #47 #48

2 повторов: #49 #50

3 повторов: #78 #81 #87

2 повторов: #79 #82

Время запроса: 0.18 ms Память запроса: 0.014 MB Память до запроса: 3.930 MB Выбрано строк: 0

SELECT `data`

  FROM `event_session`

  WHERE `session_id` = 'unskbng1frsqrh2d85sfcm98c2'

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

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

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

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

Стек вызовов

JROOT/libraries/joomla/session/storage/database.php:46

JROOT/libraries/joomla/session/session.php:658

JROOT/libraries/joomla/session/session.php:596

JROOT/libraries/cms/application/cms.php:668

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:328

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:43

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

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

SELECT `session_id`

  FROM `event_session`

  WHERE `session_id` = 'unskbng1frsqrh2d85sfcm98c2' 
  LIMIT 0, 1

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

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

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

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

Стек вызовов

JROOT/libraries/cms/application/cms.php:175

JROOT/libraries/cms/application/cms.php:694

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:328

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:43

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

Время запроса: 0.25 ms После последнего запроса: 0.12 ms Память запроса: 0.009 MB Память до запроса: 4.170 MB

INSERT INTO `event_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('unskbng1frsqrh2d85sfcm98c2', 0, '1714139582')

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

EXPLAIN не доступен для запроса: INSERT INTO `event_session` (`session_id`, `client_id`, `time`) VALUES ('unskbng1frsqrh2d85sfcm98c2', 0, '1714139582')

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

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
update	0.1 ms
Waiting for query cache lock	0.0 ms
update	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/libraries/cms/application/cms.php:207

JROOT/libraries/cms/application/cms.php:694

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:328

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:43

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

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

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

  FROM event_extensions

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

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

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

Стек вызовов

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:570

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

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

SELECT b.id

  FROM event_usergroups AS a

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

  WHERE a.id = 1

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

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

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

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

Стек вызовов

JROOT/libraries/joomla/access/access.php:334

JROOT/libraries/joomla/access/access.php:403

JROOT/libraries/joomla/user/user.php:428

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:575

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.04 ms После последнего запроса: 0.40 ms Память запроса: 0.012 MB Память до запроса: 5.062 MB Выбрано строк: 4

SELECT id, rules

  FROM `event_viewlevels`

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

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

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

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

Стек вызовов

JROOT/libraries/joomla/access/access.php:420

JROOT/libraries/joomla/user/user.php:428

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:575

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.41 ms После последнего запроса: 0.17 ms Память запроса: 0.010 MB Память до запроса: 5.082 MB Выбрано строк: 60

SELECT folder AS type, element AS name, params

  FROM event_extensions

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

  ORDER BY ordering

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

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

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/libraries/cms/plugin/helper.php:312

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:575

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.15 ms После последнего запроса: 0.28 ms Память запроса: 0.013 MB Память до запроса: 5.184 MB Выбрано строк: 1

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

  FROM event_extensions

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

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

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

Стек вызовов

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:628

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

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

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

  FROM event_extensions

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

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

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

Стек вызовов

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/plugins/system/widgetkit_zoo/widgetkit_zoo.php:35

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:583

JROOT/libraries/cms/application/site.php:649

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

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

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

  FROM event_extensions

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

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

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

Стек вызовов

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/plugins/system/widgetkit_zoo/widgetkit_zoo.php:37

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:583

JROOT/libraries/cms/application/site.php:649

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.34 ms После последнего запроса: 29.03 ms Память запроса: 0.021 MB Память до запроса: 14.145 MB
```
CREATE TABLE IF NOT EXISTS `event_zoo_jbzoo_config` (`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
 `
  group` VARCHAR(50) NULL DEFAULT NULL,
 `key` VARCHAR(50) NULL DEFAULT NULL,
 `value` TEXT NULL,
 `type` VARCHAR(10) NULL DEFAULT 'string',
 PRIMARY KEY (`id`),
 UNIQUE INDEX `group_key` (`
  group`, `key`),
 INDEX `
  group` (`
  group`),
 INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM;
```
План SQL-запросов (Explain)
EXPLAIN не доступен для запроса: CREATE TABLE IF NOT EXISTS `event_zoo_jbzoo_config` (`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `group` VARCHAR(50) NULL DEFAULT NULL, `key` VARCHAR(50) NULL DEFAULT NULL, `value` TEXT NULL, `type` VARCHAR(10) NULL DEFAULT 'string', PRIMARY KEY (`id`), UNIQUE INDEX `group_key` (`group`, `key`), INDEX `group` (`group`), INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM;
Профилирование SQL-запросов
Status Duration
starting 0.1 ms
checking permissions 0.0 ms
Opening tables 0.1 ms
After create 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
cleaning up 0.0 ms
Стек вызовов
JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:289
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:182
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:54
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:41
JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:52
JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:40
JROOT/plugins/system/jbzoo/jbzoo.php:86
JROOT/plugins/system/jbzoo/jbzoo.php:115
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:46
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
After create	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

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

SELECT CONCAT_WS(".", `
  group`, `key`) as group_key, 
	`value`, 
	`type`

  FROM event_zoo_jbzoo_config

  LIMIT 1000

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

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

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

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

Стек вызовов

JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:154

JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106

JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:187

JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:55

JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:41

JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:52

JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:40

JROOT/plugins/system/jbzoo/jbzoo.php:86

JROOT/plugins/system/jbzoo/jbzoo.php:115

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:583

JROOT/libraries/cms/application/site.php:649

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.78 ms После последнего запроса: 6.92 ms Память запроса: 0.019 MB Память до запроса: 15.033 MB Выбрано строк: 36

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

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

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

  ORDER BY m.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	Индекс не используется	NULL	NULL	80	5.00	Using where; Используется filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	stranarei2_event.m.component_id	1	100.00	Using where

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
starting	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Creating sort index	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:353

JROOT/libraries/cms/application/site.php:279

JROOT/libraries/cms/router/site.php:218

JROOT/libraries/cms/router/router.php:408

JROOT/libraries/cms/router/router.php:192

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1018

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.40 ms После последнего запроса: 2.20 ms Память запроса: 0.016 MB Память до запроса: 15.555 MB Выбрано строк: 5

SELECT id, home, template, s.params

  FROM event_template_styles as s

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

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

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

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

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

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

Стек вызовов

JROOT/libraries/cms/application/site.php:486

JROOT/plugins/system/t3/includes/core/t3.php:308

JROOT/plugins/system/t3/t3.php:81

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

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

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

  FROM event_extensions

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

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

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

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

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

Стек вызовов

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/library/helper.php:156

JROOT/libraries/cms/library/helper.php:47

JROOT/libraries/cms/library/helper.php:90

JROOT/libraries/cms/version/version.php:179

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/sef/sef.php:30

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.19 ms После последнего запроса: 0.21 ms Память запроса: 0.017 MB Память до запроса: 16.386 MB

UPDATE `event_extensions`

  SET `params` = '{\"mediaversion\":\"6e314e7bec4f2e039559ed8fc0f2574d\"}'

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

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

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

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

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:230

JROOT/libraries/cms/version/version.php:189

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/sef/sef.php:30

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

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

SELECT *

  FROM event_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

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

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

Стек вызовов

JROOT/libraries/joomla/language/helper.php:166

JROOT/libraries/cms/application/site.php:336

JROOT/libraries/cms/application/site.php:135

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.36 ms После последнего запроса: 2.67 ms Память запроса: 0.017 MB Память до запроса: 17.515 MB Выбрано строк: 1

SELECT * 
  FROM event_zoo_application 
  WHERE id = 1

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

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

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

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

Стек вызовов

JROOT/administrator/components/com_zoo/framework/helpers/database.php:64

JROOT/administrator/components/com_zoo/framework/classes/table.php:397

JROOT/administrator/components/com_zoo/framework/classes/table.php:189

JROOT/administrator/components/com_zoo/tables/application.php:141

JROOT/administrator/components/com_zoo/framework/classes/table.php:136

JROOT/administrator/components/com_zoo/helpers/zoo.php:83

JROOT/components/com_zoo/zoo.php:32

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

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

SELECT a.rules

  FROM event_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

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

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

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

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

Стек вызовов

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/user/user.php:364

JROOT/administrator/components/com_zoo/framework/helpers/user.php:222

JROOT/administrator/components/com_zoo/framework/helpers/user.php:54

JROOT/components/com_zoo/controllers/default.php:214

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/administrator/components/com_zoo/framework/classes/app.php:253

JROOT/administrator/components/com_zoo/classes/application.php:294

JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1

JROOT/components/com_zoo/zoo.php:33

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

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

SELECT b.rules

  FROM event_assets AS a

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

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

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Используется filesort
1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	1	100.00	Using where

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.2 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/access/access.php:109

JROOT/libraries/joomla/user/user.php:373

JROOT/administrator/components/com_zoo/framework/helpers/user.php:222

JROOT/administrator/components/com_zoo/framework/helpers/user.php:54

JROOT/components/com_zoo/controllers/default.php:214

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/administrator/components/com_zoo/framework/classes/app.php:253

JROOT/administrator/components/com_zoo/classes/application.php:294

JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1

JROOT/components/com_zoo/zoo.php:33

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.06 ms После последнего запроса: 0.68 ms Память запроса: 0.020 MB Память до запроса: 20.741 MB
```
  SET SESSION group_concat_max_len = 1048576
```
План SQL-запросов (Explain)
EXPLAIN не доступен для запроса: SET SESSION group_concat_max_len = 1048576
Профилирование SQL-запросов
Status Duration
starting 0.0 ms
Opening tables 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
cleaning up 0.0 ms
Стек вызовов
JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
JROOT/administrator/components/com_zoo/tables/category.php:193
JROOT/administrator/components/com_zoo/classes/application.php:432
JROOT/administrator/components/com_zoo/classes/application.php:456
JROOT/components/com_zoo/controllers/default.php:214
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/administrator/components/com_zoo/framework/classes/app.php:253
JROOT/administrator/components/com_zoo/classes/application.php:294
JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
JROOT/components/com_zoo/zoo.php:33
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:46
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

Время запроса: 1.12 ms После последнего запроса: 0.14 ms Память запроса: 0.024 MB Память до запроса: 20.767 MB Выбрано строк: 16

SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM event_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN event_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN event_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-26 13:53:02') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-26 13:53:02') 
  WHERE c.application_id = 1 
  AND c.published = 1 
  GROUP BY c.id

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	PRIMARY,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	15	100.00	Using index condition
1	SIMPLE	ci	NULL	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	stranarei2_event.c.id	4	100.00	Using index
1	SIMPLE	i	NULL	ref	MULTI_INDEX2	MULTI_INDEX2	9	stranarei2_event.ci.item_id,const,const	1	100.00	Using where; Using index

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.3 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.5 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/administrator/components/com_zoo/framework/helpers/database.php:64

JROOT/administrator/components/com_zoo/framework/classes/table.php:423

JROOT/administrator/components/com_zoo/framework/classes/table.php:192

JROOT/administrator/components/com_zoo/framework/classes/table.php:165

JROOT/administrator/components/com_zoo/tables/category.php:219

JROOT/administrator/components/com_zoo/classes/application.php:432

JROOT/administrator/components/com_zoo/classes/application.php:456

JROOT/components/com_zoo/controllers/default.php:214

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/administrator/components/com_zoo/framework/classes/app.php:253

JROOT/administrator/components/com_zoo/classes/application.php:294

JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1

JROOT/components/com_zoo/zoo.php:33

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 3.84 ms После последнего запроса: 6.72 ms Память запроса: 0.020 MB Память до запроса: 22.311 MB Выбрано строк: 7

SELECT a.* 
  FROM event_zoo_item AS a 
  LEFT JOIN event_zoo_category_item AS b 
  ON a.id = b.item_id 
  LEFT JOIN event_zoo_search_index AS s 
  ON a.id = s.item_id 
  AND s.element_id IN ('_jbzoo_0_field__none', '_jbzoo_0_mode_s', '_jbzoo_0_order_asc') 
  WHERE a.application_id = 1 
  AND a.access IN (1) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 13:53:02') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 13:53:02') 
  AND b.category_id  = 31 
  GROUP BY a.id 
  ORDER BY a.priority DESC, s.value 
  LIMIT 63,21

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	90	100.00	Using where; Using temporary; Используется filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	stranarei2_event.b.item_id	1	28.08	Using where
1	SIMPLE	s	NULL	ref	PRIMARY	PRIMARY	4	stranarei2_event.b.item_id	30	100.00	Using where

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	3.0 ms
Creating sort index	0.2 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Creating sort index	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Creating sort index	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.1 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/administrator/components/com_zoo/framework/helpers/database.php:64

JROOT/administrator/components/com_zoo/framework/classes/table.php:423

JROOT/administrator/components/com_zoo/tables/item.php:475

JROOT/components/com_zoo/controllers/default.php:234

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/administrator/components/com_zoo/framework/classes/app.php:253

JROOT/administrator/components/com_zoo/classes/application.php:294

JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1

JROOT/components/com_zoo/zoo.php:33

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.43 ms После последнего запроса: 14.30 ms Память запроса: 0.041 MB Память до запроса: 26.003 MB Выбрано строк: 2

SELECT b.id 
  FROM event_zoo_category_item AS a JOIN event_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=73 
  AND b.published = 1 UNION SELECT 0 
  FROM event_zoo_category_item AS a 
  WHERE a.item_id=73 
  AND a.category_id = 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	stranarei2_event.a.category_id	1	93.75	Using where
2	UNION	a	NULL	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	100.00	Using index
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.2 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/administrator/components/com_zoo/framework/helpers/database.php:157

JROOT/administrator/components/com_zoo/helpers/category.php:63

JROOT/administrator/components/com_zoo/classes/item.php:561

JROOT/administrator/components/com_zoo/helpers/route.php:298

JROOT/media/zoo/applications/jbuniversal/elements/jbimage/jbimage.php:122

JROOT/media/zoo/applications/jbuniversal/elements/jbimage/jbimage.php:187

JROOT/components/com_zoo/renderer/element/default.php:19

JROOT/administrator/components/com_zoo/helpers/renderer.php:155

JROOT/administrator/components/com_zoo/classes/renderer/item.php:186

JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/conference/teaser.php:25

JROOT/administrator/components/com_zoo/helpers/renderer.php:155

JROOT/administrator/components/com_zoo/classes/renderer/item.php:65

JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327

JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257

JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23

JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158

JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:68

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_zoo/controllers/default.php:321

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/administrator/components/com_zoo/framework/classes/app.php:253

JROOT/administrator/components/com_zoo/classes/application.php:294

JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1

JROOT/components/com_zoo/zoo.php:33

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.28 ms После последнего запроса: 2.80 ms Память запроса: 0.037 MB Память до запроса: 26.371 MB Выбрано строк: 1

SELECT * 
  FROM event_zoo_item 
  WHERE id IN (108) 
  AND state = 1 
  AND access IN (1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-26 13:53:02') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-26 13:53:02') 
  ORDER BY FIELD(id,108)

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_zoo_item	NULL	const	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1	100.00	NULL

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

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

Стек вызовов

JROOT/administrator/components/com_zoo/framework/helpers/database.php:64

JROOT/administrator/components/com_zoo/framework/classes/table.php:423

JROOT/administrator/components/com_zoo/framework/classes/table.php:192

JROOT/administrator/components/com_zoo/framework/classes/table.php:165

JROOT/media/zoo/elements/relateditems/relateditems.php:178

JROOT/media/zoo/elements/relateditems/relateditems.php:28

JROOT/administrator/components/com_zoo/classes/renderer/item.php:170

JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/conference/teaser.php:37

JROOT/administrator/components/com_zoo/helpers/renderer.php:155

JROOT/administrator/components/com_zoo/classes/renderer/item.php:65

JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327

JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257

JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23

JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158

JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:68

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_zoo/controllers/default.php:321

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/administrator/components/com_zoo/framework/classes/app.php:253

JROOT/administrator/components/com_zoo/classes/application.php:294

JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1

JROOT/components/com_zoo/zoo.php:33

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:46

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

Время запроса: 0.38 ms После последнего запроса: 1.46 ms Память запроса: 0.040 MB Память до запроса: 26.580 MB Выбрано строк: 2

SELECT b.id 
  FROM event_zoo_category_item AS a JOIN event_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=108 
  AND b.published = 1 UNION SELECT 0 
  FROM event_zoo_category_item AS a 
  WHERE a.item_id=108 
  AND a.category_id = 0

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	2	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	stranarei2_event.a.category_id	1	93.75	Using where
2	UNION	a	NULL	const	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,const	1	100.00	Using index
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

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

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

Стек вызовов

JROOT/administrator/components/com_zoo/framework/helpers/database.php:157

JROOT/administrator/components/com_zoo/helpers/category.php:63

JROOT/administrator/components/com_zoo/classes/item.php:561

JROOT/administrator/components/com_zoo/helpers/route.php:298

JROOT/media/zoo/elements/relateditems/relateditems.php:64

JROOT/components/com_zoo/renderer/element/list.php:25