**Время запроса: 0.64 ms** **Память запроса: 0.013 MB Память до запроса: 0.652 MB** **Выбрано строк: 0**
SELECT `data`
FROM `p38xt_session`
WHERE `session_id` = 'v7vcm70364sf4hfecvdvqs2lq6'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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 |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 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:654
JROOT/libraries/joomla/session/session.php:592
JROOT/libraries/legacy/application/application.php:982
JROOT/libraries/legacy/application/application.php:140
JROOT/includes/application.php:47
JROOT/libraries/legacy/application/application.php:175
JROOT/libraries/joomla/factory.php:104
JROOT/index.php:39
**Время запроса: 0.72 ms** **После последнего запроса: 1.14 ms** **Память запроса: 0.008 MB Память до запроса: 0.698 MB**
DELETE
FROM `p38xt_session`
WHERE `time` < '1604116647'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | DELETE | p38xt_session | NULL | range | time | time | 45 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.1 ms |
| updating | 0.2 ms |
| end | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| end | 0.0 ms |
| query end | 0.1 ms |
| closing tables | 0.1 ms |
| freeing items | 0.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/legacy/application/application.php:999
JROOT/libraries/legacy/application/application.php:140
JROOT/includes/application.php:47
JROOT/libraries/legacy/application/application.php:175
JROOT/libraries/joomla/factory.php:104
JROOT/index.php:39
**Время запроса: 0.54 ms** **После последнего запроса: 0.27 ms** **Память запроса: 0.010 MB Память до запроса: 0.709 MB** **Выбрано строк: 0**
SELECT `session_id`
FROM `p38xt_session`
WHERE `session_id` = 'v7vcm70364sf4hfecvdvqs2lq6'
LIMIT 0, 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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 |
| 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.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/legacy/application/application.php:1035
JROOT/libraries/legacy/application/application.php:1007
JROOT/libraries/legacy/application/application.php:140
JROOT/includes/application.php:47
JROOT/libraries/legacy/application/application.php:175
JROOT/libraries/joomla/factory.php:104
JROOT/index.php:39
**Время запроса: 0.57 ms** **После последнего запроса: 0.30 ms** **Память запроса: 0.009 MB Память до запроса: 0.721 MB**
INSERT INTO `p38xt_session`
(`session_id`, `client_id`, `time`)
VALUES
('v7vcm70364sf4hfecvdvqs2lq6', 0, '1604117547')
**EXPLAIN не доступен для запроса: INSERT INTO `p38xt_session`
(`session_id`, `client_id`, `time`) VALUES
('v7vcm70364sf4hfecvdvqs2lq6', 0, '1604117547')**
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| update | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| update | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/legacy/application/application.php:1066
JROOT/libraries/legacy/application/application.php:1007
JROOT/libraries/legacy/application/application.php:140
JROOT/includes/application.php:47
JROOT/libraries/legacy/application/application.php:175
JROOT/libraries/joomla/factory.php:104
JROOT/index.php:39
**Время запроса: 0.27 ms** **После последнего запроса: 1.69 ms** **Память запроса: 0.009 MB Память до запроса: 0.796 MB** **Выбрано строк: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM p38xt_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 | p38xt_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/includes/application.php:63
JROOT/index.php:42
**Время запроса: 0.27 ms** **После последнего запроса: 0.73 ms** **Память запроса: 0.010 MB Память до запроса: 0.809 MB** **Выбрано строк: 2**
SELECT b.id
FROM p38xt_usergroups AS a
LEFT JOIN p38xt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| 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 | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:336
JROOT/libraries/joomla/access/access.php:405
JROOT/libraries/joomla/user/user.php:415
JROOT/libraries/joomla/plugin/helper.php:266
JROOT/libraries/joomla/plugin/helper.php:165
JROOT/includes/application.php:69
JROOT/index.php:42
**Время запроса: 0.22 ms** **После последнего запроса: 0.24 ms** **Память запроса: 0.009 MB Память до запроса: 0.826 MB** **Выбрано строк: 4**
SELECT id, rules
FROM `p38xt_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_viewlevels | NULL | ALL | NULL | **Индекс не используется** | NULL | NULL | 4 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:422
JROOT/libraries/joomla/user/user.php:415
JROOT/libraries/joomla/plugin/helper.php:266
JROOT/libraries/joomla/plugin/helper.php:165
JROOT/includes/application.php:69
JROOT/index.php:42
**Время запроса: 0.21 ms** **После последнего запроса: 0.24 ms** **Память запроса: 0.007 MB Память до запроса: 0.842 MB** **Выбрано строк: 59**
SELECT folder AS type, element AS name, params
FROM p38xt_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_extensions | NULL | ref | extension | extension | 62 | const | 77 | 3.33 | Using index condition; Using where; **Используется filesort** |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/plugin/helper.php:280
JROOT/libraries/joomla/plugin/helper.php:165
JROOT/includes/application.php:69
JROOT/index.php:42
**Время запроса: 0.22 ms** **После последнего запроса: 0.77 ms** **Память запроса: 0.010 MB Память до запроса: 0.919 MB** **Выбрано строк: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM p38xt_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 | p38xt_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/includes/application.php:116
JROOT/index.php:42
**Время запроса: 0.37 ms** **После последнего запроса: 8.97 ms** **Память запроса: 0.016 MB Память до запроса: 1.270 MB** **Выбрано строк: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM p38xt_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/plugins/system/k2/k2.php:433
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/legacy/application/application.php:225
JROOT/includes/application.php:136
JROOT/index.php:42
**Время запроса: 0.43 ms** **После последнего запроса: 9.97 ms** **Память запроса: 0.015 MB Память до запроса: 1.569 MB** **Выбрано строк: 30**
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 p38xt_menu AS m
LEFT JOIN p38xt_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 | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 98 | 10.00 | Using index condition; Using where; **Используется filesort** |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/legacy/menu/menu.php:61
JROOT/libraries/legacy/menu/menu.php:113
JROOT/libraries/legacy/application/application.php:893
JROOT/includes/application.php:593
JROOT/libraries/cms/router/site.php:203
JROOT/libraries/joomla/application/router.php:182
JROOT/libraries/cms/router/site.php:83
JROOT/libraries/legacy/application/application.php:246
JROOT/includes/application.php:155
JROOT/index.php:48
**Время запроса: 0.39 ms** **После последнего запроса: 46.46 ms** **Память запроса: 0.013 MB Память до запроса: 1.819 MB** **Выбрано строк: 10**
SELECT id, home, template, s.params
FROM p38xt_template_styles as s
LEFT JOIN p38xt_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 | 12 | 10.00 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | shymkala_ru.s.template,const | 1 | 4.59 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/includes/application.php:495
JROOT/plugins/system/t3/includes/core/t3.php:240
JROOT/plugins/system/t3/t3.php:32
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/legacy/application/application.php:255
JROOT/includes/application.php:155
JROOT/index.php:48
**Время запроса: 0.37 ms** **После последнего запроса: 13.16 ms** **Память запроса: 0.015 MB Память до запроса: 2.123 MB** **Выбрано строк: 1**
SELECT *
FROM p38xt_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 | p38xt_languages | NULL | ALL | NULL | **Индекс не используется** | NULL | NULL | 1 | 100.00 | Using where; **Используется filesort** |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.2 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/language/helper.php:159
JROOT/includes/application.php:381
JROOT/components/com_k2/helpers/utilities.php:315
JROOT/administrator/components/com_k2/helpers/html.php:56
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/legacy/application/application.php:255
JROOT/includes/application.php:155
JROOT/index.php:48
**Время запроса: 0.23 ms** **После последнего запроса: 5.99 ms** **Память запроса: 0.021 MB Память до запроса: 2.258 MB** **Выбрано строк: 1**
SELECT extension_id AS id, element AS "option", params, enabled
FROM p38xt_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/legacy/component/helper.php:384
JROOT/libraries/legacy/component/helper.php:43
JROOT/libraries/legacy/component/helper.php:91
JROOT/components/com_content/router.php:26
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/joomla/application/router.php:214
JROOT/libraries/cms/router/site.php:97
JROOT/libraries/joomla/application/route.php:62
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/legacy/application/application.php:255
JROOT/includes/application.php:155
JROOT/index.php:48
**Время запроса: 0.27 ms** **После последнего запроса: 5.74 ms** **Память запроса: 0.020 MB Память до запроса: 2.489 MB** **Выбрано строк: 1**
SELECT a.rules
FROM p38xt_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.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/user/user.php:354
JROOT/components/com_content/models/articles.php:94
JROOT/components/com_content/models/featured.php:39
JROOT/libraries/legacy/model/legacy.php:415
JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
JROOT/components/com_content/views/featured/view.html.php:46
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/legacy/component/helper.php:355
JROOT/libraries/legacy/component/helper.php:335
JROOT/includes/application.php:220
JROOT/index.php:54
**Время запроса: 0.24 ms** **После последнего запроса: 0.69 ms** **Память запроса: 0.021 MB Память до запроса: 2.519 MB** **Выбрано строк: 2**
SELECT b.rules
FROM p38xt_assets AS a
LEFT JOIN p38xt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
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 | 10 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/access/access.php:110
JROOT/libraries/joomla/user/user.php:362
JROOT/components/com_content/models/articles.php:94
JROOT/components/com_content/models/featured.php:39
JROOT/libraries/legacy/model/legacy.php:415
JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
JROOT/components/com_content/views/featured/view.html.php:46
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/legacy/component/helper.php:355
JROOT/libraries/legacy/component/helper.php:335
JROOT/includes/application.php:220
JROOT/index.php:54
**Время запроса: 1.97 ms** **После последнего запроса: 1.65 ms** **Память запроса: 0.018 MB Память до запроса: 2.582 MB** **Выбрано строк: 1**
SELECT COUNT(*)
FROM p38xt_content AS a
LEFT JOIN p38xt_categories AS c
ON c.id = a.catid
LEFT JOIN p38xt_users AS ua
ON ua.id = a.created_by
LEFT JOIN p38xt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN p38xt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN p38xt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM p38xt_categories AS cat JOIN p38xt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN p38xt_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-31 04:12:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-31 04:12:27')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 1 | 100.00 | Using index |
| 1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_access,idx_catid | PRIMARY | 4 | shymkala_ru.fp.content_id | 1 | 16.00 | Using where |
| 1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | shymkala_ru.a.catid | 1 | 100.00 | Using where |
| 1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.a.created_by | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.a.modified_by | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.c.parent_id | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.a.id | 1 | 100.00 | Using where; Using index |
| 1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | shymkala_ru.c.id | 2 | 100.00 | Using where; Using index |
| 2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 153 | NULL | 2 | 100.00 | Using index condition; Using temporary; **Используется filesort** |
| 2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language | idx_left_right | 8 | NULL | 17 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.5 ms |
| init | 0.1 ms |
| System lock | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| 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 |
| 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.1 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/legacy/model/legacy.php:327
JROOT/libraries/legacy/model/list.php:232
JROOT/libraries/legacy/model/list.php:178
JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
JROOT/components/com_content/views/featured/view.html.php:48
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/legacy/component/helper.php:355
JROOT/libraries/legacy/component/helper.php:335
JROOT/includes/application.php:220
JROOT/index.php:54
**Время запроса: 1.92 ms** **После последнего запроса: 4.97 ms** **Память запроса: 0.019 MB Память до запроса: 2.699 MB** **Выбрано строк: 30**
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM p38xt_modules AS m
LEFT JOIN p38xt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p38xt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-31 04:12:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-31 04:12:27')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ref | PRIMARY,published,newsfeeds | published | 1 | const | 37 | 0.90 | Using index condition; Using where; **Используется filesort** |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | shymkala_ru.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | shymkala_ru.m.id | 3 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 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 |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.4 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.3 ms |
| Waiting for query cache lock | 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.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
JROOT/libraries/joomla/document/html/html.php:502
JROOT/plugins/system/t3/includes/core/template.php:453
JROOT/templates/noo_noonews/tpls/blocks/top-header.php:15
JROOT/plugins/system/t3/includes/core/template.php:125
JROOT/templates/noo_noonews/tpls/home.php:30
JROOT/plugins/system/t3/includes/core/template.php:144
JROOT/templates/noo_noonews/index.php:34
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:630
JROOT/libraries/joomla/document/html/html.php:452
JROOT/includes/application.php:278
JROOT/index.php:60
**Время запроса: 0.37 ms** **После последнего запроса: 66.44 ms** **Память запроса: 0.017 MB Память до запроса: 3.082 MB** **Выбрано строк: 0**
SELECT id
FROM p38xt_k2_categories
WHERE parent IN (2,3,4,5,19,20,21,26,27,43)
AND id NOT IN (2,3,4,5,19,20,21,26,27,43)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_k2_categories | NULL | ref | PRIMARY,category,parent,published,access,trash | trash | 2 | const | 14 | 25.60 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_k2/models/itemlist.php:622
JROOT/modules/mod_noo_contentslider/helper.php:112
JROOT/modules/mod_noo_contentslider/helper.php:39
JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:48
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 415.92 ms** **После последнего запроса: 0.22 ms** **Память запроса: 0.015 MB Память до запроса: 3.101 MB** **Выбрано строк: 18**
SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
LEFT JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND c.access IN(1,1,5)
AND c.id IN (2,3,4,5,19,20,21,26,27,43)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 18
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ref | PRIMARY,category,published,access,trash | trash | 2 | const | 14 | 17.78 | Using where; Using temporary; **Используется filesort** |
| 1 | SIMPLE | i | NULL | ref | item,catid | catid | 4 | shymkala_ru.c.id | 135 | 1.19 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 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 |
| Waiting for table level lock | 17.4 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.1 ms |
| statistics | 0.2 ms |
| preparing | 0.1 ms |
| Creating tmp table | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 391.1 ms |
| Creating sort index | 2.8 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 2.3 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.1 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_contentslider/helper.php:125
JROOT/modules/mod_noo_contentslider/helper.php:39
JROOT/modules/mod_noo_contentslider/mod_noo_contentslider.php:48
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 0.36 ms** **После последнего запроса: 19.65 ms** **Память запроса: 0.014 MB Память до запроса: 3.332 MB** **Выбрано строк: 1**
SELECT k2c.*
FROM p38xt_k2_categories AS k2c
WHERE k2c.id IN (2)
AND k2c.published = 1
AND k2c.trash = 0
AND k2c.access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k2c | NULL | const | PRIMARY,category,published,access,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:61
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 165.55 ms** **После последнего запроса: 0.24 ms** **Память запроса: 0.015 MB Память до запроса: 3.358 MB** **Выбрано строк: 5**
SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.catid = 2
AND i.access IN(1,1,5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 11 | 0.50 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 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 |
| Waiting for table level lock | 162.3 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 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.2 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.3 ms |
| Waiting for query cache lock | 0.4 ms |
| Sending data | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.5 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.1 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.1 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:136
JROOT/modules/mod_noo_k2_categoryitem/helper.php:64
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 0.25 ms** **После последнего запроса: 3.75 ms** **Память запроса: 0.014 MB Память до запроса: 3.373 MB** **Выбрано строк: 1**
SELECT k2c.*
FROM p38xt_k2_categories AS k2c
WHERE k2c.id IN (19)
AND k2c.published = 1
AND k2c.trash = 0
AND k2c.access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k2c | NULL | const | PRIMARY,category,published,access,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:61
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 3.07 ms** **После последнего запроса: 0.21 ms** **Память запроса: 0.015 MB Память до запроса: 3.399 MB** **Выбрано строк: 5**
SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.catid = 19
AND i.access IN(1,1,5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 60 | 0.10 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 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.4 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.4 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.2 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:136
JROOT/modules/mod_noo_k2_categoryitem/helper.php:64
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 0.30 ms** **После последнего запроса: 4.33 ms** **Память запроса: 0.014 MB Память до запроса: 3.412 MB** **Выбрано строк: 1**
SELECT k2c.*
FROM p38xt_k2_categories AS k2c
WHERE k2c.id IN (5)
AND k2c.published = 1
AND k2c.trash = 0
AND k2c.access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k2c | NULL | const | PRIMARY,category,published,access,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:61
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 2.98 ms** **После последнего запроса: 0.23 ms** **Память запроса: 0.015 MB Память до запроса: 3.437 MB** **Выбрано строк: 5**
SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.catid = 5
AND i.access IN(1,1,5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | **Используется filesort** |
| 1 | SIMPLE | i | NULL | ref | item,catid | catid | 4 | const | 95 | 1.19 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 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 | 1.6 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.1 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:136
JROOT/modules/mod_noo_k2_categoryitem/helper.php:64
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 0.29 ms** **После последнего запроса: 4.47 ms** **Память запроса: 0.014 MB Память до запроса: 3.450 MB** **Выбрано строк: 1**
SELECT k2c.*
FROM p38xt_k2_categories AS k2c
WHERE k2c.id IN (21)
AND k2c.published = 1
AND k2c.trash = 0
AND k2c.access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k2c | NULL | const | PRIMARY,category,published,access,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:61
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 2.29 ms** **После последнего запроса: 0.23 ms** **Память запроса: 0.015 MB Память до запроса: 3.475 MB** **Выбрано строк: 5**
SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.catid = 21
AND i.access IN(1,1,5)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | **Используется filesort** |
| 1 | SIMPLE | i | NULL | ref | item,catid | catid | 4 | const | 116 | 1.19 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 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 | 1.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.1 ms |
| Waiting for query cache lock | 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.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.5 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2_categoryitem/helper.php:136
JROOT/modules/mod_noo_k2_categoryitem/helper.php:64
JROOT/modules/mod_noo_k2_categoryitem/mod_noo_k2_categoryitem.php:20
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 0.42 ms** **После последнего запроса: 72.36 ms** **Память запроса: 0.015 MB Память до запроса: 3.533 MB** **Выбрано строк: 0**
SELECT id
FROM p38xt_k2_categories
WHERE parent IN (26)
AND id NOT IN (26)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_k2_categories | NULL | ref | PRIMARY,category,parent,published,access,trash | parent | 5 | const | 1 | 46.67 | Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| Waiting for query cache lock | 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.1 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_k2/models/itemlist.php:622
JROOT/modules/mod_k2_content/helper.php:133
JROOT/modules/mod_k2_content/mod_k2_content.php:51
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 1.48 ms** **После последнего запроса: 0.20 ms** **Память запроса: 0.014 MB Память до запроса: 3.550 MB** **Выбрано строк: 4**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items as i RIGHT JOIN p38xt_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
AND i.catid IN (26)
ORDER BY i.id DESC
LIMIT 0, 4
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,access,trash | PRIMARY | 4 | const | 1 | 100.00 | **Используется filesort** |
| 1 | SIMPLE | i | NULL | ref | item,catid | catid | 4 | const | 17 | 1.19 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 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 |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.2 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_k2_content/helper.php:261
JROOT/modules/mod_k2_content/mod_k2_content.php:51
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 0.42 ms** **После последнего запроса: 10.07 ms** **Память запроса: 0.015 MB Память до запроса: 3.718 MB** **Выбрано строк: 8**
SELECT k2c.*
FROM p38xt_k2_categories AS k2c
WHERE k2c.id IN (2,19,20,21,4,5,43,46)
AND k2c.published = 1
AND k2c.trash = 0
AND k2c.access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | k2c | NULL | ref | PRIMARY,category,published,access,trash | trash | 2 | const | 14 | 14.22 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.2 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:77
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 1.66 ms** **После последнего запроса: 0.38 ms** **Память запроса: 0.016 MB Память до запроса: 3.789 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 2
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 7 | 0.71 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 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 |
| Waiting for query cache lock | 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.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 4.44 ms** **После последнего запроса: 5.64 ms** **Память запроса: 0.017 MB Память до запроса: 3.873 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 4
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 98 | 0.05 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 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 |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 ms |
| preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 1.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 2.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 78.39 ms** **После последнего запроса: 3.98 ms** **Память запроса: 0.016 MB Память до запроса: 3.953 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 5
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | **Используется filesort** |
| 1 | SIMPLE | i | NULL | ref | item,catid | catid | 4 | const | 95 | 1.19 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.2 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 |
| Waiting for query cache lock | 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 | 69.1 ms |
| Waiting for query cache lock | 0.1 ms |
| Creating sort index | 0.8 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 6.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.2 ms |
| freeing items | 0.5 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 80.48 ms** **После последнего запроса: 19.08 ms** **Память запроса: 0.016 MB Память до запроса: 4.033 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 19
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 36 | 0.14 | Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| Waiting for query cache lock | 0.1 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.5 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.1 ms |
| Opening tables | 0.1 ms |
| init | 0.4 ms |
| System lock | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 ms |
| optimizing | 0.1 ms |
| statistics | 70.7 ms |
| preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 1.5 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 2.5 ms |
| Waiting for query cache lock | 0.1 ms |
| Sending data | 2.0 ms |
| end | 0.1 ms |
| query end | 0.0 ms |
| closing tables | 0.2 ms |
| freeing items | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.5 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 75.61 ms** **После последнего запроса: 21.78 ms** **Память запроса: 0.016 MB Память до запроса: 4.114 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 20
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 14 | 0.36 | Using where |
| Status | Duration |
|---|
| starting | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.5 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.2 ms |
| System lock | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 ms |
| optimizing | 0.2 ms |
| statistics | 0.3 ms |
| preparing | 67.8 ms |
| Sorting result | 0.1 ms |
| executing | 0.0 ms |
| Sending data | 0.8 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 3.3 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.2 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.2 ms |
| freeing items | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.1 ms |
| freeing items | 0.1 ms |
| storing result in query cache | 0.6 ms |
| cleaning up | 0.1 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 83.23 ms** **После последнего запроса: 15.81 ms** **Память запроса: 0.016 MB Память до запроса: 4.193 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 21
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 93 | 0.05 | Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.5 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.1 ms |
| Opening tables | 0.1 ms |
| init | 0.2 ms |
| System lock | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 ms |
| optimizing | 0.1 ms |
| statistics | 0.4 ms |
| preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 76.3 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 2.5 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.0 ms |
| end | 0.1 ms |
| query end | 0.0 ms |
| closing tables | 0.2 ms |
| freeing items | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.3 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 78.51 ms** **После последнего запроса: 17.81 ms** **Память запроса: 0.016 MB Память до запроса: 4.273 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 43
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 42 | 0.12 | Using where |
| Status | Duration |
|---|
| starting | 0.3 ms |
| Waiting for query cache lock | 0.1 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.7 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.4 ms |
| System lock | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 ms |
| optimizing | 0.1 ms |
| statistics | 0.5 ms |
| preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.8 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.6 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.6 ms |
| end | 0.1 ms |
| query end | 70.3 ms |
| closing tables | 0.3 ms |
| freeing items | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.4 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 8.86 ms** **После последнего запроса: 17.34 ms** **Память запроса: 0.016 MB Память до запроса: 4.353 MB** **Выбрано строк: 3**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND i.catid = 46
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 3
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,category,published,trash | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 37 | 0.14 | Using where |
| Status | Duration |
|---|
| starting | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.5 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.2 ms |
| System lock | 0.1 ms |
| Waiting for query cache lock | 0.1 ms |
| System lock | 0.1 ms |
| optimizing | 0.1 ms |
| statistics | 0.4 ms |
| preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 1.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 3.2 ms |
| end | 0.1 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_k2items/helper.php:227
JROOT/modules/mod_noo_k2items/helper.php:83
JROOT/modules/mod_noo_k2items/helper.php:29
JROOT/modules/mod_noo_k2items/mod_noo_k2items.php:49
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 5.02 ms** **После последнего запроса: 182.55 ms** **Память запроса: 0.016 MB Память до запроса: 4.325 MB** **Выбрано строк: 13**
SELECT
content.id AS id
FROM
p38xt_k2_items AS content
WHERE
content.published = 1
AND content.trash = 0
AND content.access IN (1,1,5)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2020-10-31 04:12:28' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2020-10-31 04:12:28' )
AND content.featured = 1
ORDER BY
content.publish_up DESC
LIMIT
0,13;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | NULL | range | item,featured | item | 7 | NULL | 3580 | 0.70 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.5 ms |
| checking permissions | 0.1 ms |
| Opening tables | 0.1 ms |
| init | 0.1 ms |
| System lock | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 ms |
| optimizing | 0.1 ms |
| statistics | 0.4 ms |
| preparing | 0.3 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 2.0 ms |
| end | 0.1 ms |
| query end | 0.0 ms |
| closing tables | 0.2 ms |
| freeing items | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.2 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:258
JROOT/modules/mod_news_pro_gk5/helper.php:110
JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:30
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 12.73 ms** **После последнего запроса: 0.52 ms** **Память запроса: 0.016 MB Память до запроса: 4.351 MB** **Выбрано строк: 13**
SELECT
content.id AS id,
content.alias AS alias,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.featured AS frontpage,
content.access AS access,
content.catid AS cid,
content.video AS video,
content.plugins AS plugins,
categories.name AS catname,
categories.image AS cat_image,
categories.alias AS cat_alias,
users.email AS author_email,
content.created_by_alias AS author_alias,
users.name AS author_username,
content.created_by AS author_id,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count
FROM
p38xt_k2_items AS content
LEFT JOIN
p38xt_k2_categories AS categories
ON categories.id = content.catid
LEFT JOIN
p38xt_users AS users
ON users.id = content.created_by
LEFT JOIN
p38xt_k2_rating AS content_rating
ON content_rating.itemID = content.id
WHERE
1=1
AND ( content.id = 4301 OR content.id = 4300 OR content.id = 4299 OR content.id = 4298 OR content.id = 4297 OR content.id = 4296 OR content.id = 4295 OR content.id = 4293 OR content.id = 4292 OR content.id = 4291 OR content.id = 4290 OR content.id = 4289 OR content.id = 4288)
ORDER BY
content.publish_up DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 13 | 100.00 | Using index condition; **Используется filesort** |
| 1 | SIMPLE | categories | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.content.catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | users | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.content.created_by | 1 | 100.00 | NULL |
| 1 | SIMPLE | content_rating | NULL | eq_ref | PRIMARY | PRIMARY | 4 | shymkala_ru.content.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.3 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.1 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 |
| System lock | 0.2 ms |
| optimizing | 0.1 ms |
| statistics | 0.1 ms |
| preparing | 0.1 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.6 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 2.2 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 1.4 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 1.9 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.3 ms |
| Waiting for query cache lock | 0.1 ms |
| Creating sort index | 0.7 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 1.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Creating sort index | 0.8 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.1 ms |
| freeing items | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 1.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:317
JROOT/modules/mod_news_pro_gk5/helper.php:110
JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:30
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 12.98 ms** **После последнего запроса: 188.30 ms** **Память запроса: 0.015 MB Память до запроса: 4.351 MB** **Выбрано строк: 12**
SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
LEFT JOIN p38xt_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND c.published = 1
AND c.trash = 0
AND i.access IN(1,1,5)
AND c.access IN(1,1,5)
AND i.catid IN (2,19,20,21,4,5,43,46)
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.created DESC
LIMIT 0, 12
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | NULL | index | item,catid | created | 5 | NULL | 26 | 1.12 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | shymkala_ru.i.catid | 1 | 46.67 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.6 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.2 ms |
| System lock | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| System lock | 0.1 ms |
| optimizing | 0.1 ms |
| statistics | 0.6 ms |
| preparing | 0.1 ms |
| Sorting result | 0.1 ms |
| executing | 0.0 ms |
| Sending data | 0.4 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.9 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.5 ms |
| Waiting for query cache lock | 0.1 ms |
| Sending data | 1.0 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.7 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.2 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.3 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.8 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 1.1 ms |
| Waiting for query cache lock | 0.0 ms |
| Sending data | 0.5 ms |
| end | 0.1 ms |
| query end | 0.0 ms |
| closing tables | 0.2 ms |
| freeing items | 0.3 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.1 ms |
| Waiting for query cache lock | 0.0 ms |
| freeing items | 0.0 ms |
| storing result in query cache | 0.2 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_noo_slider/helper.php:132
JROOT/modules/mod_noo_slider/helper.php:43
JROOT/modules/mod_noo_slider/mod_noo_slider.php:15
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:39
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:692
JROOT/libraries/joomla/document/html/html.php:471
JROOT/includes/application.php:291
JROOT/index.php:60
**Время запроса: 0.88 ms** **После последнего запроса: 94.83 ms** **Память запроса: 0.018 MB Память до запроса: 4.856 MB** **Выбрано строк: 11**
SELECT id
FROM p38xt_k2_categories
WHERE parent IN (28)
AND id NOT IN (28)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_k2_categories | NULL | ref | PRIMARY,category,parent,published,access,trash | parent | 5 | const | 14 | 46.67 | Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| Waiting for query cache lock | 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.3 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_k2/models/itemlist.php:622
JROOT/modules/mod_k2_content/helper.php:133
JROOT/modules/mod_k2_content/mod_k2_content.php:51
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/plugins/system/nootabs/nootabs.php:93
JROOT/plugins/system/nootabs/nootabs.php:46
JROOT/plugins/system/nootabs/nootabs.php:36
JROOT/plugins/system/nootabs/nootabs.php:29
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/includes/application.php:294
JROOT/index.php:60
**Время запроса: 0.81 ms** **После последнего запроса: 0.56 ms** **Память запроса: 0.019 MB Память до запроса: 4.878 MB** **Выбрано строк: 0**
SELECT id
FROM p38xt_k2_categories
WHERE parent IN (2,3,4,5,19,20,21,26,27,43,46)
AND id NOT IN (2,3,4,5,19,20,21,26,27,43,46)
AND published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p38xt_k2_categories | NULL | ref | PRIMARY,category,parent,published,access,trash | trash | 2 | const | 14 | 26.19 | Using where |
| Status | Duration |
|---|
| starting | 0.4 ms |
| Waiting for query cache lock | 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.2 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_k2/models/itemlist.php:622
JROOT/modules/mod_k2_content/helper.php:133
JROOT/modules/mod_k2_content/mod_k2_content.php:51
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/plugins/system/nootabs/nootabs.php:93
JROOT/plugins/system/nootabs/nootabs.php:46
JROOT/plugins/system/nootabs/nootabs.php:36
JROOT/plugins/system/nootabs/nootabs.php:29
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/includes/application.php:294
JROOT/index.php:60
**Время запроса: 1.12 ms** **После последнего запроса: 0.77 ms** **Память запроса: 0.018 MB Память до запроса: 4.897 MB** **Выбрано строк: 5**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items as i RIGHT JOIN p38xt_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
AND i.catid IN (28,2,3,4,5,19,20,21,26,27,43,46)
ORDER BY i.id DESC
LIMIT 0, 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | NULL | index | item,catid | PRIMARY | 4 | NULL | 10 | 1.15 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | shymkala_ru.i.catid | 1 | 46.67 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| Waiting for query cache lock | 0.0 ms |
| starting | 0.0 ms |
| checking query cache for query | 0.0 ms |
| checking privileges on cached | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| sending cached result to clien | 0.7 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_k2_content/helper.php:261
JROOT/modules/mod_k2_content/mod_k2_content.php:51
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/plugins/system/nootabs/nootabs.php:93
JROOT/plugins/system/nootabs/nootabs.php:46
JROOT/plugins/system/nootabs/nootabs.php:36
JROOT/plugins/system/nootabs/nootabs.php:29
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/includes/application.php:294
JROOT/index.php:60
**Время запроса: 0.57 ms** **После последнего запроса: 84.24 ms** **Память запроса: 0.017 MB Память до запроса: 5.038 MB** **Выбрано строк: 5**
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items as i RIGHT JOIN p38xt_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-10-31 04:12:27' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-10-31 04:12:27' )
ORDER BY i.id DESC
LIMIT 0, 5
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | NULL | index | item,catid | PRIMARY | 4 | NULL | 10 | 1.19 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | shymkala_ru.i.catid | 1 | 46.67 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| Waiting for query cache lock | 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.4 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_k2_content/helper.php:261
JROOT/modules/mod_k2_content/mod_k2_content.php:51
JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
JROOT/plugins/system/nootabs/nootabs.php:93
JROOT/plugins/system/nootabs/nootabs.php:46
JROOT/plugins/system/nootabs/nootabs.php:36
JROOT/plugins/system/nootabs/nootabs.php:29
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/includes/application.php:294
JROOT/index.php:60
**Время запроса: 1.31 ms** **После последнего запроса: 423.39 ms** **Память запроса: 0.003 MB Память до запроса: 4.690 MB**
UPDATE `p38xt_session`
SET `data` = 'WXvf2O6ILG_AerA4DZkPtMhHoj3J-SI4US55eW74SYbXXnxCLOSQHqAEu8FJ3rpPrmAsBYKIFgPRGDnd8K_5n5zFgVqG68Jy-hWA2o9v7d1g2LFMWcgKoDMncPOOje4zmpQ7eECVNTBMnwzR1WdJaVOmn9Mm4lUY_8VA-iTjRHS5DbCGdZoRswwgGUaJ2VfMlSufT6eoCtAgknqAwE05kzsi31GnD0ucs4kyoa82lf1pQKpG9daIqP7BCxEgPDXuWkJ7olOwjMc8QylezYZmkx61ipEe9yIHTCKCfMMrIuD0C-19HgW6NY-zEkHcjNxP0oKOJ1JXgNW0KbFWHJz1IN6libGL6StM1tEdoQzaBZLYt6dTfR14N96376RhD7Aqcvz1T8h0tt_QYYd5SpAkoc-2Vl3bIst8XHTeS8FCqpDrgftT8Ov62r76M5lHvgmA2NG3bWZVUPgBbEZUp9Jiv805_Z3vMyLS-Fb541Gt84KqK_AutQ83UU_dWAKXDr0OqHlZHfgRpJqIciEasoX3Z6f4Vs8T5OPUQ56YInWCQlGJXNiaKzdpdN_m_fufdK56dyr2m1vf9GpPBt9stI40VIVsv4uFmrmxt9ypaEcPJrhaKKteRB4t3-9Fb2iCXp0NEh2o_u0BFtvy_iCEOoVd9JYNHMXAYZwS8FuCnHZ1KbN6v_78exb1idafNY6BvcRF9aC_B0_m3-hEDrQ5waaIYFxzxDMsQkCyy39ZOFzzINdDvbqzq4z0E70j8-XNfB-Ij5l8p-13KuJjDb31kCACl1LHcOHtbmeEzxoH0NjBawMYQPcLk2Qz_IQFlGzRoEArQEZuXJjkDlNTu1_wEdEpmda6gPg7ll106PbiLYbgeXO62X6ifDkaYrRYrVD-goMEiHe4777sR2r4nRjr18FEj_4SGnAzo5nMsoW46ovqAvQERzpQfSFpcAtmrNWc1_JdBY9QDCtLzr_knWxQnYJ4WKnI4l_X7LcS1bjNH5oNz2SGrI8m4mDPkbMVzXRRu-seeekixxyEEkw_AE1QdGfNNJyHdMdL7aybDBzx2eY8FcXzemesXYdwmFtF3J51M5Fxwbex3e7zwqX56Q3YhOJYfnEgYAsYQXhQOmni029Xl_kWK9v_HIe7t8hi-AKi11nxYPs1ibqdq-m0fYReUKKCEYko3kWYLffaVQYOQboZGCRI4Ppu2b2skvbgfMroKwUetu0eCFT0bSqLH24Jve70DSaMk92QyPETNUwO-0cvhlcBwWbn_I8XL09QOIV2R9dngzRvx7-KbrTKwGNz8b53LZg0GvwB38QP07rI_vK6Bf4.'
, `time` = '1604117549'
WHERE `session_id` = 'v7vcm70364sf4hfecvdvqs2lq6'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | p38xt_session | NULL | range | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.1 ms |
| updating | 0.2 ms |
| end | 0.0 ms |
| Waiting for query cache lock | 0.0 ms |
| end | 0.4 ms |
| query end | 0.1 ms |
| closing tables | 0.0 ms |
| freeing items | 0.1 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/session/storage/database.php:85
**8 × SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid**
**5 × SELECT k2c.*
FROM p38xt_k2_categories AS k2c**
**4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM p38xt_extensions**
**4 × SELECT id
FROM p38xt_k2_categories**
**4 × SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
INNER JOIN p38xt_k2_categories AS c
ON c.id = i.catid**
**3 × SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM p38xt_k2_items as i RIGHT JOIN p38xt_k2_categories c
ON c.id = i.catid**
**2 × SELECT i.*,c.alias AS categoryalias
FROM p38xt_k2_items AS i
LEFT JOIN p38xt_k2_categories AS c
ON c.id = i.catid**
**1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM p38xt_modules AS m
LEFT JOIN p38xt_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p38xt_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT content.id AS id, content.alias AS alias, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.featured AS frontpage, content.access AS access, content.catid AS cid, content.video AS video, content.plugins AS plugins, categories.name AS catname, categories.image AS cat_image, categories.alias AS cat_alias, users.email AS author_email, content.created_by_alias AS author_alias, users.name AS author_username, content.created_by AS author_id, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count
FROM p38xt_k2_items AS content
LEFT JOIN p38xt_k2_categories AS categories
ON categories.id = content.catid
LEFT JOIN p38xt_users AS users
ON users.id = content.created_by
LEFT JOIN p38xt_k2_rating AS content_rating
ON content_rating.itemID = content.id**
**1 × SELECT COUNT(*)
FROM p38xt_content AS a
LEFT JOIN p38xt_categories AS c
ON c.id = a.catid
LEFT JOIN p38xt_users AS ua
ON ua.id = a.created_by
LEFT JOIN p38xt_users AS uam
ON uam.id = a.modified_by
LEFT JOIN p38xt_categories as parent
ON parent.id = c.parent_id
LEFT JOIN p38xt_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM p38xt_categories AS cat JOIN p38xt_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt**
**1 × SELECT content.id AS id
FROM p38xt_k2_items AS content**
**1 × SELECT b.rules
FROM p38xt_assets AS a
LEFT JOIN p38xt_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt**
**1 × SELECT id, rules
FROM `p38xt_viewlevels**
**1 × SELECT b.id
FROM p38xt_usergroups AS a
LEFT JOIN p38xt_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt**
**1 × SELECT `session_id`
FROM `p38xt_session`**
**1 × SELECT folder AS type, element AS name, params
FROM p38xt_extensions**
**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 p38xt_menu AS m
LEFT JOIN p38xt_extensions AS e
ON m.component_id = e.extension_id**
**1 × SELECT a.rules
FROM p38xt_assets AS a**
**1 × SELECT *
FROM p38xt_languages**
**1 × SELECT id, home, template, s.params
FROM p38xt_template_styles as s
LEFT JOIN p38xt_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id**
**1 × SELECT `data`
FROM `p38xt_session`**
