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

39 SQL-запросов зафиксировано 10.5 ms

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

2 повторов: #15 #19

2 повторов: #24 #33

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

SELECT `data`

  FROM `event_session`

  WHERE `session_id` = '1diabu4t5b60mngq2hiaor9fl6'

План 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.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
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.24 ms После последнего запроса: 1.66 ms Память запроса: 0.008 MB Память до запроса: 4.160 MB

DELETE 

  FROM `event_session`

  WHERE `time` < '1713995693'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	event_session	NULL	range	time	time	45	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.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:685

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

SELECT `session_id`

  FROM `event_session`

  WHERE `session_id` = '1diabu4t5b60mngq2hiaor9fl6' 
  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.1 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.187 MB

INSERT INTO `event_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('1diabu4t5b60mngq2hiaor9fl6', 0, '1713996593')

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

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

Профилирование 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.0 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.38 ms После последнего запроса: 2.33 ms Память запроса: 0.013 MB Память до запроса: 4.812 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.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/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.05 ms После последнего запроса: 0.85 ms Память запроса: 0.013 MB Память до запроса: 4.965 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.05 ms После последнего запроса: 0.43 ms Память запроса: 0.012 MB Память до запроса: 5.073 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.47 ms После последнего запроса: 0.15 ms Память запроса: 0.010 MB Память до запроса: 5.093 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.3 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.32 ms Память запроса: 0.013 MB Память до запроса: 5.195 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.16 ms После последнего запроса: 13.20 ms Память запроса: 0.018 MB Память до запроса: 8.240 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.13 ms После последнего запроса: 0.16 ms Память запроса: 0.018 MB Память до запроса: 8.259 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.35 ms После последнего запроса: 30.86 ms Память запроса: 0.021 MB Память до запроса: 14.157 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.05 ms После последнего запроса: 0.21 ms Память запроса: 0.023 MB Память до запроса: 14.197 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.76 ms После последнего запроса: 7.36 ms Память запроса: 0.019 MB Память до запроса: 15.044 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.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.43 ms Память запроса: 0.021 MB Память до запроса: 16.117 MB Выбрано строк: 1

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

SELECT id 
  FROM event_zoo_item 
  WHERE alias = 'mercure-rosa-khutor' 
  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.38 ms После последнего запроса: 0.25 ms Память запроса: 0.016 MB Память до запроса: 16.145 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.19 ms После последнего запроса: 15.53 ms Память запроса: 0.023 MB Память до запроса: 16.994 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.39 ms После последнего запроса: 0.20 ms Память запроса: 0.017 MB Память до запроса: 16.977 MB

UPDATE `event_extensions`

  SET `params` = '{\"mediaversion\":\"37f7ed9b8602287c00db529510f7233a\"}'

  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.2 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.04 ms После последнего запроса: 1.22 ms Память запроса: 0.026 MB Память до запроса: 17.332 MB Выбрано строк: 1

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

SELECT id 
  FROM event_zoo_item 
  WHERE alias = 'mercure-rosa-khutor' 
  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.14 ms После последнего запроса: 0.31 ms Память запроса: 0.024 MB Память до запроса: 17.374 MB Выбрано строк: 1

SELECT alias 
  FROM event_zoo_item 
  WHERE id = '97' 
  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.04 ms После последнего запроса: 0.54 ms Память запроса: 0.010 MB Память до запроса: 17.447 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.28 ms После последнего запроса: 2.22 ms Память запроса: 0.016 MB Память до запроса: 18.050 MB Выбрано строк: 1

SELECT * 
  FROM event_zoo_item 
  WHERE id = 97

План 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.1 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: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.14 ms После последнего запроса: 1.14 ms Память запроса: 0.018 MB Память до запроса: 18.197 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 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: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.07 ms После последнего запроса: 15.53 ms Память запроса: 0.022 MB Память до запроса: 21.074 MB Выбрано строк: 1

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

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: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.04 ms После последнего запроса: 0.50 ms Память запроса: 0.023 MB Память до запроса: 21.151 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 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: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.06 ms После последнего запроса: 2.41 ms Память запроса: 0.026 MB Память до запроса: 21.581 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 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: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.44 ms После последнего запроса: 1.40 ms Память запроса: 0.019 MB Память до запроса: 21.824 MB

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

План 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.2 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.04 ms После последнего запроса: 0.09 ms Память запроса: 0.021 MB Память до запроса: 21.845 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 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/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.64 ms После последнего запроса: 1.54 ms Память запроса: 0.033 MB Память до запроса: 22.338 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.1 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.2 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.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 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.04 ms После последнего запроса: 0.49 ms Память запроса: 0.027 MB Память до запроса: 22.444 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 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/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.04 ms После последнего запроса: 2.35 ms Память запроса: 0.027 MB Память до запроса: 23.523 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 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/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.04 ms После последнего запроса: 0.19 ms Память запроса: 0.024 MB Память до запроса: 23.545 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 privileges on cached	0.0 ms
checking permissions	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/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.04 ms После последнего запроса: 0.10 ms Память запроса: 0.023 MB Память до запроса: 23.570 MB Выбрано строк: 1

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

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.67 ms После последнего запроса: 5.62 ms Память запроса: 0.030 MB Память до запроса: 25.037 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.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
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.83 ms После последнего запроса: 4.62 ms Память запроса: 0.034 MB Память до запроса: 26.339 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-04-24 22:09:53') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-24 22:09:53') 
  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.6 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.4 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
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
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/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.28 ms После последнего запроса: 25.26 ms Память запроса: 0.021 MB Память до запроса: 29.328 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.11 ms После последнего запроса: 3.95 ms Память запроса: 0.016 MB Память до запроса: 29.351 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 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_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.21 ms После последнего запроса: 0.23 ms Память запроса: 0.021 MB Память до запроса: 29.418 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.51 ms После последнего запроса: 19.71 ms Память запроса: 0.003 MB Память до запроса: 32.093 MB

UPDATE `event_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713996593;s:18:\"session.timer.last\";i:1713996593;s:17:\"session.timer.now\";i:1713996593;s:24:\"session.client.forwarded\";s:11:\"3.16.212.99\";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` = '1713996593'

  WHERE `session_id` = '1diabu4t5b60mngq2hiaor9fl6'

План 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.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.2 ms
end	0.0 ms
Waiting for query cache lock	0.1 ms
end	0.0 ms
query end	0.1 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 для получения ссылок на файлы]

31 типов 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:1713996593;s:18:\"session.timer.last\";i:1713996593;s:17:\"session.timer.now\";i:1713996593;s:24:\"session.client.forwarded\";s:11:\"3.16.212.99\";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` = '1713996593'

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

1 × UPDATE `event_extensions` 
  SET `params` = '{\"mediaversion\":\"37f7ed9b8602287c00db529510f7233a\"}'

1 × INSERT INTO `event_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('1diabu4t5b60mngq2hiaor9fl6', 0, '1713996593'

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 × DELETE  
  FROM `event_session`
```

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

Сессия

__default

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

Время

Память

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

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

39 SQL-запросов зафиксировано 10.5 ms

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

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

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

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