Время запроса: 0.30 ms Память запроса: 0.014 MB Память до запроса: 3.930 MB Выбрано строк: 0
SELECT `data`
FROM `event_session`
WHERE `session_id` = 'vt0kjhj7d2gkgrsk75olb971p7'
| 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 |
| 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
Время запроса: 0.28 ms После последнего запроса: 1.70 ms Память запроса: 0.008 MB Память до запроса: 4.158 MB
DELETE
FROM `event_session`
WHERE `time` < '1713875981'
| 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 |
| 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
Время запроса: 0.21 ms После последнего запроса: 0.12 ms Память запроса: 0.011 MB Память до запроса: 4.173 MB Выбрано строк: 0
SELECT `session_id`
FROM `event_session`
WHERE `session_id` = 'vt0kjhj7d2gkgrsk75olb971p7'
LIMIT 0, 1
| 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 |
| 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
Время запроса: 0.13 ms После последнего запроса: 0.11 ms Память запроса: 0.009 MB Память до запроса: 4.185 MB
INSERT INTO `event_session`
(`session_id`, `client_id`, `time`)
VALUES
('vt0kjhj7d2gkgrsk75olb971p7', 0, '1713876881')
EXPLAIN не доступен для запроса: INSERT INTO `event_session`
(`session_id`, `client_id`, `time`) VALUES
('vt0kjhj7d2gkgrsk75olb971p7', 0, '1713876881')
| 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
Время запроса: 0.47 ms После последнего запроса: 2.33 ms Память запроса: 0.013 MB Память до запроса: 4.810 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
| 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 |
| 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
Время запроса: 0.36 ms После последнего запроса: 0.87 ms Память запроса: 0.013 MB Память до запроса: 4.963 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
| 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 |
| 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.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/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
Время запроса: 0.27 ms После последнего запроса: 0.44 ms Память запроса: 0.012 MB Память до запроса: 5.071 MB Выбрано строк: 4
SELECT id, rules
FROM `event_viewlevels`
| 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 |
| 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
Время запроса: 0.42 ms После последнего запроса: 0.16 ms Память запроса: 0.010 MB Память до запроса: 5.090 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
| 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 |
| Status | Duration |
|---|
| starting | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.2 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:46
Время запроса: 0.17 ms После последнего запроса: 0.32 ms Память запроса: 0.013 MB Память до запроса: 5.193 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
| 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 |
| 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
Время запроса: 0.27 ms После последнего запроса: 13.32 ms Память запроса: 0.018 MB Память до запроса: 8.236 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
WHERE `type` = 'component'
AND `element` = 'com_widgetkit'
| 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 |
| 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
Время запроса: 1.29 ms После последнего запроса: 0.17 ms Память запроса: 0.018 MB Память до запроса: 8.256 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
WHERE `type` = 'component'
AND `element` = 'com_zoo'
| 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 |
| Status | Duration |
|---|
| starting | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 1.1 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
Время запроса: 0.29 ms После последнего запроса: 31.73 ms Память запроса: 0.021 MB Память до запроса: 14.152 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;
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;
| 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
Время запроса: 0.27 ms После последнего запроса: 0.26 ms Память запроса: 0.023 MB Память до запроса: 14.193 MB Выбрано строк: 39
SELECT CONCAT_WS(".", `
group`, `key`) as group_key,
`value`,
`type`
FROM event_zoo_jbzoo_config
LIMIT 1000| 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 |
| 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.1 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
Время запроса: 0.96 ms После последнего запроса: 7.76 ms Память запроса: 0.019 MB Память до запроса: 15.040 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
| 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 |
| 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.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.2 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.1 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
Время запроса: 0.61 ms После последнего запроса: 3.63 ms Память запроса: 0.021 MB Память до запроса: 16.113 MB Выбрано строк: 1
Повторяющиеся запросы:
#19SELECT id
FROM event_zoo_item
WHERE alias = 'malyj-ahun-pacha'
LIMIT 1
| 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 |
| 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.3 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
Время запроса: 0.42 ms После последнего запроса: 0.32 ms Память запроса: 0.016 MB Память до запроса: 16.141 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
| 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 |
| 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
Время запроса: 0.25 ms После последнего запроса: 16.07 ms Память запроса: 0.023 MB Память до запроса: 16.989 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| 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 |
| 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.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/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
Время запроса: 0.38 ms После последнего запроса: 0.25 ms Память запроса: 0.017 MB Память до запроса: 16.972 MB
UPDATE `event_extensions`
SET `params` = '{\"mediaversion\":\"a2ff03b2bdcc196bdc82a514c9e5dd49\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| 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 |
| 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/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
Время запроса: 0.04 ms После последнего запроса: 1.38 ms Память запроса: 0.026 MB Память до запроса: 17.327 MB Выбрано строк: 1
Повторяющиеся запросы:
#15SELECT id
FROM event_zoo_item
WHERE alias = 'malyj-ahun-pacha'
LIMIT 1
| 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 |
| 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
Время запроса: 0.15 ms После последнего запроса: 0.34 ms Память запроса: 0.024 MB Память до запроса: 17.369 MB Выбрано строк: 1
SELECT alias
FROM event_zoo_item
WHERE id = '141'
LIMIT 1
| 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 |
| 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
Время запроса: 0.37 ms После последнего запроса: 0.60 ms Память запроса: 0.010 MB Память до запроса: 17.442 MB Выбрано строк: 1
SELECT *
FROM event_languages
WHERE published=1
ORDER BY ordering ASC
| 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 |
| 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
Время запроса: 0.16 ms После последнего запроса: 2.30 ms Память запроса: 0.016 MB Память до запроса: 18.046 MB Выбрано строк: 1
SELECT *
FROM event_zoo_item
WHERE id = 141
| 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 |
| 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: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
Время запроса: 0.19 ms После последнего запроса: 0.52 ms Память запроса: 0.018 MB Память до запроса: 18.141 MB Выбрано строк: 1
SELECT *
FROM event_zoo_application
WHERE id = 1
| 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 |
| 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/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
Время запроса: 0.40 ms После последнего запроса: 16.05 ms Память запроса: 0.022 MB Память до запроса: 21.018 MB Выбрано строк: 1
Повторяющиеся запросы:
#33SELECT a.rules
FROM event_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| 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 |
| 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/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
Время запроса: 0.33 ms После последнего запроса: 0.56 ms Память запроса: 0.023 MB Память до запроса: 21.096 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
| 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 |
| 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
Время запроса: 0.37 ms После последнего запроса: 2.55 ms Память запроса: 0.026 MB Память до запроса: 21.526 MB Выбрано строк: 16
SELECT *
FROM event_zoo_category
WHERE application_id = 1
AND published = 1
ORDER BY ordering
| 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 |
| 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.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.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: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
Время запроса: 0.17 ms После последнего запроса: 1.48 ms Память запроса: 0.019 MB Память до запроса: 21.769 MB
UPDATE event_zoo_item
SET hits = (hits + 1)
WHERE id = 141
| 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 |
| 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.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
JROOT/administrator/components/com_zoo/tables/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
Время запроса: 0.26 ms После последнего запроса: 0.10 ms Память запроса: 0.021 MB Память до запроса: 21.790 MB Выбрано строк: 1
SELECT id
FROM event_users
WHERE id = 627
| 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 |
| 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/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
Время запроса: 0.36 ms После последнего запроса: 1.54 ms Память запроса: 0.033 MB Память до запроса: 22.283 MB Выбрано строк: 16
SHOW FULL COLUMNS
FROM `event_users`
EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `event_users`
| 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.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.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
Время запроса: 0.13 ms После последнего запроса: 0.52 ms Память запроса: 0.027 MB Память до запроса: 22.389 MB Выбрано строк: 1
SELECT *
FROM `event_users`
WHERE `id` = 627
| 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 |
| 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
Время запроса: 0.52 ms После последнего запроса: 2.37 ms Память запроса: 0.027 MB Память до запроса: 23.468 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
| 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 |
| 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.2 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
Время запроса: 0.19 ms После последнего запроса: 0.20 ms Память запроса: 0.024 MB Память до запроса: 23.490 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
| 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) |
| 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
Время запроса: 0.04 ms После последнего запроса: 0.11 ms Память запроса: 0.023 MB Память до запроса: 23.514 MB Выбрано строк: 1
Повторяющиеся запросы:
#24SELECT a.rules
FROM event_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| 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 |
| 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
Время запроса: 0.38 ms После последнего запроса: 5.35 ms Память запроса: 0.030 MB Память до запроса: 24.981 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.restaraunts')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
| 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 |
| 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.0 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
Время запроса: 0.55 ms После последнего запроса: 4.29 ms Память запроса: 0.033 MB Память до запроса: 26.198 MB Выбрано строк: 2
SELECT b.id
FROM event_zoo_category_item AS a JOIN event_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=141
AND b.published = 1 UNION SELECT 0
FROM event_zoo_category_item AS a
WHERE a.item_id=141
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 2 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | stranarei2_event.a.category_id | 1 | 93.75 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | Using temporary |
| 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.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 |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
JROOT/administrator/components/com_zoo/helpers/category.php:63
JROOT/administrator/components/com_zoo/classes/item.php:561
JROOT/administrator/components/com_zoo/classes/item.php:545
JROOT/media/zoo/elements/itemcategory/itemcategory.php:28
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.php:12
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:41
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
Время запроса: 0.36 ms После последнего запроса: 48.99 ms Память запроса: 0.033 MB Память до запроса: 26.941 MB Выбрано строк: 1
SELECT *
FROM event_zoo_item
WHERE id IN (160)
AND state = 1
AND access IN (1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-23 12:54:41')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-23 12:54:41')
ORDER BY FIELD(id,160)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_zoo_item | NULL | const | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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 |
| 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 | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
JROOT/administrator/components/com_zoo/framework/classes/table.php:423
JROOT/administrator/components/com_zoo/framework/classes/table.php:192
JROOT/administrator/components/com_zoo/framework/classes/table.php:165
JROOT/media/zoo/elements/relateditems/relateditems.php:178
JROOT/media/zoo/elements/relateditems/relateditems.php:28
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.php:25
JROOT/administrator/components/com_zoo/helpers/renderer.php:155
JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
JROOT/media/zoo/applications/jbuniversal/templates/catalog/item.php:41
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
Время запроса: 0.43 ms После последнего запроса: 27.85 ms Память запроса: 0.039 MB Память до запроса: 30.019 MB Выбрано строк: 0
SELECT name
FROM event_zoo_tag
WHERE item_id = 141
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_zoo_tag | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 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:157
JROOT/administrator/components/com_zoo/tables/tag.php:93
JROOT/administrator/components/com_zoo/classes/item.php:627
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:291
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:50
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 0.38 ms После последнего запроса: 3.67 ms Память запроса: 0.047 MB Память до запроса: 30.773 MB Выбрано строк: 1
SELECT params
FROM event_extensions AS e
WHERE e.element='com_widgetkit'
| 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 |
| Status | Duration |
|---|
| starting | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.1 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_zoo/elements/widgetkit/widgetkit.php:21
JROOT/administrator/components/com_zoo/helpers/element.php:82
JROOT/administrator/components/com_zoo/classes/type.php:191
JROOT/administrator/components/com_zoo/classes/type.php:279
JROOT/administrator/components/com_zoo/classes/type.php:243
JROOT/administrator/components/com_zoo/classes/item.php:500
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:294
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:50
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 0.23 ms После последнего запроса: 5.01 ms Память запроса: 0.042 MB Память до запроса: 30.822 MB Выбрано строк: 1
SELECT id,template
FROM event_template_styles
WHERE client_id=0
AND home=1
| 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 |
| 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_zoo/elements/widgetkit/widgetkit.php:21
JROOT/administrator/components/com_zoo/helpers/element.php:82
JROOT/administrator/components/com_zoo/classes/type.php:191
JROOT/administrator/components/com_zoo/classes/type.php:279
JROOT/administrator/components/com_zoo/classes/type.php:243
JROOT/administrator/components/com_zoo/classes/item.php:500
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:294
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:50
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 0.23 ms После последнего запроса: 0.33 ms Память запроса: 0.047 MB Память до запроса: 30.914 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
| 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 |
| 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_zoo/elements/widgetkit/widgetkit.php:21
JROOT/administrator/components/com_zoo/helpers/element.php:82
JROOT/administrator/components/com_zoo/classes/type.php:191
JROOT/administrator/components/com_zoo/classes/type.php:279
JROOT/administrator/components/com_zoo/classes/type.php:243
JROOT/administrator/components/com_zoo/classes/item.php:500
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:294
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:50
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 0.63 ms После последнего запроса: 12.00 ms Память запроса: 0.037 MB Память до запроса: 32.567 MB Выбрано строк: 121
SHOW TABLES
EXPLAIN не доступен для запроса: SHOW TABLES
| 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 |
| checking permissions | 0.4 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/administrator/components/com_zoo/framework/helpers/database.php:157
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:61
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:87
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:568
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:82
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:51
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 0.82 ms После последнего запроса: 0.24 ms Память запроса: 0.034 MB Память до запроса: 32.616 MB Выбрано строк: 41
DESCRIBE event_zoo_jbzoo_index_restaraunts
EXPLAIN не доступен для запроса: DESCRIBE event_zoo_jbzoo_index_restaraunts
| 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.3 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 |
| 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 |
| 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.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:202
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:569
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:82
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:51
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 1.45 ms После последнего запроса: 0.66 ms Память запроса: 0.032 MB Память до запроса: 32.685 MB Выбрано строк: 4
SELECT tAll.id ,
COUNT(tAll.id) AS count
FROM ((
SELECT tItem.id AS id
FROM event_zoo_item AS tItem
LEFT JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.id <> '141'
AND tItem.application_id = '1'
AND ((tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s LIKE '%Сочи,%'
AND tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s LIKE '%Хостинский%'
AND tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s LIKE '%район%' ))
) UNION ALL (
SELECT tItem.id AS id
FROM event_zoo_item AS tItem
LEFT JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.id <> '141'
AND tItem.application_id = '1'
AND ((tIndex.e_79398748495541588b3173c826eea74e_s LIKE '%до%'
AND tIndex.e_79398748495541588b3173c826eea74e_s LIKE '%200%'
AND tIndex.e_79398748495541588b3173c826eea74e_s LIKE '%человек%' ))
)) AS tAll
GROUP BY tAll.id
ORDER BY count DESC
LIMIT 4
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | <derived2> | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 4 | 100.00 | Using temporary; Используется filesort |
| 2 | DERIVED | tIndex | NULL | ALL | item_id | Индекс не используется | NULL | NULL | 143 | 0.70 | Using where |
| 2 | DERIVED | tItem | NULL | eq_ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | stranarei2_event.tIndex.item_id | 1 | 28.08 | Using index condition; Using where |
| 3 | UNION | tIndex | NULL | ALL | item_id | Индекс не используется | NULL | NULL | 143 | 0.70 | Using where |
| 3 | UNION | tItem | NULL | eq_ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | stranarei2_event.tIndex.item_id | 1 | 28.08 | Using index condition; Using where |
| 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 |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 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 |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 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 |
| executing | 0.0 ms |
| Sending data | 0.2 ms |
| executing | 0.0 ms |
| Sending data | 0.3 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 |
| removing tmp table | 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 |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.1 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.related.php:195
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:51
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 0.51 ms После последнего запроса: 0.50 ms Память запроса: 0.036 MB Память до запроса: 32.746 MB Выбрано строк: 4
SELECT *
FROM event_zoo_item
WHERE id IN (142,143,150,289)
ORDER BY priority DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_zoo_item | NULL | range | PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | NULL | 4 | 100.00 | Using index condition; Используется filesort |
| 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.2 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.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 |
| 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/administrator/components/com_zoo/framework/helpers/database.php:64
JROOT/administrator/components/com_zoo/framework/classes/table.php:423
JROOT/administrator/components/com_zoo/framework/classes/table.php:192
JROOT/administrator/components/com_zoo/framework/classes/table.php:165
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:221
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.related.php:61
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:64
JROOT/media/zoo/applications/jbuniversal/elements/jbrelatedauto/jbrelatedauto.php:36
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.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:41
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
Время запроса: 2.91 ms После последнего запроса: 326.34 ms Память запроса: 0.033 MB Память до запроса: 34.041 MB Выбрано строк: 1
SELECT ROWNUM
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM event_zoo_item AS a
LEFT JOIN event_zoo_category_item AS b
ON a.id = b.item_id
LEFT JOIN event_zoo_search_index AS s
ON a.id = s.item_id
AND s.element_id IN ('_jbzoo_0_field__none', '_jbzoo_0_mode_s', '_jbzoo_0_order_asc')
WHERE a.application_id = 1
AND b.category_id = 33
AND a.access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 12:54:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 12:54:41')
GROUP BY a.id
ORDER BY a.priority DESC, s.value) t1) t2
WHERE id = 141
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | const | 10 | 100.00 | NULL |
| 2 | DERIVED | <derived3> | NULL | system | NULL | Индекс не используется | NULL | NULL | 1 | 100.00 | NULL |
| 2 | DERIVED | <derived4> | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 480 | 100.00 | NULL |
| 4 | DERIVED | b | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 4 | const | 57 | 100.00 | Using where; Using index; Using temporary; Используется filesort |
| 4 | DERIVED | a | NULL | eq_ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | stranarei2_event.b.item_id | 1 | 28.08 | Using where |
| 4 | DERIVED | s | NULL | ref | PRIMARY | PRIMARY | 4 | stranarei2_event.b.item_id | 30 | 100.00 | Using where |
| 3 | DERIVED | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | No tables used |
| 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 |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| executing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 1.9 ms |
| Creating sort index | 0.1 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 |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 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/administrator/components/com_zoo/framework/helpers/database.php:87
JROOT/administrator/components/com_zoo/framework/classes/table.php:380
JROOT/administrator/components/com_zoo/tables/item.php:521
JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:28
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.php:52
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:41
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
Время запроса: 2.51 ms После последнего запроса: 0.17 ms Память запроса: 0.032 MB Память до запроса: 34.075 MB Выбрано строк: 2
SELECT ROWNUM, id
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM event_zoo_item AS a
LEFT JOIN event_zoo_category_item AS b
ON a.id = b.item_id
LEFT JOIN event_zoo_search_index AS s
ON a.id = s.item_id
AND s.element_id IN ('_jbzoo_0_field__none', '_jbzoo_0_mode_s', '_jbzoo_0_order_asc')
WHERE a.application_id = 1
AND b.category_id = 33
AND a.access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 12:54:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 12:54:41')
GROUP BY a.id
ORDER BY a.priority DESC, s.value) t1) t2
WHERE ROWNUM = 9 OR ROWNUM = 11
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | <derived2> | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 480 | 19.00 | Using where |
| 2 | DERIVED | <derived3> | NULL | system | NULL | Индекс не используется | NULL | NULL | 1 | 100.00 | NULL |
| 2 | DERIVED | <derived4> | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 480 | 100.00 | NULL |
| 4 | DERIVED | b | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 4 | const | 57 | 100.00 | Using where; Using index; Using temporary; Используется filesort |
| 4 | DERIVED | a | NULL | eq_ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | stranarei2_event.b.item_id | 1 | 28.08 | Using where |
| 4 | DERIVED | s | NULL | ref | PRIMARY | PRIMARY | 4 | stranarei2_event.b.item_id | 30 | 100.00 | Using where |
| 3 | DERIVED | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | No tables used |
| 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 |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| executing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 1.7 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.1 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 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/administrator/components/com_zoo/framework/helpers/database.php:134
JROOT/administrator/components/com_zoo/tables/item.php:544
JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:28
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.php:52
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:41
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
Время запроса: 0.23 ms После последнего запроса: 0.10 ms Память запроса: 0.034 MB Память до запроса: 34.110 MB Выбрано строк: 1
SELECT *
FROM event_zoo_item
WHERE id = 139
| 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 |
| 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: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/tables/item.php:549
JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:28
JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/restaraunts/full.php:52
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:41
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
Время запроса: 41.79 ms После последнего запроса: 17.54 ms Память запроса: 0.022 MB Память до запроса: 35.314 MB Выбрано строк: 27
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM event_modules AS m
LEFT JOIN event_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN event_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.client_id = 0
AND m.access IN (1,1)
ORDER BY m.ordering, m.id
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | published,newsfeeds | Индекс не используется | NULL | NULL | 60 | 4.83 | Using where; Используется filesort |
| 1 | SIMPLE | am | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stranarei2_event.m.id | 1 | 100.00 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | stranarei2_event.m.module,const | 1 | 10.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 39.8 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.5 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.1 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 |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 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.1 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.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.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.1 ms |
| cleaning up | 0.0 ms |
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:455
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:102
JROOT/libraries/joomla/document/html/html.php:510
JROOT/plugins/system/t3/includes/core/template.php:627
JROOT/templates/event-sochi/tpls/blocks/header.php:22
JROOT/plugins/system/t3/includes/core/template.php:195
JROOT/templates/event-sochi/tpls/default-content-left.php:32
JROOT/plugins/system/t3/includes/core/template.php:219
JROOT/templates/event-sochi/index.php:34
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.21 ms После последнего запроса: 1.27 ms Память запроса: 0.034 MB Память до запроса: 35.733 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
WHERE `type` = 'component'
AND `element` = 'com_advancedmodules'
| 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 |
| 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/plugins/system/nnframework/helpers/parameters.php:119
JROOT/plugins/system/advancedmodules/advancedmodulehelper_legacy.php:327
JROOT/plugins/system/advancedmodules/advancedmodulehelper_legacy.php:143
JROOT/libraries/joomla/event/dispatcher.php:167
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:508
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:102
JROOT/libraries/joomla/document/html/html.php:510
JROOT/plugins/system/t3/includes/core/template.php:627
JROOT/templates/event-sochi/tpls/blocks/header.php:22
JROOT/plugins/system/t3/includes/core/template.php:195
JROOT/templates/event-sochi/tpls/default-content-left.php:32
JROOT/plugins/system/t3/includes/core/template.php:219
JROOT/templates/event-sochi/index.php:34
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.33 ms После последнего запроса: 5.08 ms Память запроса: 0.031 MB Память до запроса: 36.891 MB Выбрано строк: 1
SELECT m.menutype
FROM event_menu AS m
WHERE m.id = 127
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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/plugins/system/nnframework/helpers/assignments/menu.php:80
JROOT/plugins/system/nnframework/helpers/assignments/menu.php:28
JROOT/plugins/system/nnframework/helpers/assignments.php:345
JROOT/plugins/system/nnframework/helpers/assignments.php:290
JROOT/plugins/system/advancedmodules/advancedmodulehelper_legacy.php:303
JROOT/libraries/joomla/event/dispatcher.php:167
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:508
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:102
JROOT/libraries/joomla/document/html/html.php:510
JROOT/plugins/system/t3/includes/core/template.php:627
JROOT/templates/event-sochi/tpls/blocks/header.php:22
JROOT/plugins/system/t3/includes/core/template.php:195
JROOT/templates/event-sochi/tpls/default-content-left.php:32
JROOT/plugins/system/t3/includes/core/template.php:219
JROOT/templates/event-sochi/index.php:34
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 1.20 ms После последнего запроса: 17.91 ms Память запроса: 0.031 MB Память до запроса: 37.561 MB Выбрано строк: 4
Повторяющиеся запросы:
#52SELECT tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s AS value,
tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s AS text,
COUNT(tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.searchable = '1'
AND tItem.type = 'restaraunts'
AND tItem.application_id = '1'
AND tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s <> ""
AND tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s IS NOT NULL
GROUP BY tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | tItem | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | TYPE_INDEX | 767 | const | 58 | 2.81 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | tIndex | NULL | ref | item_id,e_d8c3eab3ae454d1aacfb3152ff11bd22_s | item_id | 4 | stranarei2_event.tItem.id | 2 | 40.56 | Using index condition; Using where |
| 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.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.3 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.6 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:162
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.values.php:83
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:178
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.select.php:47
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:378
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbfilter.php:123
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:110
JROOT/modules/mod_jbzoo_search/renderer/item/default.php:19
JROOT/administrator/components/com_zoo/helpers/renderer.php:155
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:43
JROOT/modules/mod_jbzoo_search/tmpl/default.php:53
JROOT/modules/mod_jbzoo_search/mod_jbzoo_search.php:66
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:208
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.05 ms После последнего запроса: 2.43 ms Память запроса: 0.031 MB Память до запроса: 38.109 MB Выбрано строк: 4
Повторяющиеся запросы:
#51SELECT tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s AS value,
tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s AS text,
COUNT(tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.searchable = '1'
AND tItem.type = 'restaraunts'
AND tItem.application_id = '1'
AND tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s <> ""
AND tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s IS NOT NULL
GROUP BY tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | tItem | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | TYPE_INDEX | 767 | const | 58 | 2.81 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | tIndex | NULL | ref | item_id,e_d8c3eab3ae454d1aacfb3152ff11bd22_s | item_id | 4 | stranarei2_event.tItem.id | 2 | 40.56 | Using index condition; Using where |
| 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/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:162
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.values.php:83
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:178
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.select.php:47
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.select.php:29
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbfilter.php:124
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:110
JROOT/modules/mod_jbzoo_search/renderer/item/default.php:19
JROOT/administrator/components/com_zoo/helpers/renderer.php:155
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:43
JROOT/modules/mod_jbzoo_search/tmpl/default.php:53
JROOT/modules/mod_jbzoo_search/mod_jbzoo_search.php:66
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:208
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 1.09 ms После последнего запроса: 2.27 ms Память запроса: 0.031 MB Память до запроса: 38.570 MB Выбрано строк: 3
Повторяющиеся запросы:
#54SELECT tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s AS value,
tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s AS text,
COUNT(tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.searchable = '1'
AND tItem.type = 'restaraunts'
AND tItem.application_id = '1'
AND tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s <> ""
AND tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s IS NOT NULL
GROUP BY tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | tItem | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | TYPE_INDEX | 767 | const | 58 | 2.81 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | tIndex | NULL | ref | item_id,e_a0a7d2fbd36a4ed39c13084c9704052c_s | item_id | 4 | stranarei2_event.tItem.id | 2 | 83.22 | Using index condition; Using where |
| 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.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.2 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.6 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/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:162
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.values.php:83
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:178
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.checkbox.php:48
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:378
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbfilter.php:123
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:110
JROOT/modules/mod_jbzoo_search/renderer/item/default.php:19
JROOT/administrator/components/com_zoo/helpers/renderer.php:155
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:43
JROOT/modules/mod_jbzoo_search/tmpl/default.php:53
JROOT/modules/mod_jbzoo_search/mod_jbzoo_search.php:66
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:208
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.04 ms После последнего запроса: 0.32 ms Память запроса: 0.031 MB Память до запроса: 38.602 MB Выбрано строк: 3
Повторяющиеся запросы:
#53SELECT tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s AS value,
tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s AS text,
COUNT(tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.searchable = '1'
AND tItem.type = 'restaraunts'
AND tItem.application_id = '1'
AND tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s <> ""
AND tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s IS NOT NULL
GROUP BY tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | tItem | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | TYPE_INDEX | 767 | const | 58 | 2.81 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | tIndex | NULL | ref | item_id,e_a0a7d2fbd36a4ed39c13084c9704052c_s | item_id | 4 | stranarei2_event.tItem.id | 2 | 83.22 | Using index condition; Using where |
| 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/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:162
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.values.php:83
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:178
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.checkbox.php:48
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.checkbox.php:30
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbfilter.php:124
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:110
JROOT/modules/mod_jbzoo_search/renderer/item/default.php:19
JROOT/administrator/components/com_zoo/helpers/renderer.php:155
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:43
JROOT/modules/mod_jbzoo_search/tmpl/default.php:53
JROOT/modules/mod_jbzoo_search/mod_jbzoo_search.php:66
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:208
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.94 ms После последнего запроса: 7.49 ms Память запроса: 0.031 MB Память до запроса: 38.707 MB Выбрано строк: 10
Повторяющиеся запросы:
#56SELECT tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s AS value,
tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s AS text,
COUNT(tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.searchable = '1'
AND tItem.type = 'restaraunts'
AND tItem.application_id = '1'
AND tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s <> ""
AND tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s IS NOT NULL
GROUP BY tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | tItem | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | TYPE_INDEX | 767 | const | 58 | 2.81 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | tIndex | NULL | ref | item_id,e_4569f7ad736340e8a5a7a3fe269e9987_s | item_id | 4 | stranarei2_event.tItem.id | 2 | 78.32 | Using index condition; Using where |
| 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.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.2 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.4 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/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:162
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.values.php:83
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:178
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.checkbox.php:48
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:378
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbfilter.php:123
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:110
JROOT/modules/mod_jbzoo_search/renderer/item/default.php:19
JROOT/administrator/components/com_zoo/helpers/renderer.php:155
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:43
JROOT/modules/mod_jbzoo_search/tmpl/default.php:53
JROOT/modules/mod_jbzoo_search/mod_jbzoo_search.php:66
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:208
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.06 ms После последнего запроса: 0.38 ms Память запроса: 0.031 MB Память до запроса: 38.739 MB Выбрано строк: 10
Повторяющиеся запросы:
#55SELECT tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s AS value,
tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s AS text,
COUNT(tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
WHERE tItem.access IN (1)
AND tItem.state = '1'
AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2024-04-23 12:54:41')
AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2024-04-23 12:54:41')
AND tItem.searchable = '1'
AND tItem.type = 'restaraunts'
AND tItem.application_id = '1'
AND tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s <> ""
AND tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s IS NOT NULL
GROUP BY tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | tItem | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | TYPE_INDEX | 767 | const | 58 | 2.81 | Using where; Using temporary; Используется filesort |
| 1 | SIMPLE | tIndex | NULL | ref | item_id,e_4569f7ad736340e8a5a7a3fe269e9987_s | item_id | 4 | stranarei2_event.tItem.id | 2 | 78.32 | Using index condition; Using where |
| 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/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:162
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106
JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.values.php:83
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.php:178
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.checkbox.php:48
JROOT/media/zoo/applications/jbuniversal/framework/render/filter/element.checkbox.php:30
JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbfilter.php:124
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:110
JROOT/modules/mod_jbzoo_search/renderer/item/default.php:19
JROOT/administrator/components/com_zoo/helpers/renderer.php:155
JROOT/media/zoo/applications/jbuniversal/framework/render/filter.php:43
JROOT/modules/mod_jbzoo_search/tmpl/default.php:53
JROOT/modules/mod_jbzoo_search/mod_jbzoo_search.php:66
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:208
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 1.19 ms После последнего запроса: 17.95 ms Память запроса: 0.019 MB Память до запроса: 38.593 MB Выбрано строк: 25
SELECT a.*
FROM event_zoo_item AS a
WHERE a.type = 'restaraunts'
AND a.application_id = 1
AND a.access IN (1)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 12:54:41')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 12:54:41')
GROUP BY a.id
ORDER BY a.priority DESC, a.name
LIMIT 0,50
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | TYPE_INDEX | 767 | const | 58 | 28.08 | Using index condition; Using where; Используется filesort |
| 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 |
| 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.2 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 |
| 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 |
| 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/tables/item.php:435
JROOT/administrator/components/com_zoo/helpers/module.php:123
JROOT/modules/mod_zooitem/mod_zooitem.php:29
JROOT/plugins/system/advancedmodules/modulehelper_legacy.php:208
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.77 ms После последнего запроса: 68.31 ms Память запроса: 0.013 MB Память до запроса: 40.422 MB Выбрано строк: 1
SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM event_rsform_forms
WHERE FormId='3'
AND `Published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_forms | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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 |
| Opening tables | 0.4 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.2 ms |
| cleaning up | 0.0 ms |
JROOT/plugins/system/rsform/rsform.php:97
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.34 ms После последнего запроса: 0.07 ms Память запроса: 0.014 MB Память до запроса: 40.438 MB Выбрано строк: 1
SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access
FROM event_rsform_forms
WHERE FormId='3'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_forms | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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.1 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:204
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.30 ms После последнего запроса: 0.06 ms Память запроса: 0.015 MB Память до запроса: 40.454 MB Выбрано строк: 1
Повторяющиеся запросы:
#63 #69SELECT `Lang`
FROM event_rsform_forms
WHERE FormId='3'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_forms | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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_rsform/helpers/rsform.php:3667
JROOT/administrator/components/com_rsform/helpers/rsform.php:244
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.38 ms После последнего запроса: 0.05 ms Память запроса: 0.015 MB Память до запроса: 40.469 MB Выбрано строк: 0
Повторяющиеся запросы:
#64SELECT *
FROM event_rsform_translations
WHERE `form_id`='3'
AND `lang_code`='ru-RU'
AND `reference`='forms'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | no matching row in const table |
| 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/administrator/components/com_rsform/helpers/rsform.php:3675
JROOT/administrator/components/com_rsform/helpers/rsform.php:244
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.26 ms После последнего запроса: 0.08 ms Память запроса: 0.015 MB Память до запроса: 40.485 MB Выбрано строк: 1
SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM event_rsform_forms
WHERE FormId='3'
AND `Published`='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_forms | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.1 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:1617
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.06 ms После последнего запроса: 0.08 ms Память запроса: 0.016 MB Память до запроса: 40.503 MB Выбрано строк: 1
Повторяющиеся запросы:
#60 #69SELECT `Lang`
FROM event_rsform_forms
WHERE FormId='3'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_forms | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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_rsform/helpers/rsform.php:3667
JROOT/administrator/components/com_rsform/helpers/rsform.php:1620
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.06 ms После последнего запроса: 0.04 ms Память запроса: 0.016 MB Память до запроса: 40.520 MB Выбрано строк: 0
Повторяющиеся запросы:
#61SELECT *
FROM event_rsform_translations
WHERE `form_id`='3'
AND `lang_code`='ru-RU'
AND `reference`='forms'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | no matching row in const table |
| 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_rsform/helpers/rsform.php:3675
JROOT/administrator/components/com_rsform/helpers/rsform.php:1620
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.53 ms После последнего запроса: 0.07 ms Память запроса: 0.017 MB Память до запроса: 40.538 MB Выбрано строк: 0
SELECT ComponentId
FROM event_rsform_components
WHERE ComponentTypeId='6'
AND FormId='3'
AND Published='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_components | NULL | ref | ComponentTypeId,FormId | ComponentTypeId | 4 | const | 2 | 2.50 | Using where |
| 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.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_rsform/helpers/rsform.php:1526
JROOT/administrator/components/com_rsform/helpers/rsform.php:1640
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.98 ms После последнего запроса: 0.06 ms Память запроса: 0.015 MB Память до запроса: 40.555 MB Выбрано строк: 3
SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
Order
FROM event_rsform_properties p
LEFT JOIN event_rsform_components c
ON (c.ComponentId=p.ComponentId)
LEFT JOIN event_rsform_component_types ct
ON (ct.ComponentTypeId=c.ComponentTypeId)
WHERE c.FormId='3'
AND p.PropertyName='NAME'
AND c.Published='1'
ORDER BY c.
Order
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ref | ComponentId,FormId | FormId | 4 | const | 3 | 10.00 | Using index condition; Using where; Используется filesort |
| 1 | SIMPLE | p | NULL | ref | ComponentId | ComponentId | 4 | stranarei2_event.c.ComponentId | 9 | 10.00 | Using where |
| 1 | SIMPLE | ct | NULL | eq_ref | PRIMARY | PRIMARY | 4 | stranarei2_event.c.ComponentTypeId | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Waiting on query cache mutex | 0.1 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.4 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.1 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_rsform/helpers/rsform.php:1693
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.42 ms После последнего запроса: 0.07 ms Память запроса: 0.016 MB Память до запроса: 40.575 MB Выбрано строк: 35
SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM event_rsform_properties
WHERE `ComponentId` IN (37,38,39)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_properties | NULL | range | ComponentId | ComponentId | 4 | NULL | 36 | 100.00 | Using index condition |
| 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.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.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_rsform/helpers/rsform.php:542
JROOT/administrator/components/com_rsform/helpers/rsform.php:1718
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.21 ms После последнего запроса: 0.11 ms Память запроса: 0.016 MB Память до запроса: 40.628 MB Выбрано строк: 1
SELECT FormId
FROM event_rsform_components
WHERE ComponentId='37'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_components | NULL | const | ComponentId | ComponentId | 4 | const | 1 | 100.00 | NULL |
| 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_rsform/helpers/rsform.php:552
JROOT/administrator/components/com_rsform/helpers/rsform.php:1718
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.04 ms После последнего запроса: 0.05 ms Память запроса: 0.017 MB Память до запроса: 40.645 MB Выбрано строк: 1
Повторяющиеся запросы:
#60 #63SELECT `Lang`
FROM event_rsform_forms
WHERE FormId='3'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_forms | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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_rsform/helpers/rsform.php:3667
JROOT/administrator/components/com_rsform/helpers/rsform.php:556
JROOT/administrator/components/com_rsform/helpers/rsform.php:1718
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.15 ms После последнего запроса: 0.04 ms Память запроса: 0.017 MB Память до запроса: 40.662 MB Выбрано строк: 0
SELECT *
FROM event_rsform_translations
WHERE `form_id`='3'
AND `lang_code`='ru-RU'
AND `reference`='properties'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | no matching row in const table |
| 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/administrator/components/com_rsform/helpers/rsform.php:3697
JROOT/administrator/components/com_rsform/helpers/rsform.php:556
JROOT/administrator/components/com_rsform/helpers/rsform.php:1718
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.23 ms После последнего запроса: 0.16 ms Память запроса: 0.017 MB Память до запроса: 40.663 MB Выбрано строк: 0
SELECT ComponentId
FROM event_rsform_components
WHERE ComponentTypeId='41'
AND FormId='3'
AND Published='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_components | NULL | ref | ComponentTypeId,FormId | ComponentTypeId | 4 | const | 2 | 2.50 | Using where |
| 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.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_rsform/helpers/rsform.php:1526
JROOT/administrator/components/com_rsform/helpers/rsform.php:3145
JROOT/administrator/components/com_rsform/helpers/rsform.php:1750
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.40 ms После последнего запроса: 0.10 ms Память запроса: 0.021 MB Память до запроса: 40.675 MB Выбрано строк: 12
SELECT *
FROM event_rsform_config
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_config | NULL | ALL | NULL | Индекс не используется | NULL | NULL | 12 | 100.00 | NULL |
| 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_rsform/helpers/config.php:50
JROOT/administrator/components/com_rsform/helpers/config.php:17
JROOT/administrator/components/com_rsform/helpers/config.php:97
JROOT/administrator/components/com_rsform/helpers/rsform.php:379
JROOT/administrator/components/com_rsform/helpers/rsform.php:2442
JROOT/administrator/components/com_rsform/helpers/rsform.php:1777
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.41 ms После последнего запроса: 0.26 ms Память запроса: 0.016 MB Память до запроса: 40.701 MB Выбрано строк: 0
SELECT c.*,p.PropertyValue AS ComponentName
FROM `event_rsform_conditions` c
LEFT JOIN event_rsform_properties p
ON (c.component_id = p.ComponentId)
LEFT JOIN event_rsform_components comp
ON (comp.ComponentId=p.ComponentId)
WHERE c.`form_id` = 3
AND c.lang_code='ru-RU'
AND comp.Published = 1
AND p.PropertyName='NAME'
ORDER BY c.`id` ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | no matching row in const table |
| 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.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/administrator/components/com_rsform/helpers/rsform.php:1576
JROOT/administrator/components/com_rsform/helpers/rsform.php:1908
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.39 ms После последнего запроса: 0.04 ms Память запроса: 0.016 MB Память до запроса: 40.717 MB Выбрано строк: 0
SELECT *
FROM event_rsform_calculations
WHERE formId = 3
ORDER BY `ordering`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | Индекс не используется | NULL | NULL | NULL | NULL | no matching row in const table |
| 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/administrator/components/com_rsform/helpers/rsform.php:4369
JROOT/administrator/components/com_rsform/helpers/rsform.php:1963
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.31 ms После последнего запроса: 0.04 ms Память запроса: 0.016 MB Память до запроса: 40.733 MB Выбрано строк: 0
SELECT ComponentId
FROM event_rsform_components
WHERE ComponentTypeId='212'
AND FormId='3'
AND Published='1'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_components | NULL | ref | ComponentTypeId,FormId | ComponentTypeId | 4 | const | 1 | 5.00 | Using where |
| 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.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_rsform/helpers/rsform.php:1526
JROOT/administrator/components/com_rsform/helpers/rsform.php:1981
JROOT/administrator/components/com_rsform/helpers/rsform.php:299
JROOT/plugins/system/rsform/rsform.php:126
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.25 ms После последнего запроса: 24.40 ms Память запроса: 0.022 MB Память до запроса: 40.962 MB Выбрано строк: 1
SELECT `FormTitle`
FROM event_rsform_forms
WHERE `FormId`='5'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | event_rsform_forms | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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/components/com_rsform/router.php:117
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:160
JROOT/plugins/system/sef/sef.php:76
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:994
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:46
Время запроса: 0.70 ms После последнего запроса: 2.86 ms Память запроса: 0.003 MB Память до запроса: 40.719 MB
UPDATE `event_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713876881;s:18:\"session.timer.last\";i:1713876881;s:17:\"session.timer.now\";i:1713876881;s:24:\"session.client.forwarded\";s:10:\"3.17.79.60\";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;}}__jbzoo|a:1:{s:6:\"viewed\";a:1:{i:141;a:2:{s:4:\"type\";s:11:\"restaraunts\";s:5:\"appId\";s:1:\"1\";}}}'
, `time` = '1713876882'
WHERE `session_id` = 'vt0kjhj7d2gkgrsk75olb971p7'
| 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 |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.3 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
7 × SELECT extension_id AS id, element AS "option", params, enabled
FROM event_extensions
4 × SELECT *
FROM event_zoo_item
3 × SELECT `Lang`
FROM event_rsform_forms
3 × SELECT ComponentId
FROM event_rsform_components
3 × SELECT *
FROM event_rsform_translations
2 × SELECT tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s AS value, tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s AS text, COUNT(tIndex.e_4569f7ad736340e8a5a7a3fe269e9987_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
2 × SELECT tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s AS value, tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s AS text, COUNT(tIndex.e_a0a7d2fbd36a4ed39c13084c9704052c_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
2 × SELECT tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s AS value, tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s AS text, COUNT(tIndex.e_d8c3eab3ae454d1aacfb3152ff11bd22_s) AS count
FROM event_zoo_item AS tItem
INNER JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
2 × SELECT a.rules
FROM event_assets AS a
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 id
FROM event_zoo_item
1 × SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM event_rsform_properties
1 × SELECT a.*
FROM event_zoo_item AS a
1 × SELECT FormId
FROM event_rsform_components
1 × SELECT m.menutype
FROM event_menu AS m
1 × SELECT ROWNUM, id
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM event_zoo_item AS a
LEFT JOIN event_zoo_category_item AS b
ON a.id = b.item_id
LEFT JOIN event_zoo_search_index AS s
ON a.id = s.item_id
AND s.element_id IN ('_jbzoo_0_field__none', '_jbzoo_0_mode_s', '_jbzoo_0_order_asc')
1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM event_modules AS m
LEFT JOIN event_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN event_advancedmodules as am
ON am.moduleid = m.id
1 × SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM event_rsform_forms
1 × SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access
FROM event_rsform_forms
1 × SELECT ROWNUM
FROM (SELECT @rownum:= @rownum+1 ROWNUM, id
FROM (SELECT @rownum:=0) r, (SELECT id
FROM event_zoo_item AS a
LEFT JOIN event_zoo_category_item AS b
ON a.id = b.item_id
LEFT JOIN event_zoo_search_index AS s
ON a.id = s.item_id
AND s.element_id IN ('_jbzoo_0_field__none', '_jbzoo_0_mode_s', '_jbzoo_0_order_asc')
1 × SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM event_rsform_forms
1 × SELECT `FormTitle`
FROM event_rsform_forms
1 × SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
Order
FROM event_rsform_properties p
LEFT JOIN event_rsform_components c
ON (c.ComponentId=p.ComponentId)
LEFT JOIN event_rsform_component_types ct
ON (ct.ComponentTypeId=c.ComponentTypeId)
1 × SELECT *
FROM event_rsform_calculations
1 × SELECT *
FROM event_rsform_confi
1 × SELECT c.*,p.PropertyValue AS ComponentName
FROM `event_rsform_conditions` c
LEFT JOIN event_rsform_properties p
ON (c.component_id = p.ComponentId)
LEFT JOIN event_rsform_components comp
ON (comp.ComponentId=p.ComponentId)
1 × SELECT params
FROM event_extensions AS e
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 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 alias
FROM event_zoo_item
1 × SELECT *
FROM event_languages
1 × SELECT CONCAT_WS(".", `
group`, `key`) as group_key, `value`, `type`
FROM event_zoo_jbzoo_config
LIMIT 1001 × SELECT folder AS type, element AS name, params
FROM event_extensions
1 × SELECT `session_id`
FROM `event_session`
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 id, rules
FROM `event_viewlevels
1 × SELECT *
FROM event_zoo_application
1 × SELECT *
FROM event_zoo_category
1 × SELECT name
FROM event_zoo_tag
1 × SELECT `data`
FROM `event_session`
1 × SELECT id,template
FROM event_template_styles
1 × SELECT b.id
FROM event_zoo_category_item AS a JOIN event_zoo_category AS b
ON a.category_id = b.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 id
FROM event_users
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 tAll.id , COUNT(tAll.id) AS count
FROM (( SELECT tItem.id AS id
FROM event_zoo_item AS tItem
LEFT JOIN event_zoo_jbzoo_index_restaraunts AS tIndex
ON tIndex.item_id = tItem.id
EVENT-SOCHI.RU
организация мероприятий в Сочи
_27fb46b43673c2f376a3a04c5ad43c42.jpg "Пацха Малый Ахун")
.jpg "Пацха Малый Ахун")
.jpg "Пацха Малый Ахун")
.JPG "Пацха Малый Ахун")
.jpg "Пацха Малый Ахун")
.JPG "Пацха Малый Ахун")
.jpg "Пацха Малый Ахун")
.JPG "Пацха Малый Ахун")
.JPG "Пацха Малый Ахун")
.JPG "Пацха Малый Ахун")
_e9a5088eba89d2f7b21a2d8042defff9.jpg "Le Chef")
_1d82b8124c9789852037bf9b5f719d58.jpg "Lighthouse")
_7a67d6ff6e9e53cf5bb367a471cf2551.jpg "Royal Fish")
_6b6bcdfd2fc12fbbf2936785bb091cdb.jpeg "Sanremo")
_95c210f3605a54ffeaf3d3cca1dc9e85.jpg "SeaZone")
_8c7ebc07bd0585e9f75a2566d26ac161.jpg "Syndicate")
_7ce6ca8ce0b4c4c5b7414e6b65238ab9.JPG "Амшенский Двор")
_cf4f6324b6bd73eddfdc42efd1d3fd75.jpg "Байкал")
_eac2f2ab7a0d0e6dc587ef790d948f56.jpg "Баран Рапан")
_777b408084a79920899032cc69fc2852.jpg "Бригантина")
_5ccd4b5fe50c499690de559118974e45.jpg "Брусника")
_5ff0582d56fc142adf321ad0a1248fb1.jpg "Восточный Квартал")
_563ea6a8efea15e1e8667bed1783ae4b.jpg "Кавказский Аул")
_61eef1eb92f7845e5bf59a35a0dc8940.jpg "Наутилус")
-001_3020c174880f67873eb17f4ea3df7093.jpg "Облака")
_3f6b6c218d005b4c8e10632fe3e70945.jpg "Пацха в Навалишенском ущелье")
_4f882ea45ec216c4876bb8ddaaad82b2.jpg "Пацха Малый Ахун")
_4b5e2dcf0f44a8c59dc779e31ddb51cb.jpg "Салхино")
_1db4a83b4fc6448f05a2100d9a6fff73.JPG "Таверна Каньон")
_4fd80fc42eb11122974af9fe627cfeb9.jpg "Трикони")
_b174e1486f34966a6ed1de0dad02ca7e.jpg "Чайка")