Query Time: 0.42 ms
SELECT `data`
FROM `suze1_session`
WHERE `session_id` = 'n2lq6s8k3bq9h4lje932r2n2f6'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_session | const | PRIMARY | PRIMARY | 602 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:659
JROOT/libraries/joomla/session/session.php:597
JROOT/libraries/cms/application/cms.php:672
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.33 ms After last query: 12.19 ms
DELETE
FROM `suze1_session`
WHERE `time` < '1665014911'
EXPLAIN not possible on query: DELETE
FROM `suze1_session`
WHERE `time` < '1665014911'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:689
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.36 ms After last query: 0.25 ms
SELECT `session_id`
FROM `suze1_session`
WHERE `session_id` = 'n2lq6s8k3bq9h4lje932r2n2f6'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_session | const | PRIMARY | PRIMARY | 602 | const | 1 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.52 ms After last query: 0.24 ms
INSERT INTO `suze1_session`
(`session_id`, `client_id`, `time`)
VALUES
('n2lq6s8k3bq9h4lje932r2n2f6', 0, '1665015811')
EXPLAIN not possible on query: INSERT INTO `suze1_session`
(`session_id`, `client_id`, `time`) VALUES
('n2lq6s8k3bq9h4lje932r2n2f6', 0, '1665015811')
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.56 ms After last query: 20.57 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM suze1_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:541
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.23 ms After last query: 7.46 ms
SELECT b.id
FROM suze1_usergroups AS a
LEFT JOIN suze1_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:336
JROOT/libraries/joomla/access/access.php:405
JROOT/libraries/joomla/user/user.php:420
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.26 ms After last query: 2.27 ms
SELECT id, rules
FROM `suze1_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:422
JROOT/libraries/joomla/user/user.php:420
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 1.20 ms After last query: 0.25 ms
SELECT folder AS type, element AS name, params
FROM suze1_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | ref | extension | extension | 62 | const | 114 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.24 ms After last query: 26.13 ms
SELECT *
FROM suze1_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/language/helper.php:166
JROOT/plugins/system/languagefilter/languagefilter.php:67
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.39 ms After last query: 0.29 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM suze1_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/languagefilter/languagefilter.php:69
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.43 ms After last query: 1.51 ms
SELECT COUNT(*)
FROM `suze1_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_menu | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 231 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32
JROOT/plugins/system/languagefilter/languagefilter.php:71
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.31 ms After last query: 78.67 ms
SELECT `query`
FROM `suze1_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/admintools/admintools/main.php:488
JROOT/plugins/system/admintools/admintools/main.php:96
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.31 ms After last query: 7.59 ms
SELECT `value`
FROM `suze1_admintools_storage`
WHERE `key` = 'cparams'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_admintools_storage | const | PRIMARY | PRIMARY | 767 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_admintools/models/storage.php:97
JROOT/administrator/components/com_admintools/models/storage.php:49
JROOT/plugins/system/admintools/feature/httpsizer.php:26
JROOT/plugins/system/admintools/admintools/main.php:354
JROOT/plugins/system/admintools/admintools/main.php:99
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.41 ms After last query: 93.84 ms
SELECT template
FROM suze1_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:99
JROOT/plugins/system/rokcommon/rokcommon.php:57
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.16 ms After last query: 0.15 ms
SELECT template
FROM suze1_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:99
JROOT/plugins/system/rokcommon/rokcommon.php:57
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.27 ms After last query: 42.56 ms
SELECT extension, file, type
FROM suze1_rokcommon_configs
ORDER BY priority
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_rokcommon_configs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rokcommon/rokcommon.php:130
JROOT/plugins/system/rokcommon/rokcommon.php:78
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.62 ms After last query: 90.57 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM suze1_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/k2/k2.php:435
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.92 ms After last query: 31.31 ms
SHOW FULL COLUMNS
FROM `suze1_extensions`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `suze1_extensions`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:229
JROOT/libraries/joomla/table/table.php:150
JROOT/libraries/joomla/table/extension.php:31
JROOT/libraries/joomla/table/table.php:294
JROOT/plugins/system/roksprocket/roksprocket.php:46
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.33 ms After last query: 4.98 ms
SELECT `extension_id`
FROM `suze1_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:50
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.40 ms After last query: 0.37 ms
SELECT *
FROM suze1_extensions
WHERE `extension_id` = '10114'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:705
JROOT/plugins/system/roksprocket/roksprocket.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/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 1.16 ms After last query: 0.31 ms
SELECT `extension_id`
FROM `suze1_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:73
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.20 ms After last query: 0.32 ms
SELECT *
FROM suze1_extensions
WHERE `extension_id` = '10114'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:705
JROOT/plugins/system/roksprocket/roksprocket.php:77
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 4.12 ms After last query: 459.90 ms
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 suze1_menu AS m
LEFT JOIN suze1_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 230 | Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | Sql560032_2.m.component_id | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/menu/site.php:47
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:357
JROOT/libraries/cms/application/site.php:250
JROOT/libraries/cms/router/site.php:210
JROOT/libraries/cms/router/router.php:391
JROOT/libraries/cms/router/router.php:184
JROOT/libraries/cms/router/site.php:82
JROOT/libraries/cms/application/cms.php:1022
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.45 ms After last query: 35.31 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM suze1_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 1.09 ms After last query: 0.36 ms
UPDATE `suze1_extensions`
SET `params` = '{\"mediaversion\":\"69119e9815aed633dc9ff638c86db1ff\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `suze1_extensions`
SET `params` = '{\"mediaversion\":\"69119e9815aed633dc9ff638c86db1ff\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.61 ms After last query: 24.34 ms
SELECT id, home, template, s.params
FROM suze1_template_styles as s
LEFT JOIN suze1_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 | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | Sql560032_2.s.template,const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/site.php:457
JROOT/libraries/cms/html/html.php:336
JROOT/libraries/cms/html/html.php:682
JROOT/libraries/cms/html/html.php:238
JROOT/libraries/cms/html/html.php:140
JROOT/libraries/cms/html/behavior.php:63
JROOT/libraries/cms/html/html.php:238
JROOT/libraries/cms/html/html.php:140
JROOT/administrator/components/com_k2/helpers/html.php:76
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/cms/application/cms.php:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.18 ms After last query: 67.82 ms
SELECT a.rules
FROM suze1_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/user/user.php:356
JROOT/components/com_k2/k2.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.90 ms After last query: 4.81 ms
SELECT b.rules
FROM suze1_assets AS a
LEFT JOIN suze1_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 152 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | b | ALL | idx_lft_rgt | NO INDEX KEY COULD BE USED | NULL | NULL | 198 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/access/access.php:110
JROOT/libraries/joomla/user/user.php:365
JROOT/components/com_k2/k2.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 2.47 ms After last query: 52.15 ms
SELECT id
FROM suze1_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | ref | category,published,access,trash | category | 2 | const | 298 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/helpers/permissions.php:261
JROOT/components/com_k2/views/itemlist/view.html.php:29
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.78 ms After last query: 8.10 ms
SHOW FULL COLUMNS
FROM `suze1_k2_categories`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `suze1_k2_categories`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:229
JROOT/libraries/joomla/table/table.php:150
JROOT/administrator/components/com_k2/tables/k2category.php:34
JROOT/libraries/joomla/table/table.php:294
JROOT/components/com_k2/views/itemlist/view.html.php:41
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.34 ms After last query: 0.49 ms
SELECT *
FROM suze1_k2_categories
WHERE id = '166'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/views/itemlist/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.49 ms After last query: 3.76 ms
SELECT *
FROM suze1_k2_categories
WHERE id = '22'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/views/itemlist/view.html.php:116
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.66 ms After last query: 105.30 ms
SELECT *
FROM suze1_k2_categories
WHERE parent=166
AND published=1
AND trash=0
AND access IN(1,1,5)
AND language IN('en-GB', '*')
ORDER BY id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | ref | category,parent,published,access,trash,language | parent | 5 | const | 1 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:748
JROOT/components/com_k2/views/itemlist/view.html.php:173
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.55 ms After last query: 2.57 ms
SELECT id
FROM suze1_k2_categories
WHERE parent IN (166)
AND id NOT IN (166)
AND published=1
AND trash=0
AND access IN(1,1,5)
AND language IN('en-GB', '*')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | ref | PRIMARY,category,parent,published,access,trash,language | parent | 5 | const | 1 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:642
JROOT/components/com_k2/models/itemlist.php:122
JROOT/components/com_k2/views/itemlist/view.html.php:380
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 372.31 ms After last query: 0.53 ms
SELECT DISTINCT i.`id`,i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM suze1_k2_items as i RIGHT JOIN suze1_k2_categories AS c
ON c.id = i.catid
LEFT JOIN suze1_k2_additional_categories AS ca
ON ca.`itemID` = i.`id`
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 c.language IN ('en-GB','*')
AND i.language IN ('en-GB','*')
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-10-06 00:23:32' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-10-06 00:23:32' )
AND (c.id IN (166) OR ca.`catid` IN (166))
ORDER BY i.created DESC
LIMIT 0, 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | item,catid,language | item | 2 | const | 1053 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash,language | PRIMARY | 4 | Sql560032_2.i.catid | 1 | Using where |
| 1 | SIMPLE | ca | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 922 | Using where; Distinct |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:357
JROOT/components/com_k2/views/itemlist/view.html.php:380
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 451.27 ms After last query: 2.82 ms
SELECT COUNT(DISTINCT i.`id`)
FROM suze1_k2_items as i RIGHT JOIN suze1_k2_categories c
ON c.id = i.catid
LEFT JOIN suze1_k2_additional_categories AS ca
ON ca.`itemID` = i.`id`
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 c.language IN ('en-GB','*')
AND i.language IN ('en-GB','*')
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-10-06 00:23:32' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-10-06 00:23:32' )
AND (c.id IN (166) OR ca.`catid` IN (166))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | ref | item,catid,language | item | 2 | const | 1053 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash,language | PRIMARY | 4 | Sql560032_2.i.catid | 1 | Using where |
| 1 | SIMPLE | ca | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 922 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:592
JROOT/components/com_k2/views/itemlist/view.html.php:385
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.52 ms After last query: 21.53 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=166
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.57 ms After last query: 0.12 ms
SELECT *
FROM suze1_k2_extra_fields
WHERE `
group` = 6
AND published=1
AND (id IN (16,17,18,19,20,21,22) OR `type` = 'header')
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_extra_fields | ref | PRIMARY,group,published | group | 4 | const | 7 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1399
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.36 ms After last query: 5.51 ms
SELECT COUNT(*)
FROM suze1_k2_comments
WHERE itemID=1476
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.25 ms After last query: 21.82 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=166
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.31 ms After last query: 0.16 ms
SELECT *
FROM suze1_k2_extra_fields
WHERE `
group` = 6
AND published=1
AND (id IN (16,17,18,19,20,21,22) OR `type` = 'header')
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_extra_fields | ref | PRIMARY,group,published | group | 4 | const | 7 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1399
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.64 ms After last query: 6.20 ms
SELECT COUNT(*)
FROM suze1_k2_comments
WHERE itemID=1459
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.21 ms After last query: 28.73 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=166
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.26 ms After last query: 0.16 ms
SELECT *
FROM suze1_k2_extra_fields
WHERE `
group` = 6
AND published=1
AND (id IN (16,17,18,19,20,21,22) OR `type` = 'header')
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_extra_fields | ref | PRIMARY,group,published | group | 4 | const | 7 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1399
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.90 ms After last query: 7.34 ms
SELECT COUNT(*)
FROM suze1_k2_comments
WHERE itemID=1463
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.18 ms After last query: 46.40 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=166
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.22 ms After last query: 0.16 ms
SELECT *
FROM suze1_k2_extra_fields
WHERE `
group` = 6
AND published=1
AND (id IN (16,17,18,19,20,21,22) OR `type` = 'header')
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_extra_fields | ref | PRIMARY,group,published | group | 4 | const | 7 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1399
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.28 ms After last query: 7.31 ms
SELECT COUNT(*)
FROM suze1_k2_comments
WHERE itemID=1247
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.24 ms After last query: 48.58 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=166
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.22 ms After last query: 0.15 ms
SELECT *
FROM suze1_k2_extra_fields
WHERE `
group` = 6
AND published=1
AND (id IN (16,17,18,19,20,21,22) OR `type` = 'header')
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_extra_fields | ref | PRIMARY,group,published | group | 4 | const | 7 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1399
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.30 ms After last query: 9.25 ms
SELECT COUNT(*)
FROM suze1_k2_comments
WHERE itemID=763
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.24 ms After last query: 49.44 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=166
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.23 ms After last query: 0.15 ms
SELECT *
FROM suze1_k2_extra_fields
WHERE `
group` = 6
AND published=1
AND (id IN (16,17,18,19,20,21,22) OR `type` = 'header')
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_extra_fields | ref | PRIMARY,group,published | group | 4 | const | 7 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1399
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.32 ms After last query: 8.58 ms
SELECT COUNT(*)
FROM suze1_k2_comments
WHERE itemID=760
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.25 ms After last query: 46.35 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=166
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.22 ms After last query: 0.11 ms
SELECT *
FROM suze1_k2_extra_fields
WHERE `
group` = 6
AND published=1
AND (id IN (16,17,18,19,20,21,22) OR `type` = 'header')
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_extra_fields | ref | PRIMARY,group,published | group | 4 | const | 7 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1399
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.33 ms After last query: 5.47 ms
SELECT COUNT(*)
FROM suze1_k2_comments
WHERE itemID=762
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.45 ms After last query: 27.94 ms
SELECT *
FROM suze1_k2_categories
WHERE id = '159'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/models/item.php:75
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.34 ms After last query: 20.52 ms
SELECT extraFieldsGroup
FROM suze1_k2_categories
WHERE id=159
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | suze1_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1395
JROOT/components/com_k2/models/item.php:184
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_k2/views/itemlist/view.html.php:435
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
Query Time: 0.28 ms After last query: 0.17 ms
