Query Time: 0.32 ms
SELECT `data`
FROM `ocean_session`
WHERE `session_id` = '3t83mlsf1teae2rk4gl9i242s2'
| 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: 0.36 ms After last query: 1.87 ms
SELECT `session_id`
FROM `ocean_session`
WHERE `session_id` = '3t83mlsf1teae2rk4gl9i242s2'
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: 6.61 ms After last query: 0.20 ms
INSERT INTO `ocean_session`
(`session_id`, `client_id`, `time`)
VALUES
('3t83mlsf1teae2rk4gl9i242s2', 0, '1506462592')
EXPLAIN not possible on query: INSERT INTO `ocean_session`
(`session_id`, `client_id`, `time`) VALUES
('3t83mlsf1teae2rk4gl9i242s2', 0, '1506462592')
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: 0.41 ms After last query: 5.39 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.34 ms After last query: 0.71 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: 0.59 ms After last query: 4.52 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: 10.85 ms After last query: 9.89 ms
UPDATE `ocean_extensions`
SET `params` = '{\"mediaversion\":\"fd046ac761308eeb78d5b67731607214\"}'
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: 1.75 ms After last query: 37.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 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 | onefordc_oneford.com.vn.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.62 ms After last query: 25.67 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.45 ms After last query: 30.69 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: 1.16 ms After last query: 0.70 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: 0.69 ms After last query: 16.01 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.49 ms After last query: 0.24 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.06 ms After last query: 0.93 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.34 ms After last query: 0.61 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: 0.76 ms After last query: 1.50 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: 0.64 ms After last query: 2.74 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 | 5 | 100.00 | Using where; Using filesort |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | onefordc_oneford.com.vn.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.36 ms After last query: 3.75 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.31 ms After last query: 0.11 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: 0.95 ms After last query: 1.56 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.38 ms After last query: 0.33 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.44 ms After last query: 4.96 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,onefordc_oneford.com.vn.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.41 ms After last query: 2.16 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.39 ms After last query: 0.23 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 | published | 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: 1.39 ms After last query: 6.88 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.38 ms After last query: 0.47 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.37 ms After last query: 0.28 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 | ref | itemID,published,latestComments | latestComments | 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: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: 4.22 ms After last query: 1.32 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 <= '2017-09-26 21:49:52' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-09-26 21:49:52' )
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 | onefordc_oneford.com.vn.c.id | 6 | 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: 0.91 ms After last query: 3.19 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 | 22 | 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: 0.93 ms After last query: 0.24 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 <= '2017-09-26 21:49:52' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-09-26 21:49:52' )
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 | onefordc_oneford.com.vn.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.42 ms After last query: 2.59 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.44 ms After last query: 0.26 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,onefordc_oneford.com.vn.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.43 ms After last query: 2.17 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.40 ms After last query: 0.21 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.57 ms After last query: 4.45 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 | published | 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.43 ms After last query: 0.66 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.45 ms After last query: 4.30 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.41 ms After last query: 0.70 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.43 ms After last query: 4.14 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.41 ms After last query: 4.32 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.70 ms After last query: 1.58 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 <= '2017-09-26 21:49:52' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2017-09-26 21:49:52' )
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 | 13 | 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.60 ms After last query: 0.48 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 <= '2017-09-26 21:49:52' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2017-09-26 21:49:52' )
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 | 13 | 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: 0.55 ms After last query: 6.52 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: 1.95 ms After last query: 0.53 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 <= '2017-09-26 21:49:52' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-09-26 21:49:52' )
| 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 | onefordc_oneford.com.vn.c.id | 6 | 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.37 ms After last query: 2.97 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.38 ms After last query: 0.09 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.07 ms After last query: 2.33 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 <= '2017-09-26 21:49:52')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-26 21:49:52')
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 | onefordc_oneford.com.vn.m.module,const | 1 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | onefordc_oneford.com.vn.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: 7.80 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.35 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.70 ms After last query: 59.14 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.00 ms After last query: 152.00 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 | onefordc_oneford.com.vn.c.id | 6 | 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:408
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.75 ms After last query: 0.23 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 <= '2017-09-26 21:49:52' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2017-09-26 21:49:52' )
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 | 8 | NULL | 5 | 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:408
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.63 ms After last query: 0.14 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 = 403 OR content.id = 395 OR content.id = 393 OR content.id = 392 OR content.id = 391)
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 | onefordc_oneford.com.vn.content.catid | 1 | 100.00 | Using where |
| 1 | SIMPLE | users | eq_ref | PRIMARY | PRIMARY | 4 | onefordc_oneford.com.vn.content.created_by | 1 | 100.00 | |
| 1 | SIMPLE | content_rating | eq_ref | PRIMARY | PRIMARY | 4 | onefordc_oneford.com.vn.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:408
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.52 ms After last query: 0.15 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 = 403 OR content.id = 395 OR content.id = 393 OR content.id = 392 OR content.id = 391 )
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 | latestComments | 4 | NULL | 3 | 100.00 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | content | eq_ref | PRIMARY | PRIMARY | 4 | onefordc_oneford.com.vn.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:408
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.42 ms After last query: 2.30 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:408
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.56 ms After last query: 45.32 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:408
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.36 ms After last query: 0.16 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.1 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 |
| After opening tables | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| 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:408
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.42 ms After last query: 0.13 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.1 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 |
| After opening tables | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| 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:408
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.44 ms After last query: 0.16 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 |
| After opening tables | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| 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:408
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.40 ms After last query: 0.15 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.1 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 |
| After opening tables | 0.0 ms |
| init | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| 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:408
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.62 ms After last query: 0.09 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 | onefordc_oneford.com.vn.c.ComponentTypeId | 1 | 100.00 | |
| 1 | SIMPLE | p | ref | ComponentId | ComponentId | 4 | onefordc_oneford.com.vn.c.ComponentId | 10 | 100.00 | Using where |
.jpg)
