Query Time: 0.44 ms
SELECT `data`
FROM `ocean_session`
WHERE `session_id` = '3tc3kfpe8es8vaijvgrd0ooiv5'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_session | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | |
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:658
JROOT/libraries/joomla/session/session.php:596
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:36
Query Time: 3.23 ms After last query: 2.41 ms
DELETE
FROM `ocean_session`
WHERE `time` < '1524745093'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_session | range | time | time | 45 | NULL | 1 | 100.00 | Using where |
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:36
Query Time: 0.47 ms After last query: 0.34 ms
SELECT `session_id`
FROM `ocean_session`
WHERE `session_id` = '3tc3kfpe8es8vaijvgrd0ooiv5'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_session | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | 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:36
Query Time: 0.96 ms After last query: 0.28 ms
INSERT INTO `ocean_session`
(`session_id`, `client_id`, `time`)
VALUES
('3tc3kfpe8es8vaijvgrd0ooiv5', 0, '1524748693')
EXPLAIN not possible on query: INSERT INTO `ocean_session`
(`session_id`, `client_id`, `time`) VALUES
('3tc3kfpe8es8vaijvgrd0ooiv5', 0, '1524748693')
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:36
Query Time: 1.18 ms After last query: 9.17 ms
SELECT b.id
FROM ocean_usergroups AS a
LEFT JOIN ocean_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | b | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 10 | 20.00 | 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:39
Query Time: 0.64 ms After last query: 1.27 ms
SELECT id, rules
FROM `ocean_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 100.00 | |
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:39
Query Time: 1.18 ms After last query: 8.44 ms
SELECT COUNT(*)
FROM `ocean_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_menu | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 124 | 100.00 | 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:70
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:39
Query Time: 2.11 ms After last query: 18.10 ms
UPDATE `ocean_extensions`
SET `params` = '{\"mediaversion\":\"ffb06bacb779dd2ed80ec16f1a614154\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_extensions | range | element_clientid,element_folder_clientid,extension | extension | 364 | NULL | 1 | 100.00 | Using where |
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/ytshortcodes/ytshortcodes.php:32
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:39
Query Time: 3.42 ms After last query: 68.28 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 ocean_menu AS m
LEFT JOIN ocean_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 | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 123 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | ototaivi_oneford.m.component_id | 1 | 100.00 | Using where |
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/administrator/components/com_sh404sef/classes/pageinfo.php:131
JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:103
JROOT/plugins/system/sh404sef/sh404sef.php:47
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php: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:39
Query Time: 0.90 ms After last query: 50.94 ms
SELECT `params`
FROM ocean_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
JROOT/administrator/components/com_sh404sef/helpers/general.php:111
JROOT/administrator/components/com_sh404sef/classes/config.php:560
JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
JROOT/plugins/system/sh404sef/sh404sef.php:56
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:39
Query Time: 0.82 ms After last query: 53.52 ms
SELECT a.rules
FROM ocean_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 | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
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:39
Query Time: 2.01 ms After last query: 1.53 ms
SELECT b.rules
FROM ocean_assets AS a
LEFT JOIN ocean_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 | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 152 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | b | ALL | idx_lft_rgt | NO INDEX KEY COULD BE USED | NULL | NULL | 489 | 90.39 | Using where |
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:39
Query Time: 1.42 ms After last query: 29.40 ms
SELECT id
FROM ocean_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_categories | range | category,published,access,trash | category | 8 | NULL | 37 | 13.51 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/helpers/permissions.php:261
JROOT/components/com_k2/views/item/view.html.php:36
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.79 ms After last query: 0.78 ms
SELECT *
FROM ocean_k2_items
WHERE id=368
AND language IN ('en-GB','*')
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_items | const | PRIMARY,language | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:36
JROOT/components/com_k2/views/item/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 1.88 ms After last query: 1.82 ms
SHOW FULL COLUMNS
FROM `ocean_k2_categories`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ocean_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/models/item.php:74
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.65 ms After last query: 1.31 ms
SELECT *
FROM ocean_k2_categories
WHERE id = '89'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
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/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 1.37 ms After last query: 3.63 ms
SELECT id, name, parent
FROM ocean_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
AND language IN('en-GB', '*')
ORDER BY parent
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_categories | range | category,published,access,trash,language | category | 8 | NULL | 37 | 13.51 | Using index condition; Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:1239
JROOT/components/com_k2/helpers/route.php:321
JROOT/components/com_k2/helpers/route.php:58
JROOT/components/com_k2/models/item.php:78
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 1.01 ms After last query: 8.62 ms
SELECT tag.*
FROM ocean_k2_tags AS tag
JOIN ocean_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 368
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 8 | 100.00 | Using where; Using filesort |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | ototaivi_oneford.xref.tagID | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1353
JROOT/components/com_k2/models/item.php:109
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.64 ms After last query: 8.22 ms
SELECT *
FROM ocean_k2_attachments
WHERE itemID=368
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_attachments | ref | itemID | itemID | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1642
JROOT/components/com_k2/models/item.php:190
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.54 ms After last query: 0.25 ms
SELECT *
FROM ocean_k2_rating
WHERE itemID = 368
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_rating | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:990
JROOT/components/com_k2/models/item.php:1046
JROOT/components/com_k2/models/item.php:196
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 1.81 ms After last query: 2.70 ms
SHOW FULL COLUMNS
FROM `ocean_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ocean_users`
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/user.php:38
JROOT/libraries/joomla/table/table.php:294
JROOT/libraries/joomla/user/user.php:533
JROOT/libraries/joomla/user/user.php:799
JROOT/libraries/joomla/user/user.php:218
JROOT/libraries/joomla/user/user.php:267
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.61 ms After last query: 0.84 ms
SELECT *
FROM `ocean_users`
WHERE `id` = 121
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/user.php:84
JROOT/libraries/joomla/user/user.php:802
JROOT/libraries/joomla/user/user.php:218
JROOT/libraries/joomla/user/user.php:267
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.84 ms After last query: 8.32 ms
SELECT `g`.`id`,`g`.`title`
FROM `ocean_usergroups` AS g
INNER JOIN `ocean_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 121
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | g | index | PRIMARY | idx_usergroup_title_lookup | 302 | NULL | 10 | 100.00 | Using index |
| 1 | SIMPLE | m | eq_ref | PRIMARY | PRIMARY | 8 | const,ototaivi_oneford.g.id | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/user.php:109
JROOT/libraries/joomla/user/user.php:802
JROOT/libraries/joomla/user/user.php:218
JROOT/libraries/joomla/user/user.php:267
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.67 ms After last query: 8.00 ms
SELECT id, gender, description, image, url, `
group`, plugins
FROM ocean_k2_users
WHERE userID=121
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/models/item.php:250
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.61 ms After last query: 0.52 ms
SELECT COUNT(*)
FROM ocean_k2_comments
WHERE itemID=368
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_comments | ref | itemID,published,latestComments | itemID | 4 | const | 1 | 100.00 | Using where |
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/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 15.54 ms After last query: 12.38 ms
SHOW FULL COLUMNS
FROM `ocean_k2_items`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ocean_k2_items`
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/k2item.php:56
JROOT/libraries/joomla/table/table.php:294
JROOT/components/com_k2/models/item.php:895
JROOT/components/com_k2/views/item/view.html.php:135
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.74 ms After last query: 1.32 ms
UPDATE ocean_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '368'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_items | range | PRIMARY | PRIMARY | 4 | NULL | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:1215
JROOT/components/com_k2/models/item.php:896
JROOT/components/com_k2/views/item/view.html.php:135
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.65 ms After last query: 0.80 ms
SELECT *
FROM ocean_k2_comments
WHERE itemID=368
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 3
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_comments | range | itemID,published,latestComments | latestComments | 4 | NULL | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1666
JROOT/components/com_k2/views/item/view.html.php:231
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 9.08 ms After last query: 2.63 ms
SELECT i.*, c.alias as categoryalias
FROM ocean_k2_items as i
LEFT JOIN ocean_k2_categories c
ON c.id = i.catid
WHERE i.id != 368
AND i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-04-26 13:18:13' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-26 13:18:13' )
AND i.access IN(1,1)
AND i.language IN('en-GB', '*')
AND i.trash = 0
AND i.created_by = 121
AND i.created_by_alias=''
AND c.published = 1
AND c.access IN(1,1)
AND c.language IN('en-GB', '*')
AND c.trash = 0
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | range | PRIMARY,category,published,access,trash,language | category | 8 | NULL | 37 | 13.51 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | i | ref | PRIMARY,item,catid,created_by,language | catid | 4 | ototaivi_oneford.c.id | 7 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:865
JROOT/components/com_k2/views/item/view.html.php:275
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 1.47 ms After last query: 7.34 ms
SELECT DISTINCT itemID
FROM ocean_k2_tags_xref
WHERE tagID IN (91,89,96,97,22)
AND itemID!=368
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_tags_xref | range | tagID,itemID | tagID | 4 | NULL | 26 | 100.00 | Using index condition; Using where; Using temporary |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:921
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 1.16 ms After last query: 0.30 ms
SELECT i.*, c.alias as categoryalias
FROM ocean_k2_items as i
LEFT JOIN ocean_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-04-26 13:18:13' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-26 13:18:13' )
AND i.access IN(1,1)
AND i.language IN('en-GB', '*')
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.language IN('en-GB', '*')
AND c.trash = 0
AND (i.id) IN (273,366,369,372,365,367,371,370)
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | range | PRIMARY,item,catid,language | PRIMARY | 4 | NULL | 8 | 75.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash,language | PRIMARY | 4 | ototaivi_oneford.i.catid | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:969
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.65 ms After last query: 4.79 ms
SELECT *
FROM `ocean_users`
WHERE `id` = 315
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/user.php:84
JROOT/libraries/joomla/user/user.php:802
JROOT/libraries/joomla/user/user.php:218
JROOT/libraries/joomla/user/user.php:267
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.62 ms After last query: 0.52 ms
SELECT `g`.`id`,`g`.`title`
FROM `ocean_usergroups` AS g
INNER JOIN `ocean_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 315
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | g | index | PRIMARY | idx_usergroup_title_lookup | 302 | NULL | 10 | 100.00 | Using index |
| 1 | SIMPLE | m | eq_ref | PRIMARY | PRIMARY | 8 | const,ototaivi_oneford.g.id | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/user.php:109
JROOT/libraries/joomla/user/user.php:802
JROOT/libraries/joomla/user/user.php:218
JROOT/libraries/joomla/user/user.php:267
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.52 ms After last query: 4.82 ms
SELECT id, gender, description, image, url, `
group`, plugins
FROM ocean_k2_users
WHERE userID=315
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/models/item.php:250
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.46 ms After last query: 0.41 ms
SELECT COUNT(*)
FROM ocean_k2_comments
WHERE itemID=372
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_comments | ref | itemID,published,latestComments | itemID | 4 | const | 1 | 100.00 | Using where |
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/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.60 ms After last query: 9.55 ms
SELECT COUNT(*)
FROM ocean_k2_comments
WHERE itemID=371
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_comments | ref | itemID,published,latestComments | itemID | 4 | const | 1 | 100.00 | Using where |
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/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.55 ms After last query: 1.30 ms
SELECT *
FROM ocean_k2_categories
WHERE id = '93'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
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/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.57 ms After last query: 9.33 ms
SELECT COUNT(*)
FROM ocean_k2_comments
WHERE itemID=370
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_comments | ref | itemID,published,latestComments | itemID | 4 | const | 1 | 100.00 | Using where |
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/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.46 ms After last query: 1.29 ms
SELECT *
FROM ocean_k2_categories
WHERE id = '92'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
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/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.56 ms After last query: 8.95 ms
SELECT COUNT(*)
FROM ocean_k2_comments
WHERE itemID=369
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_comments | ref | itemID,published,latestComments | itemID | 4 | const | 1 | 100.00 | Using where |
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/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.55 ms After last query: 9.07 ms
SELECT COUNT(*)
FROM ocean_k2_comments
WHERE itemID=367
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_comments | ref | itemID,published,latestComments | itemID | 4 | const | 1 | 100.00 | Using where |
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/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.87 ms After last query: 2.96 ms
SELECT *
FROM ocean_k2_items
WHERE id != 368
AND catid=89
AND ordering > 3
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-26 13:18:13' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-04-26 13:18:13' )
AND access IN(1,1)
AND trash=0
AND language IN ('en-GB','*')
ORDER BY ordering ASC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_items | ref | PRIMARY,item,catid,ordering,language | catid | 4 | const | 6 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1792
JROOT/components/com_k2/views/item/view.html.php:307
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 0.71 ms After last query: 0.80 ms
SELECT *
FROM ocean_k2_items
WHERE id != 368
AND catid=89
AND ordering < 3
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-26 13:18:13' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-04-26 13:18:13' )
AND access IN(1,1)
AND trash=0
AND language IN ('en-GB','*')
ORDER BY ordering DESC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_items | ref | PRIMARY,item,catid,ordering,language | catid | 4 | const | 6 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1747
JROOT/components/com_k2/views/item/view.html.php:348
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:681
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
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:39
Query Time: 2.60 ms After last query: 9.39 ms
SELECT m2.language, m2.id
FROM ocean_menu as m
INNER JOIN ocean_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN ocean_associations as a2
ON a.key=a2.key
INNER JOIN ocean_menu as m2
ON a2.id=m2.id
WHERE m.id=1059
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_menus/helpers/menus.php:236
JROOT/plugins/system/languagefilter/languagefilter.php:575
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:183
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:39
Query Time: 3.44 ms After last query: 1.00 ms
SELECT COUNT(*)
FROM ocean_k2_items as i RIGHT JOIN ocean_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
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 <= '2018-04-26 13:18:13' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-04-26 13:18:13' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | range | PRIMARY,category,published,access,trash,language | category | 8 | NULL | 37 | 13.51 | Using index condition; Using where |
| 1 | SIMPLE | i | ref | item,catid,language | catid | 4 | ototaivi_oneford.c.id | 7 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:592
JROOT/plugins/system/plg_sj_k2_listing_ajax/plg_sj_k2_listing_ajax.php:107
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:183
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:39
Query Time: 0.50 ms After last query: 4.00 ms
SELECT template_style_id
FROM ocean_menu
WHERE id = 1059
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_menu | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:241
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:61
JROOT/templates/oneford/includes/frame_inc.php:73
JROOT/templates/oneford/index.php:21
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.48 ms After last query: 0.14 ms
SELECT id
FROM ocean_template_styles
WHERE home = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_template_styles | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:249
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:61
JROOT/templates/oneford/includes/frame_inc.php:73
JROOT/templates/oneford/index.php:21
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 2.44 ms After last query: 2.51 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ocean_modules AS m
LEFT JOIN ocean_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ocean_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 <= '2018-04-26 13:18:13')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-26 13:18:13')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1059 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds,idx_language | published | 1 | const | 55 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | ototaivi_oneford.m.module,const | 1 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | ototaivi_oneford.m.id | 7 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/module/helper.php:364
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:502
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:375
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:229
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:97
JROOT/templates/oneford/includes/frame_inc.php:191
JROOT/templates/oneford/index.php:21
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.57 ms After last query: 8.57 ms
SELECT home
FROM ocean_menu
WHERE id=1059
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_menu | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219
JROOT/templates/oneford/index.php:82
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.41 ms After last query: 0.11 ms
SELECT home
FROM ocean_menu
WHERE id=1059
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_menu | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:221
JROOT/templates/oneford/index.php:82
JROOT/libraries/joomla/document/html/html.php:570
JROOT/libraries/joomla/document/html/html.php:628
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:985
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.83 ms After last query: 92.47 ms
SELECT template
FROM ocean_template_styles
WHERE home = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_template_styles | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/yt/yt.php:349
JROOT/plugins/system/yt/yt.php:183
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:989
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 1.69 ms After last query: 1429.92 ms
SELECT DISTINCT
c.id AS ID,
c.name AS name,
c.alias AS alias
FROM
ocean_k2_categories AS c
LEFT JOIN
ocean_k2_items AS content
ON
c.id = content.catid
WHERE
1=1
AND ( c.id = 77 OR c.id = 81 OR c.id = 78 OR c.id = 79 OR c.id = 80 OR c.id = 62 OR c.id = 65 OR c.id = 64 OR c.id = 58 OR c.id = 59 OR c.id = 66 OR c.id = 67)
AND
c.published = 1
AND
c.access <= 1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | ref | PRIMARY,category,published,access | category | 2 | const | 5 | 100.00 | Using index condition; Using where; Using temporary |
| 1 | SIMPLE | content | ref | catid | catid | 4 | ototaivi_oneford.c.id | 7 | 100.00 | Using where; Using index; Distinct |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php:95
JROOT/modules/mod_news_pro_gk4/helper.php:304
JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:29
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 3.37 ms After last query: 0.65 ms
SELECT
content.id AS IID,
content.catid AS cat_id,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.alias AS alias,
content.hits AS hits,
content.plugins AS plugins
FROM
ocean_k2_items AS content
WHERE
content.trash = 0
AND content.access <= 1
AND content.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2018-04-26 13:18:13' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2018-04-26 13:18:13' )
AND ( content.catid = 58 OR content.catid = 59 OR content.catid = 62 OR content.catid = 64 OR content.catid = 65 OR content.catid = 66 OR content.catid = 67 OR content.catid = 77 OR content.catid = 78 OR content.catid = 79 OR content.catid = 80 OR content.catid = 81 )
AND content.featured = 0
ORDER BY
content.created DESC
LIMIT
0,5;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | index | item,catid,featured | created | 5 | NULL | 6 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php:214
JROOT/modules/mod_news_pro_gk4/helper.php:307
JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:29
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 1.10 ms After last query: 0.49 ms
SELECT
content.id AS ID,
cats.name AS cat_name,
cats.alias AS cat_alias,
content.catid AS cat_id,
users.name AS author,
users.email AS author_email,
users.id AS author_id,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count
FROM
ocean_k2_items AS content
LEFT JOIN
ocean_k2_categories AS cats
ON cats.id = content.catid
LEFT JOIN
ocean_users AS users
ON users.id = content.created_by
LEFT JOIN
ocean_k2_rating AS content_rating
ON content.id = content_rating.itemID
WHERE
1=1
AND ( content.id = 427 OR content.id = 426 OR content.id = 425 OR content.id = 424 OR content.id = 423)
ORDER BY
content.created DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | content | range | PRIMARY | PRIMARY | 4 | NULL | 5 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | cats | eq_ref | PRIMARY | PRIMARY | 4 | ototaivi_oneford.content.catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | users | eq_ref | PRIMARY | PRIMARY | 4 | ototaivi_oneford.content.created_by | 1 | 100.00 | |
| 1 | SIMPLE | content_rating | eq_ref | PRIMARY | PRIMARY | 4 | ototaivi_oneford.content.id | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php:279
JROOT/modules/mod_news_pro_gk4/helper.php:307
JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:29
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.90 ms After last query: 0.44 ms
SELECT
content.id AS id,
COUNT(comments.itemID) AS count
FROM
ocean_k2_items AS content
LEFT JOIN
ocean_k2_comments AS comments
ON comments.itemID = content.id
WHERE
comments.published
AND ( content.id = 427 OR content.id = 426 OR content.id = 425 OR content.id = 424 OR content.id = 423 )
GROUP BY
comments.itemID
;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | comments | range | itemID,published,latestComments | published | 4 | NULL | 3 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | content | eq_ref | PRIMARY | PRIMARY | 4 | ototaivi_oneford.comments.itemID | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php:422
JROOT/modules/mod_news_pro_gk4/helper.php:308
JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:29
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.72 ms After last query: 6.92 ms
SELECT id, gender, description, image, url, `
group`, plugins
FROM ocean_k2_users
WHERE userID=316
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_k2_users | ref | userID | userID | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/helpers/utilities.php:65
JROOT/modules/mod_news_pro_gk4/tmpl/layout.parts.php:401
JROOT/modules/mod_news_pro_gk4/helper.php:610
JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:30
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 9.35 ms After last query: 150.44 ms
SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access
FROM ocean_rsform_forms
WHERE FormId='5'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_rsform_forms | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsform/helpers/rsform.php:150
JROOT/modules/mod_rsform/tmpl/default.php:14
JROOT/modules/mod_rsform/mod_rsform.php:26
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.86 ms After last query: 0.39 ms
SELECT `Lang`
FROM ocean_rsform_forms
WHERE FormId='5'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_rsform_forms | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| starting | 0.3 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| Table lock | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Unlocking tables | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| freeing items | 0.1 ms |
| updating status | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:3617
JROOT/administrator/components/com_rsform/helpers/rsform.php:190
JROOT/modules/mod_rsform/tmpl/default.php:14
JROOT/modules/mod_rsform/mod_rsform.php:26
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.66 ms After last query: 0.34 ms
SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams`
FROM ocean_rsform_forms
WHERE FormId='5'
AND `Published`='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_rsform_forms | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| Table lock | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Unlocking tables | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| freeing items | 0.1 ms |
| updating status | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:1556
JROOT/administrator/components/com_rsform/helpers/rsform.php:245
JROOT/modules/mod_rsform/tmpl/default.php:14
JROOT/modules/mod_rsform/mod_rsform.php:26
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.60 ms After last query: 0.40 ms
SELECT `Lang`
FROM ocean_rsform_forms
WHERE FormId='5'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_rsform_forms | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Status | Duration |
|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| Table lock | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Unlocking tables | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| freeing items | 0.1 ms |
| updating status | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:3617
JROOT/administrator/components/com_rsform/helpers/rsform.php:1559
JROOT/administrator/components/com_rsform/helpers/rsform.php:245
JROOT/modules/mod_rsform/tmpl/default.php:14
JROOT/modules/mod_rsform/mod_rsform.php:26
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.66 ms After last query: 0.27 ms
SELECT ComponentId
FROM ocean_rsform_components
WHERE ComponentTypeId='6'
AND FormId='5'
AND Published='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_rsform_components | ref | ComponentTypeId,FormId | ComponentTypeId | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| Table lock | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| freeing items | 0.1 ms |
| updating status | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:1465
JROOT/administrator/components/com_rsform/helpers/rsform.php:1579
JROOT/administrator/components/com_rsform/helpers/rsform.php:245
JROOT/modules/mod_rsform/tmpl/default.php:14
JROOT/modules/mod_rsform/mod_rsform.php:26
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 1.11 ms After last query: 0.22 ms
SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
Order
FROM ocean_rsform_properties p
LEFT JOIN ocean_rsform_components c
ON (c.ComponentId=p.ComponentId)
LEFT JOIN ocean_rsform_component_types ct
ON (ct.ComponentTypeId=c.ComponentTypeId)
WHERE c.FormId='5'
AND p.PropertyName='NAME'
AND c.Published='1'
ORDER BY c.
Order
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | ref | ComponentId,FormId | FormId | 4 | const | 6 | 100.00 | Using where; Using filesort |
| 1 | SIMPLE | ct | eq_ref | PRIMARY | PRIMARY | 4 | ototaivi_oneford.c.ComponentTypeId | 1 | 100.00 | |
| 1 | SIMPLE | p | ref | ComponentId | ComponentId | 4 | ototaivi_oneford.c.ComponentId | 10 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| Table lock | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sorting result | 0.1 ms |
| Sending data | 0.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| freeing items | 0.1 ms |
| updating status | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:1632
JROOT/administrator/components/com_rsform/helpers/rsform.php:245
JROOT/modules/mod_rsform/tmpl/default.php:14
JROOT/modules/mod_rsform/mod_rsform.php:26
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.89 ms After last query: 0.31 ms
SELECT `PropertyName`, `PropertyValue`, `ComponentId`
FROM ocean_rsform_properties
WHERE `ComponentId` IN (46,42,45)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | ocean_rsform_properties | range | ComponentId | ComponentId | 4 | NULL | 28 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.2 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| Table lock | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| freeing items | 0.1 ms |
| updating status | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/rsform.php:488
JROOT/administrator/components/com_rsform/helpers/rsform.php:1657
JROOT/administrator/components/com_rsform/helpers/rsform.php:245
JROOT/modules/mod_rsform/tmpl/default.php:14
JROOT/modules/mod_rsform/mod_rsform.php:26
JROOT/libraries/cms/module/helper.php:178
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:396
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:999
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:39
Query Time: 0.64 ms After last query: 0.56 ms
.jpg)
