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

38 SQL-запросов зафиксировано 16.1 ms

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

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

2 повторов: #23 #32

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

SELECT `data`

  FROM `event_session`

  WHERE `session_id` = 'gj4h1l6suqd6pfld3dts4spfs6'

План 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.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
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/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.11 ms После последнего запроса: 1.48 ms Память запроса: 0.011 MB Память до запроса: 4.161 MB Выбрано строк: 0

SELECT `session_id`

  FROM `event_session`

  WHERE `session_id` = 'gj4h1l6suqd6pfld3dts4spfs6' 
  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.15 ms После последнего запроса: 0.10 ms Память запроса: 0.009 MB Память до запроса: 4.172 MB

INSERT INTO `event_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('gj4h1l6suqd6pfld3dts4spfs6', 0, '1714905714')

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

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

Профилирование 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.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/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.64 ms После последнего запроса: 2.29 ms Память запроса: 0.013 MB Память до запроса: 4.804 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.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.1 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.1 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: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.51 ms После последнего запроса: 0.84 ms Память запроса: 0.013 MB Память до запроса: 4.956 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 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.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.1 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/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.28 ms После последнего запроса: 0.43 ms Память запроса: 0.012 MB Память до запроса: 5.065 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 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.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/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.55 ms После последнего запроса: 0.15 ms Память запроса: 0.010 MB Память до запроса: 5.084 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.4 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.18 ms После последнего запроса: 0.32 ms Память запроса: 0.013 MB Память до запроса: 5.187 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.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: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.25 ms После последнего запроса: 13.30 ms Память запроса: 0.018 MB Память до запроса: 8.231 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.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: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.16 ms Память запроса: 0.018 MB Память до запроса: 8.250 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.30 ms После последнего запроса: 31.51 ms Память запроса: 0.021 MB Память до запроса: 14.148 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.2 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.2 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.20 ms После последнего запроса: 0.22 ms Память запроса: 0.023 MB Память до запроса: 14.188 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 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/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.86 ms После последнего запроса: 7.49 ms Память запроса: 0.019 MB Память до запроса: 15.036 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.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.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.32 ms После последнего запроса: 3.50 ms Память запроса: 0.021 MB Память до запроса: 16.109 MB Выбрано строк: 1

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

SELECT id 
  FROM event_zoo_item 
  WHERE alias = 'rixos-krasnaya-polyana-sochi' 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_zoo_item	NULL	const	ALIAS_INDEX	ALIAS_INDEX	767	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.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/administrator/components/com_zoo/framework/helpers/database.php:87

JROOT/administrator/components/com_zoo/helpers/alias.php:119

JROOT/media/zoo/applications/jbuniversal/framework/events/jbevent.application.php:83

JROOT/administrator/components/com_zoo/framework/classes/event.php:275

JROOT/components/com_zoo/router.php:354

JROOT/libraries/cms/component/router/legacy.php:106

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

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.50 ms После последнего запроса: 0.27 ms Память запроса: 0.016 MB Память до запроса: 16.136 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.2 ms
init	0.1 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.23 ms После последнего запроса: 15.91 ms Память запроса: 0.023 MB Память до запроса: 16.985 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.0 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.26 ms После последнего запроса: 0.21 ms Память запроса: 0.018 MB Память до запроса: 16.968 MB

UPDATE `event_extensions`

  SET `params` = '{\"mediaversion\":\"33be0ccbe900781da4801f15c66bc159\"}'

  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
Waiting for query cache lock	0.0 ms
end	0.1 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.07 ms После последнего запроса: 1.33 ms Память запроса: 0.026 MB Память до запроса: 17.323 MB Выбрано строк: 1

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

SELECT id 
  FROM event_zoo_item 
  WHERE alias = 'rixos-krasnaya-polyana-sochi' 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_zoo_item	NULL	const	ALIAS_INDEX	ALIAS_INDEX	767	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/administrator/components/com_zoo/framework/helpers/database.php:87

JROOT/administrator/components/com_zoo/helpers/alias.php:119

JROOT/media/zoo/applications/jbuniversal/framework/events/jbevent.application.php:83

JROOT/administrator/components/com_zoo/framework/classes/event.php:275

JROOT/components/com_zoo/router.php:354

JROOT/libraries/cms/component/router/legacy.php:106

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

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

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

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

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

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.17 ms После последнего запроса: 0.33 ms Память запроса: 0.024 MB Память до запроса: 17.365 MB Выбрано строк: 1

SELECT alias 
  FROM event_zoo_item 
  WHERE id = '252' 
  LIMIT 1

План 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,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
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:87

JROOT/administrator/components/com_zoo/helpers/alias.php:96

JROOT/components/com_zoo/router.php:112

JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

JROOT/libraries/joomla/application/route.php:64

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

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.44 ms После последнего запроса: 0.58 ms Память запроса: 0.010 MB Память до запроса: 17.438 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 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
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
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/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 для получения ссылок на файлы]

Время запроса: 3.20 ms После последнего запроса: 2.31 ms Память запроса: 0.016 MB Память до запроса: 18.041 MB Выбрано строк: 1

SELECT * 
  FROM event_zoo_item 
  WHERE id = 252

План 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,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
end	0.0 ms
query end	0.0 ms
closing tables	2.9 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/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/framework/classes/table.php:136

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

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.40 ms После последнего запроса: 0.60 ms Память запроса: 0.018 MB Память до запроса: 18.148 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/classes/item.php:326

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

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.42 ms После последнего запроса: 16.04 ms Память запроса: 0.022 MB Память до запроса: 21.025 MB Выбрано строк: 1

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

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 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.1 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:106

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.40 ms После последнего запроса: 0.51 ms Память запроса: 0.023 MB Память до запроса: 21.102 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.0 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.0 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:106

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 После последнего запроса: 2.47 ms Память запроса: 0.026 MB Память до запроса: 21.532 MB Выбрано строк: 16

SELECT * 
  FROM event_zoo_category 
  WHERE application_id = 1 
  AND published = 1 
  ORDER BY ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_zoo_category	NULL	ref	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	PUBLISHED_INDEX	1	const	15	93.75	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.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
Sorting result	0.0 ms
executing	0.0 ms
Sending data	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/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:232

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

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

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

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

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 После последнего запроса: 1.57 ms Память запроса: 0.019 MB Память до запроса: 21.775 MB

UPDATE event_zoo_item 
  SET hits = (hits + 1) 
  WHERE id = 252

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	event_zoo_item	NULL	range	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	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.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.1 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/item.php:185

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

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

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 После последнего запроса: 0.17 ms Память запроса: 0.021 MB Память до запроса: 21.796 MB Выбрано строк: 1

SELECT id 
  FROM event_users 
  WHERE id = 627

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_users	NULL	const	PRIMARY	PRIMARY	4	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.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:87

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

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

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

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.71 ms После последнего запроса: 1.64 ms Память запроса: 0.033 MB Память до запроса: 22.289 MB Выбрано строк: 16

SHOW FULL COLUMNS 
  FROM `event_users`

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

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

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

Status	Duration
starting	0.0 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
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/libraries/joomla/table/table.php:237

JROOT/libraries/joomla/table/table.php:158

JROOT/libraries/joomla/table/user.php:38

JROOT/libraries/joomla/table/table.php:301

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

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

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

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

JROOT/libraries/joomla/factory.php:246

JROOT/administrator/components/com_zoo/framework/classes/helper.php:69

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

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

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

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.25 ms После последнего запроса: 0.57 ms Память запроса: 0.027 MB Память до запроса: 22.395 MB Выбрано строк: 1

SELECT *

  FROM `event_users`

  WHERE `id` = 627

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_users	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 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/table/user.php:84

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

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

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

JROOT/libraries/joomla/factory.php:246

JROOT/administrator/components/com_zoo/framework/classes/helper.php:69

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

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

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

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.32 ms После последнего запроса: 2.42 ms Память запроса: 0.027 MB Память до запроса: 23.474 MB Выбрано строк: 1

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

  FROM `event_usergroups` AS g

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

  WHERE `m`.`user_id` = 627

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	stranarei2_event.m.group_id	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
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.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/table/user.php:109

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

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

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

JROOT/libraries/joomla/factory.php:246

JROOT/administrator/components/com_zoo/framework/classes/helper.php:69

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

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

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

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.19 ms После последнего запроса: 0.22 ms Память запроса: 0.024 MB Память до запроса: 23.496 MB Выбрано строк: 2

SELECT b.id

  FROM event_user_usergroup_map AS map

  LEFT JOIN event_usergroups AS a 
  ON a.id = map.group_id

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

  WHERE map.user_id = 627

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	map	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	stranarei2_event.map.group_id	1	100.00	NULL
1	SIMPLE	b	NULL	ALL	idx_usergroup_nested_set_lookup	Индекс не используется	NULL	NULL	8	100.00	Range checked for each record (index map: 0x10)

Профилирование 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
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/access/access.php:334

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

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

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

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

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

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

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.03 ms После последнего запроса: 0.11 ms Память запроса: 0.023 MB Память до запроса: 23.520 MB Выбрано строк: 1

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

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/administrator/components/com_zoo/classes/item.php:358

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

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.37 ms После последнего запроса: 5.46 ms Память запроса: 0.031 MB Память до запроса: 24.987 MB Выбрано строк: 4

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 = 'com_zoo.application.1.hotels')

  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	ALL	idx_lft_rgt	Индекс не используется	NULL	NULL	121	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.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.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 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.0 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:458

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

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

JROOT/administrator/components/com_zoo/classes/type.php:102

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

JROOT/media/zoo/applications/jbuniversal/templates/catalog/item.php:28

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

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

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

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.06 ms После последнего запроса: 4.56 ms Память запроса: 0.034 MB Память до запроса: 26.290 MB Выбрано строк: 138

SELECT id, title, module, position, content, showtitle, params, published 
  FROM event_modules AS m 
  LEFT JOIN event_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.access IN (1) 
  AND published = 1 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-05 10:41:54') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-05 10:41:54') 
  AND m.client_id = 0 
  ORDER BY position, ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	published	published	5	const,const	29	1.67	Using index condition; Using where; Используется filesort
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	stranarei2_event.m.id	3	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
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
Sorting result	0.0 ms
executing	0.0 ms
Sending data	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
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
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
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
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
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
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
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.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/administrator/components/com_zoo/framework/classes/helper.php:69

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

JROOT/administrator/components/com_zoo/helpers/module.php:57

JROOT/media/zoo/elements/joomlamodule/joomlamodule.php:27

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

JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/hotels/quickview.php:28

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/templates/catalog/item.php:37

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

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

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

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.20 ms После последнего запроса: 26.35 ms Память запроса: 0.020 MB Память до запроса: 29.279 MB Выбрано строк: 1

SELECT params 
  FROM event_extensions AS e 
  WHERE e.element='com_widgetkit'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	302	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.0 ms
cleaning up	0.0 ms

Стек вызовов

JROOT/administrator/components/com_widgetkit/helpers/system.php:278

JROOT/administrator/components/com_widgetkit/helpers/system.php:54

JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129

JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76

JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137

JROOT/administrator/components/com_widgetkit/widgetkit.php:17

JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20

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/site.php:196

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.17 ms После последнего запроса: 4.19 ms Память запроса: 0.016 MB Память до запроса: 29.302 MB Выбрано строк: 1

SELECT id,template 
  FROM event_template_styles 
  WHERE client_id=0 
  AND home=1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	event_template_styles	NULL	ALL	idx_home	Индекс не используется	NULL	NULL	7	14.29	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/administrator/components/com_widgetkit/helpers/system.php:78

JROOT/administrator/components/com_widgetkit/widgetkit.php:17

JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20

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/site.php:196

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.19 ms После последнего запроса: 0.26 ms Память запроса: 0.021 MB Память до запроса: 29.369 MB Выбрано строк: 1

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

  FROM event_extensions

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

План 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/libraries/cms/component/helper.php:91

JROOT/administrator/components/com_widgetkit/helpers/system.php:94

JROOT/administrator/components/com_widgetkit/widgetkit.php:17

JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20

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/site.php:196

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.41 ms После последнего запроса: 20.15 ms Память запроса: 0.003 MB Память до запроса: 32.043 MB

UPDATE `event_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714905714;s:18:\"session.timer.last\";i:1714905714;s:17:\"session.timer.now\";i:1714905714;s:24:\"session.client.forwarded\";s:12:\"18.225.11.98\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:10:\"superadmin\";N;}}'
	, `time` = '1714905714'

  WHERE `session_id` = 'gj4h1l6suqd6pfld3dts4spfs6'

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

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

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

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
init	0.0 ms
System lock	0.0 ms
updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	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/joomla/session/storage/database.php:85

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

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

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

6 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM event_extensions

```
2 × SELECT id 
  FROM event_zoo_item
```

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

2 × SELECT a.rules 
  FROM event_assets AS a

```
1 × SELECT id 
  FROM event_users
```

1 × SELECT * 
  FROM event_zoo_category

```
1 × SELECT * 
  FROM `event_users`
```

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

1 × SELECT id,template 
  FROM event_template_styles

1 × SELECT params 
  FROM event_extensions AS e

1 × SELECT id, title, module, position, content, showtitle, params, published 
  FROM event_modules AS m 
  LEFT JOIN event_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT b.id 
  FROM event_user_usergroup_map AS map 
  LEFT JOIN event_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN event_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT * 
  FROM event_zoo_application

```
1 × SELECT * 
  FROM event_languages
```

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

1 × SELECT id, rules 
  FROM `event_viewlevels

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

1 × SELECT `session_id` 
  FROM `event_session`

1 × SELECT CONCAT_WS(".", `
  group`, `key`) as group_key,   `value`,   `type` 
  FROM event_zoo_jbzoo_config 
  LIMIT 100

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

1 × SELECT `data` 
  FROM `event_session`

1 × SELECT alias 
  FROM event_zoo_item

1 × 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

```
1 × SELECT * 
  FROM event_zoo_item
```

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

1 × SHOW FULL COLUMNS 
  FROM `event_users

1 × UPDATE `event_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714905714;s:18:\"session.timer.last\";i:1714905714;s:17:\"session.timer.now\";i:1714905714;s:24:\"session.client.forwarded\";s:12:\"18.225.11.98\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:10:\"superadmin\";N;}}'  , `time` = '1714905714'

1 × UPDATE event_zoo_item 
  SET hits = (hits + 1)

1 × UPDATE `event_extensions` 
  SET `params` = '{\"mediaversion\":\"33be0ccbe900781da4801f15c66bc159\"}'

1 × 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

1 × INSERT INTO `event_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('gj4h1l6suqd6pfld3dts4spfs6', 0, '1714905714'

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

Сессия

__default

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

Время

Память

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

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

38 SQL-запросов зафиксировано 16.1 ms

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

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

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

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