HỘI THẢO TIỀN GIANG

font size decrease font size increase font size
Print
Email
Media
Be the first to comment!

Rate this item

(0 votes)

Hội thảo Tiền Giang được diễn ra từ ngày 1 => 30 tháng 11/2020

Read 1865 times

Published in mientay1

Latest from BVTVHP

Media

More in this category: « Chiến Dịch ACTIVO SUPER 648WP

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Joomla! Debug Console

47 Queries Logged 37.0 ms

8 duplicate found!

4 duplicates: #10 #11 #40 #41

2 duplicates: #29 #30

2 duplicates: #45 #46

Query Time: 0.65 ms Query memory: 0.015 MB Memory before query: 0.831 MB Rows returned: 0
```
SELECT `data`

  FROM `hp_session`

  WHERE `session_id` = 'ikjeonn5tnsk86qlda9poghkf6'
```
Explain
EXPLAIN not possible on query: SELECT `data` FROM `hp_session` WHERE `session_id` = 'ikjeonn5tnsk86qlda9poghkf6'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:651
JROOT/libraries/joomla/session/session.php:589
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.40 ms After last query: 1.25 ms Query memory: 0.008 MB Memory before query: 0.887 MB
```
DELETE 

  FROM `hp_session`

  WHERE `time` < '1737573013'
```
Explain
EXPLAIN not possible on query: DELETE FROM `hp_session` WHERE `time` < '1737573013'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:756
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.38 ms After last query: 0.12 ms Query memory: 0.012 MB Memory before query: 0.899 MB Rows returned: 0
```
SELECT `session_id`

  FROM `hp_session`

  WHERE `session_id` = 'ikjeonn5tnsk86qlda9poghkf6' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `hp_session` WHERE `session_id` = 'ikjeonn5tnsk86qlda9poghkf6' LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.99 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 0.911 MB
```
INSERT INTO `hp_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('ikjeonn5tnsk86qlda9poghkf6', 0, '1737573913')
```
Explain
EXPLAIN not possible on query: INSERT INTO `hp_session` (`session_id`, `client_id`, `time`) VALUES ('ikjeonn5tnsk86qlda9poghkf6', 0, '1737573913')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.69 ms After last query: 1.57 ms Query memory: 0.024 MB Memory before query: 0.989 MB Rows returned: 35
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM hp_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM hp_extensions WHERE `type` = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.55 ms After last query: 0.86 ms Query memory: 0.014 MB Memory before query: 1.062 MB Rows returned: 1
```
SELECT b.id

  FROM hp_usergroups AS a

  LEFT JOIN hp_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1
```
Explain
EXPLAIN not possible on query: SELECT b.id FROM hp_usergroups AS a LEFT JOIN hp_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.45 ms After last query: 0.24 ms Query memory: 0.013 MB Memory before query: 1.082 MB Rows returned: 4
```
SELECT id, rules

  FROM `hp_viewlevels`
```
Explain
EXPLAIN not possible on query: SELECT id, rules FROM `hp_viewlevels`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.77 ms After last query: 0.19 ms Query memory: 0.013 MB Memory before query: 1.101 MB Rows returned: 57
```
SELECT folder AS type, element AS name, params

  FROM hp_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering
```
Explain
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM hp_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.50 ms After last query: 1.25 ms Query memory: 0.016 MB Memory before query: 1.204 MB Rows returned: 2
```
SELECT *

  FROM hp_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_languages WHERE published=1 ORDER BY ordering ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/plugins/system/languagefilter/languagefilter.php:62
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.51 ms After last query: 0.53 ms Query memory: 0.013 MB Memory before query: 1.227 MB Rows returned: 2
Duplicate queries: #11 #40 #41
```
SELECT a.element AS element

  FROM hp_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM hp_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:73
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.42 ms After last query: 0.11 ms Query memory: 0.013 MB Memory before query: 1.240 MB Rows returned: 2
Duplicate queries: #10 #40 #41
```
SELECT a.element AS element

  FROM hp_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM hp_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:73
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.47 ms After last query: 21.25 ms Query memory: 0.040 MB Memory before query: 1.676 MB Rows returned: 73
```
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 hp_menu AS m

  LEFT JOIN hp_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
```
Explain
EXPLAIN not possible on query: 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 hp_menu AS m LEFT JOIN hp_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/plugins/system/languagefilter/languagefilter.php:100
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.97 ms After last query: 15.32 ms Query memory: 0.017 MB Memory before query: 3.420 MB Rows returned: 1
```
SELECT id 
  FROM hp_k2_items 
  WHERE alias = 'hội-thảo-tiền-giang'
```
Explain
EXPLAIN not possible on query: SELECT id FROM hp_k2_items WHERE alias = 'hội-thảo-tiền-giang'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:503
JROOT/components/com_k2/router.php:353
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.53 ms After last query: 0.45 ms Query memory: 0.024 MB Memory before query: 3.454 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM hp_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM hp_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/k2/k2.php:389
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.44 ms After last query: 0.28 ms Query memory: 0.018 MB Memory before query: 3.461 MB
```
UPDATE `hp_extensions`

  SET `params` = '{\"mediaversion\":\"8ff7fc2c859ad203e34cb8c5ce089b3f\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `hp_extensions` SET `params` = '{\"mediaversion\":\"8ff7fc2c859ad203e34cb8c5ce089b3f\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/k2/k2.php:389
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.76 ms After last query: 2.90 ms Query memory: 0.027 MB Memory before query: 3.654 MB Rows returned: 4
```
SELECT id, home, template, s.params

  FROM hp_template_styles as s

  LEFT JOIN hp_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT id, home, template, s.params FROM hp_template_styles as s LEFT JOIN hp_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/html/html.php:334
JROOT/libraries/cms/html/html.php:680
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/libraries/cms/html/jquery.php:53
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/administrator/components/com_k2/helpers/html.php:240
JROOT/plugins/system/k2/k2.php:405
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.45 ms After last query: 8.08 ms Query memory: 0.015 MB Memory before query: 4.214 MB Rows returned: 1
```
SELECT a.rules

  FROM hp_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
EXPLAIN not possible on query: SELECT a.rules FROM hp_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_k2/k2.php:16
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.24 ms After last query: 0.58 ms Query memory: 0.016 MB Memory before query: 4.237 MB Rows returned: 2
```
SELECT b.rules

  FROM hp_assets AS a

  LEFT JOIN hp_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
```
Explain
EXPLAIN not possible on query: SELECT b.rules FROM hp_assets AS a LEFT JOIN hp_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_k2/k2.php:16
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.60 ms After last query: 3.34 ms Query memory: 0.020 MB Memory before query: 4.479 MB Rows returned: 38
```
SELECT id 
  FROM hp_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)
```
Explain
EXPLAIN not possible on query: SELECT id FROM hp_k2_categories WHERE published=1 AND trash=0 AND access IN(1,1)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/helpers/permissions.php:225
JROOT/components/com_k2/views/item/view.html.php:35
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.56 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 4.498 MB Rows returned: 1
```
SELECT * 
  FROM hp_k2_items 
  WHERE id=354 
  AND language IN ('en-GB', '*') 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_k2_items WHERE id=354 AND language IN ('en-GB', '*') LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:33
JROOT/components/com_k2/views/item/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.15 ms After last query: 0.71 ms Query memory: 0.028 MB Memory before query: 4.599 MB Rows returned: 14
```
SHOW FULL COLUMNS 
  FROM `hp_k2_categories`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hp_k2_categories`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_k2/tables/k2category.php:34
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_k2/models/item.php:64
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.44 ms After last query: 0.79 ms Query memory: 0.023 MB Memory before query: 4.658 MB Rows returned: 1
```
SELECT * 
  FROM hp_k2_categories 
  WHERE id = '35'
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_k2_categories WHERE id = '35'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_k2/tables/k2category.php:61
JROOT/components/com_k2/models/item.php:65
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.64 ms After last query: 2.16 ms Query memory: 0.021 MB Memory before query: 4.783 MB Rows returned: 0
```
SELECT tag.*
            
  FROM hp_k2_tags AS tag
            JOIN hp_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 354
            
  ORDER BY xref.id ASC
```
Explain
EXPLAIN not possible on query: SELECT tag.* FROM hp_k2_tags AS tag JOIN hp_k2_tags_xref AS xref ON tag.id = xref.tagID WHERE tag.published = 1 AND xref.itemID = 354 ORDER BY xref.id ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1194
JROOT/components/com_k2/models/item.php:104
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.52 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 4.807 MB Rows returned: 0
```
SELECT * 
  FROM hp_k2_attachments 
  WHERE itemID=354
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_k2_attachments WHERE itemID=354
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1421
JROOT/components/com_k2/models/item.php:156
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.35 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.826 MB Rows returned: 0
```
SELECT * 
  FROM hp_k2_rating 
  WHERE itemID = 354
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_k2_rating WHERE itemID = 354
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:891
JROOT/components/com_k2/models/item.php:935
JROOT/components/com_k2/models/item.php:161
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.26 ms After last query: 0.51 ms Query memory: 0.034 MB Memory before query: 4.877 MB Rows returned: 16
```
SHOW FULL COLUMNS 
  FROM `hp_users`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hp_users`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/joomla/table/user.php:38
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/joomla/user/user.php:582
JROOT/libraries/joomla/user/user.php:866
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:203
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.72 ms After last query: 0.32 ms Query memory: 0.028 MB Memory before query: 4.944 MB Rows returned: 1
```
SELECT *

  FROM `hp_users`

  WHERE `id` = 190
```
Explain
EXPLAIN not possible on query: SELECT * FROM `hp_users` WHERE `id` = 190
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:84
JROOT/libraries/joomla/user/user.php:869
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:203
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.75 ms After last query: 2.42 ms Query memory: 0.025 MB Memory before query: 5.704 MB Rows returned: 1
```
SELECT `g`.`id`,`g`.`title`

  FROM `hp_usergroups` AS g

  INNER JOIN `hp_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 190
```
Explain
EXPLAIN not possible on query: SELECT `g`.`id`,`g`.`title` FROM `hp_usergroups` AS g INNER JOIN `hp_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 190
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:109
JROOT/libraries/joomla/user/user.php:869
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:203
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.50 ms After last query: 1.02 ms Query memory: 0.022 MB Memory before query: 5.729 MB Rows returned: 0
Duplicate queries: #30
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM hp_k2_users 
  WHERE userID=190
```
Explain
EXPLAIN not possible on query: SELECT id, gender, description, image, url, `group`, plugins FROM hp_k2_users WHERE userID=190
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1671
JROOT/components/com_k2/models/item.php:206
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.55 ms After last query: 0.46 ms Query memory: 0.023 MB Memory before query: 5.750 MB Rows returned: 0
Duplicate queries: #29
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM hp_k2_users 
  WHERE userID=190
```
Explain
EXPLAIN not possible on query: SELECT id, gender, description, image, url, `group`, plugins FROM hp_k2_users WHERE userID=190
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1671
JROOT/components/com_k2/helpers/utilities.php:45
JROOT/components/com_k2/models/item.php:207
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.62 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 5.770 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM hp_k2_comments 
  WHERE itemID=354 
  AND published=1
```
Explain
EXPLAIN not possible on query: SELECT COUNT(*) FROM hp_k2_comments WHERE itemID=354 AND published=1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1460
JROOT/components/com_k2/models/item.php:222
JROOT/components/com_k2/views/item/view.html.php:81
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.65 ms After last query: 12.01 ms Query memory: 0.030 MB Memory before query: 6.029 MB Rows returned: 36
```
SHOW FULL COLUMNS 
  FROM `hp_k2_items`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hp_k2_items`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_k2/tables/k2item.php:56
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_k2/models/item.php:816
JROOT/components/com_k2/views/item/view.html.php:144
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.54 ms After last query: 0.49 ms Query memory: 0.018 MB Memory before query: 6.125 MB
```
UPDATE hp_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '354'
```
Explain
EXPLAIN not possible on query: UPDATE hp_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '354'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_k2/models/item.php:817
JROOT/components/com_k2/views/item/view.html.php:144
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.15 ms After last query: 0.42 ms Query memory: 0.021 MB Memory before query: 6.142 MB Rows returned: 0
```
SELECT * 
  FROM hp_k2_comments 
  WHERE itemID=354 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_k2_comments WHERE itemID=354 AND published=1 ORDER BY commentDate DESC LIMIT 0, 10
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1442
JROOT/components/com_k2/views/item/view.html.php:239
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.35 ms After last query: 0.97 ms Query memory: 0.038 MB Memory before query: 6.176 MB Rows returned: 5
```
SELECT i.*, c.alias AS categoryalias
            
  FROM hp_k2_items AS i
            
  LEFT JOIN hp_k2_categories c 
  ON c.id = i.catid
            
  WHERE i.id != 354
                
  AND i.published = 1
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-01-22 19:25:13')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-01-22 19:25:13') 
  AND i.access IN(1,1) 
  AND i.language IN('en-GB', '*') 
  AND i.trash = 0
            
  AND i.created_by = 190
            
  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
```
Explain
EXPLAIN not possible on query: SELECT i.*, c.alias AS categoryalias FROM hp_k2_items AS i LEFT JOIN hp_k2_categories c ON c.id = i.catid WHERE i.id != 354 AND i.published = 1 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-01-22 19:25:13') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-01-22 19:25:13') AND i.access IN(1,1) AND i.language IN('en-GB', '*') AND i.trash = 0 AND i.created_by = 190 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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:585
JROOT/components/com_k2/views/item/view.html.php:278
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.88 ms After last query: 1.40 ms Query memory: 0.023 MB Memory before query: 6.272 MB Rows returned: 38
```
SELECT id, name, parent 
  FROM hp_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*') 
  ORDER BY parent
```
Explain
EXPLAIN not possible on query: SELECT id, name, parent FROM hp_k2_categories WHERE published=1 AND trash=0 AND access IN(1,1) AND language IN('en-GB', '*') ORDER BY parent
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:929
JROOT/components/com_k2/helpers/route.php:252
JROOT/components/com_k2/helpers/route.php:39
JROOT/components/com_k2/views/item/view.html.php:281
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.80 ms After last query: 2.22 ms Query memory: 0.027 MB Memory before query: 6.331 MB Rows returned: 0
```
SELECT *
                
  FROM hp_k2_items
                
  WHERE id != 354
                    
  AND catid = 35
                    
  AND ordering > 2
                    
  AND published = 1
                    
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-22 19:25:13')
                    
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-22 19:25:13')
                    
  AND access IN (1,1)
                    
  AND trash = 0
                    
  AND language IN ('en-GB', '*')
                
  ORDER BY ordering ASC 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_k2_items WHERE id != 354 AND catid = 35 AND ordering > 2 AND published = 1 AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-22 19:25:13') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-22 19:25:13') AND access IN (1,1) AND trash = 0 AND language IN ('en-GB', '*') ORDER BY ordering ASC LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1653
JROOT/components/com_k2/views/item/view.html.php:303
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.82 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 6.351 MB Rows returned: 1
```
SELECT *
                
  FROM hp_k2_items
                
  WHERE id != 354
                    
  AND catid = 35
                    
  AND ordering < 2
                    
  AND published = 1
                    
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-22 19:25:13')
                    
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-22 19:25:13')
                    
  AND access IN (1,1)
                    
  AND trash = 0
                    
  AND language IN ('en-GB', '*')
                
  ORDER BY ordering DESC 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT * FROM hp_k2_items WHERE id != 354 AND catid = 35 AND ordering < 2 AND published = 1 AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-01-22 19:25:13') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-01-22 19:25:13') AND access IN (1,1) AND trash = 0 AND language IN ('en-GB', '*') ORDER BY ordering DESC LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1595
JROOT/components/com_k2/views/item/view.html.php:339
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_k2/controllers/controller.php:19
JROOT/components/com_k2/controllers/item.php:78
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:64
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.55 ms After last query: 4.53 ms Query memory: 0.015 MB Memory before query: 6.407 MB Rows returned: 3
```
SELECT language,id

  FROM `hp_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
Explain
EXPLAIN not possible on query: SELECT language,id FROM `hp_menu` WHERE home = 1 AND published = 1 AND client_id = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:115
JROOT/plugins/system/languagefilter/languagefilter.php:611
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.48 ms After last query: 0.67 ms Query memory: 0.015 MB Memory before query: 6.426 MB Rows returned: 2
Duplicate queries: #10 #11 #41
```
SELECT a.element AS element

  FROM hp_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM hp_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:651
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.47 ms After last query: 0.13 ms Query memory: 0.015 MB Memory before query: 6.440 MB Rows returned: 2
Duplicate queries: #10 #11 #40
```
SELECT a.element AS element

  FROM hp_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM hp_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:651
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.43 ms After last query: 3.02 ms Query memory: 0.017 MB Memory before query: 6.529 MB Rows returned: 1
```
SELECT template_style_id 
  FROM hp_menu 
  WHERE id = 2004
```
Explain
EXPLAIN not possible on query: SELECT template_style_id FROM hp_menu WHERE id = 2004
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:184
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
JROOT/templates/sj_flooring/includes/frame_inc.php:31
JROOT/templates/sj_flooring/index.php:24
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.46 ms After last query: 0.13 ms Query memory: 0.017 MB Memory before query: 6.545 MB Rows returned: 1
```
SELECT id 
  FROM hp_template_styles 
  WHERE home = 1 
  AND client_id = 0
```
Explain
EXPLAIN not possible on query: SELECT id FROM hp_template_styles WHERE home = 1 AND client_id = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:188
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
JROOT/templates/sj_flooring/includes/frame_inc.php:31
JROOT/templates/sj_flooring/index.php:24
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.07 ms After last query: 1.49 ms Query memory: 0.025 MB Memory before query: 6.592 MB Rows returned: 1
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM hp_modules AS m

  LEFT JOIN hp_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN hp_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 <= '2025-01-22 19:25:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-22 19:25:13') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 2004 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering
```
Explain
EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM hp_modules AS m LEFT JOIN hp_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN hp_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 <= '2025-01-22 19:25:13') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-22 19:25:13') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 2004 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:179
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:116
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49
JROOT/templates/sj_flooring/includes/frame_inc.php:101
JROOT/templates/sj_flooring/index.php:24
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.45 ms After last query: 2.02 ms Query memory: 0.014 MB Memory before query: 6.694 MB Rows returned: 1
Duplicate queries: #46
```
SELECT home 
  FROM hp_menu 
  WHERE id=2004
```
Explain
EXPLAIN not possible on query: SELECT home FROM hp_menu WHERE id=2004
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:172
JROOT/templates/sj_flooring/index.php:94
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.45 ms After last query: 0.07 ms Query memory: 0.014 MB Memory before query: 6.707 MB Rows returned: 1
Duplicate queries: #45
```
SELECT home 
  FROM hp_menu 
  WHERE id=2004
```
Explain
EXPLAIN not possible on query: SELECT home FROM hp_menu WHERE id=2004
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:173
JROOT/templates/sj_flooring/index.php:94
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.60 ms After last query: 20.34 ms Query memory: 0.015 MB Memory before query: 6.876 MB Rows returned: 1
```
SELECT template

  FROM hp_template_styles

  WHERE home = 1 
  AND client_id = 0
```
Explain
EXPLAIN not possible on query: SELECT template FROM hp_template_styles WHERE home = 1 AND client_id = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/yt.php:280
JROOT/plugins/system/yt/yt.php:161
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1065
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT a.element AS element 
  FROM hp_extensions AS a

2 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM hp_k2_users

```
2 × SELECT home 
  FROM hp_menu
```

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM hp_extensions

2 × SELECT *                 
  FROM hp_k2_items

```
1 × SELECT * 
  FROM hp_k2_comments
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `hp_usergroups` AS g 
  INNER JOIN `hp_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `hp_users`
```

1 × SELECT i.*, c.alias AS categoryalias             
  FROM hp_k2_items AS i             
  LEFT JOIN hp_k2_categories c 
  ON c.id = i.catid

1 × SELECT COUNT(*) 
  FROM hp_k2_comments

1 × SELECT language,id 
  FROM `hp_menu`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM hp_modules AS m 
  LEFT JOIN hp_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN hp_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT template 
  FROM hp_template_styles

1 × SELECT id 
  FROM hp_template_styles

1 × SELECT template_style_id 
  FROM hp_menu

```
1 × SELECT * 
  FROM hp_k2_rating
```

1 × SELECT id, name, parent 
  FROM hp_k2_categories

1 × SELECT tag.*             
  FROM hp_k2_tags AS tag             JOIN hp_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

```
1 × SELECT * 
  FROM hp_languages
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM hp_menu AS m 
  LEFT JOIN hp_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT folder AS type, element AS name, params 
  FROM hp_extensions

1 × SELECT id, rules 
  FROM `hp_viewlevels

1 × SELECT `session_id` 
  FROM `hp_session`

1 × SELECT b.id 
  FROM hp_usergroups AS a 
  LEFT JOIN hp_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

```
1 × SELECT id 
  FROM hp_k2_items
```

1 × SELECT id, home, template, s.params 
  FROM hp_template_styles as s 
  LEFT JOIN hp_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM hp_k2_categories
```

1 × SELECT `data` 
  FROM `hp_session`

```
1 × SELECT * 
  FROM hp_k2_items
```

1 × SELECT id 
  FROM hp_k2_categories

1 × SELECT a.rules 
  FROM hp_assets AS a

1 × SELECT b.rules 
  FROM hp_assets AS a 
  LEFT JOIN hp_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT * 
  FROM hp_k2_attachments

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `hp_k2_items

1 × UPDATE hp_k2_items 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `hp_users

1 × SHOW FULL COLUMNS 
  FROM `hp_k2_categories

1 × INSERT INTO `hp_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('ikjeonn5tnsk86qlda9poghkf6', 0, '1737573913'

1 × UPDATE `hp_extensions` 
  SET `params` = '{\"mediaversion\":\"8ff7fc2c859ad203e34cb8c5ce089b3f\"}'

```
1 × DELETE  
  FROM `hp_session`
```

HỘI THẢO TIỀN GIANG

Latest from BVTVHP

Media

Leave a comment

FANPAGE

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

47 Queries Logged 37.0 ms

8 duplicate found!

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: