Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 21.9 ms / 21.9 ms Memory: 0.194 MB / 0.41 MB Application: afterLoad

Time: 92.6 ms / 114.6 ms Memory: 1.894 MB / 2.31 MB Application: afterInitialise

Time: 54.3 ms / 168.9 ms Memory: 1.673 MB / 3.98 MB Application: afterRoute

Time: 2.7 ms / 171.6 ms Memory: 0.040 MB / 4.02 MB Application: beforeRenderComponent com_jshopping

Time: 85.9 ms / 257.5 ms Memory: 0.413 MB / 4.43 MB Application: afterRenderComponent com_jshopping

Time: 4.5 ms / 261.9 ms Memory: 0.009 MB / 4.44 MB Application: afterDispatch

Time: 89.9 ms / 351.9 ms Memory: 0.523 MB / 4.97 MB Application: beforeRenderModule mod_custom (Payment Footer)

Time: 18.9 ms / 370.8 ms Memory: 0.015 MB / 4.98 MB Application: afterRenderModule mod_custom (Payment Footer)

Time: 2.8 ms / 373.6 ms Memory: 0.000 MB / 4.98 MB Application: beforeRenderModule mod_custom (CAM KẾT CHUNG)

Time: 0.9 ms / 374.5 ms Memory: 0.007 MB / 4.99 MB Application: afterRenderModule mod_custom (CAM KẾT CHUNG)

Time: 2.5 ms / 377.0 ms Memory: 0.000 MB / 4.98 MB Application: beforeRenderModule mod_custom (Mạng xã hội)

Time: 0.9 ms / 377.8 ms Memory: 0.007 MB / 4.99 MB Application: afterRenderModule mod_custom (Mạng xã hội)

Time: 3.3 ms / 381.1 ms Memory: 0.004 MB / 4.99 MB Application: beforeRenderModule mod_menu (Hỗ trợ)

Time: 33.5 ms / 414.6 ms Memory: 0.077 MB / 5.07 MB Application: afterRenderModule mod_menu (Hỗ trợ)

Time: 4.5 ms / 419.1 ms Memory: 0.000 MB / 5.07 MB Application: beforeRenderModule mod_menu (Về Chúng Tôi)

Time: 7.2 ms / 426.3 ms Memory: 0.035 MB / 5.10 MB Application: afterRenderModule mod_menu (Về Chúng Tôi)

Time: 2.1 ms / 428.4 ms Memory: 0.000 MB / 5.09 MB Application: beforeRenderModule mod_custom (Uy Tín - Tận Tâm)

Time: 0.9 ms / 429.3 ms Memory: 0.007 MB / 5.10 MB Application: afterRenderModule mod_custom (Uy Tín - Tận Tâm)

Time: 5.7 ms / 435.0 ms Memory: 0.008 MB / 5.11 MB Application: beforeRenderModule mod_jshopping_latest_products (Hệ thống Smarthome)

Time: 82.4 ms / 517.4 ms Memory: 0.913 MB / 6.02 MB Application: afterRenderModule mod_jshopping_latest_products (Hệ thống Smarthome)

Time: 8.8 ms / 526.2 ms Memory: 0.000 MB / 5.95 MB Application: beforeRenderModule mod_vina_cmenu_jshopping (Danh mục sản phẩm)

Time: 135.0 ms / 661.2 ms Memory: 0.642 MB / 6.59 MB Application: afterRenderModule mod_vina_cmenu_jshopping (Danh mục sản phẩm)

Time: 2.2 ms / 663.4 ms Memory: 0.000 MB / 6.56 MB Application: beforeRenderModule mod_custom (TƯ VẤN LẮP ĐẶT)

Time: 0.8 ms / 664.2 ms Memory: 0.007 MB / 6.57 MB Application: afterRenderModule mod_custom (TƯ VẤN LẮP ĐẶT)

Time: 1.6 ms / 665.8 ms Memory: 0.004 MB / 6.57 MB Application: beforeRenderModule mod_vina_ticker_jshopping (Sản Phẩm Bán Chạy)

Time: 17.7 ms / 683.5 ms Memory: 0.214 MB / 6.79 MB Application: afterRenderModule mod_vina_ticker_jshopping (Sản Phẩm Bán Chạy)

Time: 2.3 ms / 685.8 ms Memory: 0.000 MB / 6.74 MB Application: beforeRenderModule mod_custom (CÔNG TRÌNH DỰ ÁN)

Time: 1.0 ms / 686.8 ms Memory: 0.007 MB / 6.74 MB Application: afterRenderModule mod_custom (CÔNG TRÌNH DỰ ÁN)

Time: 0.9 ms / 687.7 ms Memory: 0.000 MB / 6.73 MB Application: beforeRenderModule mod_vvisit_counter (Thống kê truy cập)

Time: 45.5 ms / 733.2 ms Memory: 0.492 MB / 7.22 MB Application: afterRenderModule mod_vvisit_counter (Thống kê truy cập)

Time: 1.2 ms / 734.4 ms Memory: 0.000 MB / 7.18 MB Application: beforeRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm -MOBILE)

Time: 18.9 ms / 753.3 ms Memory: 0.512 MB / 7.69 MB Application: afterRenderModule mod_vina_cmenu_jshopping (Danh Mục Sản Phẩm -MOBILE)

Time: 1.1 ms / 754.4 ms Memory: 0.000 MB / 7.64 MB Application: beforeRenderModule mod_jshopping_cart_ext (Mini Cart)

Time: 3.5 ms / 757.9 ms Memory: 0.013 MB / 7.65 MB Application: afterRenderModule mod_jshopping_cart_ext (Mini Cart)

Time: 0.1 ms / 758.0 ms Memory: 0.000 MB / 7.64 MB Application: beforeRenderModule mod_jshopping_search (Tìm kiếm sản phẩm banner)

Time: 2.9 ms / 760.9 ms Memory: 0.013 MB / 7.66 MB Application: afterRenderModule mod_jshopping_search (Tìm kiếm sản phẩm banner)

Time: 5.6 ms / 766.4 ms Memory: 0.021 MB / 7.68 MB Application: beforeRenderModule mod_custom (Banner slogan 3)

Time: 1.0 ms / 767.4 ms Memory: 0.007 MB / 7.69 MB Application: afterRenderModule mod_custom (Banner slogan 3)

Time: 2.9 ms / 770.3 ms Memory: 0.000 MB / 7.69 MB Application: beforeRenderModule mod_menu (Menu trên đầu trang chủ)

Time: 5.7 ms / 776.0 ms Memory: 0.032 MB / 7.72 MB Application: afterRenderModule mod_menu (Menu trên đầu trang chủ)

Time: 1.6 ms / 777.6 ms Memory: 0.000 MB / 7.71 MB Application: beforeRenderModule mod_custom (Số điện thoại menu top)

Time: 0.7 ms / 778.3 ms Memory: 0.007 MB / 7.72 MB Application: afterRenderModule mod_custom (Số điện thoại menu top)

Time: 11.5 ms / 789.8 ms Memory: 0.103 MB / 7.82 MB Application: afterRender

Database queries total: 217.7 ms

Memory Usage

Database Queries

93 Queries Logged 217.7 ms

40 duplicate found!

2 duplicates: #13 #14

2 duplicates: #46 #75

2 duplicates: #47 #76

2 duplicates: #48 #77

2 duplicates: #49 #78

2 duplicates: #50 #79

2 duplicates: #51 #80

2 duplicates: #52 #81

2 duplicates: #53 #82

2 duplicates: #54 #83

2 duplicates: #55 #84

2 duplicates: #56 #85

2 duplicates: #57 #86

2 duplicates: #58 #87

2 duplicates: #59 #88

2 duplicates: #60 #89

2 duplicates: #61 #90

2 duplicates: #62 #91

2 duplicates: #63 #92

2 duplicates: #64 #93

Query Time: 4.32 ms Query memory: 0.008 MB Memory before query: 0.909 MB
```
DELETE 

  FROM `veneno_session`

  WHERE `time` < '1742702105'
```
Explain
EXPLAIN not possible on query: DELETE FROM `veneno_session` WHERE `time` < '1742702105'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:818
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:412
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:65
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.66 ms After last query: 1.02 ms Query memory: 0.021 MB Memory before query: 0.931 MB Rows returned: 0
```
SELECT `data`

  FROM `veneno_session`

  WHERE `session_id` = 'tisvsrvnrnomjonkltrdl8tf32'
```
Explain
EXPLAIN not possible on query: SELECT `data` FROM `veneno_session` WHERE `session_id` = 'tisvsrvnrnomjonkltrdl8tf32'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:45
JROOT/libraries/joomla/session/handler/native.php:260
JROOT/libraries/joomla/session/handler/native.php:50
JROOT/libraries/joomla/session/handler/joomla.php:82
JROOT/libraries/joomla/session/session.php:648
JROOT/libraries/joomla/session/session.php:608
JROOT/libraries/joomla/session/session.php:486
JROOT/libraries/joomla/session/session.php:443
JROOT/libraries/cms/application/cms.php:825
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:412
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:65
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.62 ms After last query: 1.91 ms Query memory: 0.012 MB Memory before query: 0.984 MB Rows returned: 0
```
SELECT `session_id`

  FROM `veneno_session`

  WHERE `session_id` = 'tisvsrvnrnomjonkltrdl8tf32' 
  LIMIT 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `veneno_session` WHERE `session_id` = 'tisvsrvnrnomjonkltrdl8tf32' LIMIT 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:827
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:412
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:65
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 5.53 ms After last query: 0.26 ms Query memory: 0.009 MB Memory before query: 0.999 MB
```
INSERT INTO `veneno_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('tisvsrvnrnomjonkltrdl8tf32', 1, '1742705705', 0, '', 0)
```
Explain
EXPLAIN not possible on query: INSERT INTO `veneno_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('tisvsrvnrnomjonkltrdl8tf32', 1, '1742705705', 0, '', 0)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:216
JROOT/libraries/cms/application/cms.php:827
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:412
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:65
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.34 ms After last query: 10.22 ms Query memory: 0.016 MB Memory before query: 1.160 MB Rows returned: 1
```
SELECT b.id

  FROM veneno_usergroups AS a

  LEFT JOIN veneno_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 veneno_usergroups AS a LEFT JOIN veneno_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:978
JROOT/libraries/joomla/access/access.php:1047
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:293
JROOT/libraries/cms/plugin/helper.php:86
JROOT/libraries/cms/plugin/helper.php:128
JROOT/libraries/cms/application/site.php:603
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.99 ms After last query: 0.80 ms Query memory: 0.015 MB Memory before query: 1.180 MB Rows returned: 5
```
SELECT id, rules

  FROM `veneno_viewlevels`
```
Explain
EXPLAIN not possible on query: SELECT id, rules FROM `veneno_viewlevels`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:1064
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:293
JROOT/libraries/cms/plugin/helper.php:86
JROOT/libraries/cms/plugin/helper.php:128
JROOT/libraries/cms/application/site.php:603
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.69 ms After last query: 11.25 ms Query memory: 0.013 MB Memory before query: 1.604 MB Rows returned: 1
```
SELECT `enabled`

  FROM `veneno_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
```
Explain
EXPLAIN not possible on query: SELECT `enabled` FROM `veneno_extensions` WHERE `element` = 'com_akeeba' AND `type` = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/backuponupdate/backuponupdate.php:71
JROOT/libraries/cms/plugin/helper.php:230
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:682
JROOT/libraries/cms/application/site.php:685
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 4.53 ms After last query: 7.65 ms Query memory: 0.020 MB Memory before query: 1.832 MB
```
UPDATE `veneno_extensions`

  SET `params` = '{\"mediaversion\":\"0c2d0eb74b3628ac5a1de197512c21d9\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `veneno_extensions` SET `params` = '{\"mediaversion\":\"0c2d0eb74b3628ac5a1de197512c21d9\"}' 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:116
JROOT/libraries/cms/version/version.php:321
JROOT/libraries/cms/version/version.php:280
JROOT/libraries/joomla/factory.php:760
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/helix/core/helix.php:50
JROOT/plugins/system/helix/core/helix.php:36
JROOT/plugins/system/helix/helix.php:21
JROOT/libraries/joomla/event/event.php:70
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:683
JROOT/libraries/cms/application/site.php:685
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 7.90 ms After last query: 39.29 ms Query memory: 0.038 MB Memory before query: 2.828 MB Rows returned: 140
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/config.php:14
JROOT/components/com_jshopping/lib/factory.php:24
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 3.53 ms After last query: 2.82 ms Query memory: 0.066 MB Memory before query: 3.287 MB Rows returned: 1
```
SELECT *

  FROM veneno_jshopping_config

  WHERE `id` = '1'
```
Explain
EXPLAIN not possible on query: SELECT * FROM veneno_jshopping_config WHERE `id` = '1'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:729
JROOT/components/com_jshopping/lib/factory.php:30
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.00 ms After last query: 0.92 ms Query memory: 0.033 MB Memory before query: 3.302 MB Rows returned: 8
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_currencies`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_currencies`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/currency.php:14
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/lib/factory.php:548
JROOT/components/com_jshopping/tables/config.php:53
JROOT/components/com_jshopping/lib/factory.php:32
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 3.348 MB Rows returned: 1
```
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `veneno_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering
```
Explain
EXPLAIN not possible on query: SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `veneno_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/currency.php:22
JROOT/components/com_jshopping/lib/factory.php:549
JROOT/components/com_jshopping/tables/config.php:53
JROOT/components/com_jshopping/lib/factory.php:32
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.09 ms After last query: 0.36 ms Query memory: 0.036 MB Memory before query: 3.422 MB Rows returned: 53
Duplicate queries: #14
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_users`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/usershopbase.php:14
JROOT/components/com_jshopping/tables/usershop.php:15
JROOT/components/com_jshopping/lib/factory.php:47
JROOT/components/com_jshopping/tables/config.php:70
JROOT/components/com_jshopping/tables/config.php:299
JROOT/components/com_jshopping/lib/factory.php:35
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.12 ms After last query: 0.61 ms Query memory: 0.036 MB Memory before query: 3.588 MB Rows returned: 53
Duplicate queries: #13
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_users`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/usershopbase.php:14
JROOT/components/com_jshopping/models/userguest.php:16
JROOT/components/com_jshopping/lib/factory.php:66
JROOT/components/com_jshopping/tables/config.php:74
JROOT/components/com_jshopping/tables/config.php:299
JROOT/components/com_jshopping/lib/factory.php:35
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.03 ms After last query: 0.98 ms Query memory: 0.035 MB Memory before query: 3.755 MB Rows returned: 10
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_usergroups`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_usergroups`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/usergroup.php:14
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/models/userguest.php:30
JROOT/components/com_jshopping/lib/factory.php:67
JROOT/components/com_jshopping/tables/config.php:74
JROOT/components/com_jshopping/tables/config.php:299
JROOT/components/com_jshopping/lib/factory.php:35
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.90 ms After last query: 0.63 ms Query memory: 0.033 MB Memory before query: 3.829 MB Rows returned: 4
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_display_prices`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config_display_prices`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/configdisplayprice.php:14
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/tables/config.php:82
JROOT/components/com_jshopping/tables/config.php:299
JROOT/components/com_jshopping/lib/factory.php:35
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.49 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 3.866 MB Rows returned: 1
```
SELECT * 
  FROM `veneno_jshopping_config_display_prices`
```
Explain
EXPLAIN not possible on query: SELECT * FROM `veneno_jshopping_config_display_prices`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/configdisplayprice.php:33
JROOT/components/com_jshopping/tables/config.php:83
JROOT/components/com_jshopping/tables/config.php:299
JROOT/components/com_jshopping/lib/factory.php:35
JROOT/components/com_jshopping/lib/factory.php:143
JROOT/components/com_jshopping/lib/factory.php:166
JROOT/components/com_jshopping/lib/functions.php:1560
JROOT/components/com_jshopping/router.php:212
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 3.52 ms After last query: 3.72 ms Query memory: 0.024 MB Memory before query: 3.910 MB Rows returned: 76
```
select product_id as id, `alias_vi-VN` as alias 
  from veneno_jshopping_products 
  where `alias_vi-VN`!=''
```
Explain
EXPLAIN not possible on query: select product_id as id, `alias_vi-VN` as alias from veneno_jshopping_products where `alias_vi-VN`!=''
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/lib/factory.php:276
JROOT/plugins/jshoppingrouter/jshopping_product_seo/jshopping_product_seo.php:42
JROOT/libraries/joomla/event/event.php:70
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_jshopping/router.php:218
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:432
JROOT/libraries/cms/router/router.php:483
JROOT/libraries/cms/router/router.php:236
JROOT/libraries/cms/router/site.php:133
JROOT/libraries/cms/application/cms.php:1142
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.98 ms After last query: 1.20 ms Query memory: 0.027 MB Memory before query: 3.952 MB Rows returned: 4
```
select id,link 
  from veneno_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='vi-VN') 
  and access IN (1,1)
```
Explain
EXPLAIN not possible on query: select id,link from veneno_menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='vi-VN') and access IN (1,1)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/lib/shop_item_menu.php:136
JROOT/components/com_jshopping/lib/shop_item_menu.php:46
JROOT/components/com_jshopping/lib/shop_item_menu.php:39
JROOT/components/com_jshopping/router.php:15
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:519
JROOT/libraries/cms/router/site.php:489
JROOT/libraries/cms/router/router.php:282
JROOT/libraries/cms/router/site.php:149
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:46
JROOT/libraries/joomla/event/event.php:70
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1151
JROOT/libraries/cms/application/site.php:795
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.99 ms After last query: 39.81 ms Query memory: 0.016 MB Memory before query: 4.051 MB Rows returned: 2
```
select * 
  from veneno_jshopping_languages
```
Explain
EXPLAIN not possible on query: select * from veneno_jshopping_languages
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/lib/functions.php:290
JROOT/components/com_jshopping/loadparams.php:33
JROOT/components/com_jshopping/jshopping.php:16
JROOT/libraries/cms/component/helper.php:394
JROOT/libraries/cms/component/helper.php:369
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.48 ms After last query: 18.27 ms Query memory: 0.028 MB Memory before query: 4.196 MB Rows returned: 9
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_seo`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config_seo`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/seo.php:14
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/helpers/metadata.php:25
JROOT/components/com_jshopping/helpers/metadata.php:44
JROOT/components/com_jshopping/helpers/metadata.php:60
JROOT/components/com_jshopping/controllers/cart.php:89
JROOT/libraries/legacy/controller/legacy.php:709
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:394
JROOT/libraries/cms/component/helper.php:369
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 4.07 ms After last query: 0.36 ms Query memory: 0.020 MB Memory before query: 4.239 MB Rows returned: 1
```
SELECT id, alias, `title_vi-VN` as title, `keyword_vi-VN` as keyword, `description_vi-VN` as description 
  FROM `veneno_jshopping_config_seo` 
  where alias='cart'
```
Explain
EXPLAIN not possible on query: SELECT id, alias, `title_vi-VN` as title, `keyword_vi-VN` as keyword, `description_vi-VN` as description FROM `veneno_jshopping_config_seo` where alias='cart'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/seo.php:22
JROOT/components/com_jshopping/helpers/metadata.php:26
JROOT/components/com_jshopping/helpers/metadata.php:44
JROOT/components/com_jshopping/helpers/metadata.php:60
JROOT/components/com_jshopping/controllers/cart.php:89
JROOT/libraries/legacy/controller/legacy.php:709
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:394
JROOT/libraries/cms/component/helper.php:369
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.32 ms After last query: 8.10 ms Query memory: 0.025 MB Memory before query: 4.370 MB Rows returned: 5
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_statictext`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config_statictext`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/statictext.php:15
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/models/cartpreview.php:67
JROOT/components/com_jshopping/controllers/cart.php:98
JROOT/libraries/legacy/controller/legacy.php:709
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:394
JROOT/libraries/cms/component/helper.php:369
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 3.89 ms After last query: 0.22 ms Query memory: 0.018 MB Memory before query: 4.402 MB Rows returned: 1
```
SELECT id, alias, `text_vi-VN` as text 
  FROM `veneno_jshopping_config_statictext` 
  where alias='cart'
```
Explain
EXPLAIN not possible on query: SELECT id, alias, `text_vi-VN` as text FROM `veneno_jshopping_config_statictext` where alias='cart'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/statictext.php:23
JROOT/components/com_jshopping/models/cartpreview.php:68
JROOT/components/com_jshopping/controllers/cart.php:98
JROOT/libraries/legacy/controller/legacy.php:709
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:394
JROOT/libraries/cms/component/helper.php:369
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:265
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 5.48 ms After last query: 84.98 ms Query memory: 0.028 MB Memory before query: 4.821 MB Rows returned: 44
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM veneno_modules AS m

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

  LEFT JOIN veneno_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-03-23 04:55:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-23 04:55:05') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 153 OR mm.menuid <= 0)

  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 veneno_modules AS m LEFT JOIN veneno_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN veneno_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-03-23 04:55:05') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-23 04:55:05') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 153 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:413
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:356
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:84
JROOT/libraries/joomla/document/html.php:576
JROOT/plugins/system/helix/core/helix.php:735
JROOT/plugins/system/helix/core/helix.php:351
JROOT/plugins/system/helix/core/helix.php:448
JROOT/plugins/system/helix/core/helix.php:713
JROOT/templates/vina_veneno/index.php:55
JROOT/libraries/joomla/document/html.php:653
JROOT/libraries/joomla/document/html.php:715
JROOT/libraries/joomla/document/html.php:530
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.87 ms After last query: 127.52 ms Query memory: 0.032 MB Memory before query: 5.198 MB Rows returned: 50
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/product.php:15
JROOT/libraries/joomla/table/table.php:311
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:30
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.24 ms After last query: 1.55 ms Query memory: 0.033 MB Memory before query: 5.357 MB Rows returned: 11
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products_extra_fields`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_extra_fields`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/productfield.php:14
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/lib/factory.php:475
JROOT/components/com_jshopping/lib/functions.php:1110
JROOT/components/com_jshopping/lib/jtableauto.php:214
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:48
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.24 ms Query memory: 0.027 MB Memory before query: 5.410 MB Rows returned: 4
```
SELECT F.id, F.`name_vi-VN` as name, F.`description_vi-VN` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_vi-VN` as groupname, multilist 
  FROM `veneno_jshopping_products_extra_fields` as F 
  left join `veneno_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group 
  order by G.ordering, F.ordering
```
Explain
EXPLAIN not possible on query: SELECT F.id, F.`name_vi-VN` as name, F.`description_vi-VN` as description, F.allcats, F.type, F.cats, F.ordering, F.`group`, G.`name_vi-VN` as groupname, multilist FROM `veneno_jshopping_products_extra_fields` as F left join `veneno_jshopping_products_extra_field_groups` as G on G.id=F.group order by G.ordering, F.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/productfield.php:48
JROOT/components/com_jshopping/lib/factory.php:476
JROOT/components/com_jshopping/lib/functions.php:1110
JROOT/components/com_jshopping/lib/jtableauto.php:214
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:48
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 4.97 ms After last query: 0.23 ms Query memory: 0.026 MB Memory before query: 5.440 MB Rows returned: 7
```
SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2`  
  FROM `veneno_jshopping_products` AS prod
              
  INNER JOIN `veneno_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = prod.product_id
              
  LEFT JOIN `veneno_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
              
              
  WHERE prod.product_publish = '1' 
  AND cat.category_publish='1'  
  AND pr_cat.category_id IN (134) 
  AND prod.access IN (1,1) 
  AND cat.access IN (1,1)
              
  GROUP BY prod.product_id 
  ORDER BY prod.product_id DESC 
  LIMIT 8
```
Explain
EXPLAIN not possible on query: SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2` FROM `veneno_jshopping_products` AS prod INNER JOIN `veneno_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `veneno_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND pr_cat.category_id IN (134) AND prod.access IN (1,1) AND cat.access IN (1,1) GROUP BY prod.product_id ORDER BY prod.product_id DESC LIMIT 8
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:62
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.63 ms After last query: 1.15 ms Query memory: 0.031 MB Memory before query: 5.519 MB Rows returned: 3
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_taxes`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_taxes`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/tax.php:14
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/lib/factory.php:342
JROOT/components/com_jshopping/lib/functions.php:654
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:63
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.34 ms Query memory: 0.025 MB Memory before query: 5.556 MB Rows returned: 1
```
SELECT tax_id, tax_name, tax_value 
  FROM `veneno_jshopping_taxes`
```
Explain
EXPLAIN not possible on query: SELECT tax_id, tax_name, tax_value FROM `veneno_jshopping_taxes`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/tax.php:21
JROOT/components/com_jshopping/lib/factory.php:328
JROOT/components/com_jshopping/lib/factory.php:343
JROOT/components/com_jshopping/lib/functions.php:654
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:63
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.95 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 5.576 MB Rows returned: 1
```
select manufacturer_id as id, `name_vi-VN` as name, manufacturer_logo, manufacturer_url 
  from veneno_jshopping_manufacturers 
  where manufacturer_publish='1'
```
Explain
EXPLAIN not possible on query: select manufacturer_id as id, `name_vi-VN` as name, manufacturer_logo, manufacturer_url from veneno_jshopping_manufacturers where manufacturer_publish='1'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/lib/factory.php:401
JROOT/components/com_jshopping/lib/functions.php:656
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:63
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.89 ms After last query: 1.75 ms Query memory: 0.033 MB Memory before query: 5.629 MB Rows returned: 5
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products_extra_field_values`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_extra_field_values`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/productfieldvalue.php:15
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/lib/factory.php:484
JROOT/components/com_jshopping/lib/functions.php:799
JROOT/components/com_jshopping/lib/functions.php:724
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:63
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.30 ms Query memory: 0.025 MB Memory before query: 5.669 MB Rows returned: 0
```
SELECT id, `name_vi-VN` as name, field_id 
  FROM `veneno_jshopping_products_extra_field_values` 
  order by ordering
```
Explain
EXPLAIN not possible on query: SELECT id, `name_vi-VN` as name, field_id FROM `veneno_jshopping_products_extra_field_values` order by ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/productfieldvalue.php:26
JROOT/components/com_jshopping/lib/factory.php:485
JROOT/components/com_jshopping/lib/functions.php:799
JROOT/components/com_jshopping/lib/functions.php:724
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:63
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.52 ms After last query: 1.72 ms Query memory: 0.031 MB Memory before query: 5.717 MB Rows returned: 6
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_product_labels`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_product_labels`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/productlabel.php:14
JROOT/libraries/joomla/table/table.php:311
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/lib/functions.php:625
JROOT/components/com_jshopping/lib/functions.php:763
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:63
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.86 ms After last query: 0.36 ms Query memory: 0.024 MB Memory before query: 5.757 MB Rows returned: 3
```
SELECT id, image, `name_vi-VN` as name 
  FROM `veneno_jshopping_product_labels` 
  ORDER BY name
```
Explain
EXPLAIN not possible on query: SELECT id, image, `name_vi-VN` as name FROM `veneno_jshopping_product_labels` ORDER BY name
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/productlabel.php:22
JROOT/components/com_jshopping/lib/functions.php:626
JROOT/components/com_jshopping/lib/functions.php:763
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:63
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.73 ms After last query: 1.21 ms Query memory: 0.031 MB Memory before query: 5.806 MB Rows returned: 0
```
select category_id as id, `alias_vi-VN` as alias 
  from veneno_jshopping_categories 
  where `alias_vi-VN`!=''
```
Explain
EXPLAIN not possible on query: select category_id as id, `alias_vi-VN` as alias from veneno_jshopping_categories where `alias_vi-VN`!=''
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/lib/factory.php:242
JROOT/components/com_jshopping/router.php:72
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:519
JROOT/libraries/cms/router/site.php:489
JROOT/libraries/cms/router/router.php:282
JROOT/libraries/cms/router/site.php:149
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_jshopping/lib/functions.php:488
JROOT/components/com_jshopping/lib/functions.php:438
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:67
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.25 ms After last query: 11.87 ms Query memory: 0.024 MB Memory before query: 5.856 MB Rows returned: 1
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
				 
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=416 
  ORDER BY sort, I.ordering
```
Explain
EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `veneno_jshopping_products_images` as I left join `veneno_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id=416 ORDER BY sort, I.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:342
JROOT/templates/vina_veneno/html/mod_jshopping_latest_products/default.php:9
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:102
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.95 ms After last query: 0.96 ms Query memory: 0.024 MB Memory before query: 5.887 MB Rows returned: 1
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
				 
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=415 
  ORDER BY sort, I.ordering
```
Explain
EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `veneno_jshopping_products_images` as I left join `veneno_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id=415 ORDER BY sort, I.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:342
JROOT/templates/vina_veneno/html/mod_jshopping_latest_products/default.php:9
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:102
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.89 ms After last query: 0.71 ms Query memory: 0.024 MB Memory before query: 5.910 MB Rows returned: 1
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
				 
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=414 
  ORDER BY sort, I.ordering
```
Explain
EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `veneno_jshopping_products_images` as I left join `veneno_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id=414 ORDER BY sort, I.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:342
JROOT/templates/vina_veneno/html/mod_jshopping_latest_products/default.php:9
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:102
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.95 ms After last query: 0.70 ms Query memory: 0.024 MB Memory before query: 5.934 MB Rows returned: 1
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
				 
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=412 
  ORDER BY sort, I.ordering
```
Explain
EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `veneno_jshopping_products_images` as I left join `veneno_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id=412 ORDER BY sort, I.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:342
JROOT/templates/vina_veneno/html/mod_jshopping_latest_products/default.php:9
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:102
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.90 ms After last query: 0.72 ms Query memory: 0.024 MB Memory before query: 5.957 MB Rows returned: 1
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
				 
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=411 
  ORDER BY sort, I.ordering
```
Explain
EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `veneno_jshopping_products_images` as I left join `veneno_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id=411 ORDER BY sort, I.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:342
JROOT/templates/vina_veneno/html/mod_jshopping_latest_products/default.php:9
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:102
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.05 ms After last query: 0.70 ms Query memory: 0.024 MB Memory before query: 5.981 MB Rows returned: 1
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
				 
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=410 
  ORDER BY sort, I.ordering
```
Explain
EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `veneno_jshopping_products_images` as I left join `veneno_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id=410 ORDER BY sort, I.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:342
JROOT/templates/vina_veneno/html/mod_jshopping_latest_products/default.php:9
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:102
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.96 ms After last query: 0.76 ms Query memory: 0.024 MB Memory before query: 6.004 MB Rows returned: 1
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
				 
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=409 
  ORDER BY sort, I.ordering
```
Explain
EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `veneno_jshopping_products_images` as I left join `veneno_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id=409 ORDER BY sort, I.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:342
JROOT/templates/vina_veneno/html/mod_jshopping_latest_products/default.php:9
JROOT/modules/mod_jshopping_latest_products/mod_jshopping_latest_products.php:102
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.07 ms After last query: 18.99 ms Query memory: 0.030 MB Memory before query: 6.028 MB Rows returned: 25
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_categories`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_categories`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:244
JROOT/libraries/joomla/table/table.php:163
JROOT/components/com_jshopping/tables/category.php:15
JROOT/libraries/joomla/table/table.php:311
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:129
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 52.43 ms After last query: 0.35 ms Query memory: 0.023 MB Memory before query: 6.107 MB Rows returned: 9
Duplicate queries: #75
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '0'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '0' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:131
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.79 ms After last query: 12.41 ms Query memory: 0.026 MB Memory before query: 6.161 MB Rows returned: 0
Duplicate queries: #76
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '1'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '1' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.34 ms After last query: 0.24 ms Query memory: 0.028 MB Memory before query: 6.191 MB Rows returned: 0
Duplicate queries: #77
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 43.22 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 6.211 MB Rows returned: 0
Duplicate queries: #78
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '105'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '105' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.74 ms After last query: 0.41 ms Query memory: 0.028 MB Memory before query: 6.241 MB Rows returned: 0
Duplicate queries: #79
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '105'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '105' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.18 ms Query memory: 0.026 MB Memory before query: 6.260 MB Rows returned: 0
Duplicate queries: #80
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '113'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '113' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 0.21 ms Query memory: 0.028 MB Memory before query: 6.290 MB Rows returned: 0
Duplicate queries: #81
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '113'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '113' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.17 ms Query memory: 0.026 MB Memory before query: 6.310 MB Rows returned: 0
Duplicate queries: #82
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '134'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '134' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.21 ms Query memory: 0.028 MB Memory before query: 6.339 MB Rows returned: 0
Duplicate queries: #83
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '134'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '134' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.63 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 6.359 MB Rows returned: 0
Duplicate queries: #84
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '135'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '135' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 6.389 MB Rows returned: 0
Duplicate queries: #85
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '135'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '135' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.59 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 6.408 MB Rows returned: 0
Duplicate queries: #86
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '136'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '136' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.34 ms Query memory: 0.028 MB Memory before query: 6.438 MB Rows returned: 0
Duplicate queries: #87
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '136'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '136' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.49 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 6.457 MB Rows returned: 0
Duplicate queries: #88
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '137'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '137' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.21 ms Query memory: 0.028 MB Memory before query: 6.487 MB Rows returned: 0
Duplicate queries: #89
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '137'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '137' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 6.507 MB Rows returned: 0
Duplicate queries: #90
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '140'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '140' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.28 ms Query memory: 0.028 MB Memory before query: 6.536 MB Rows returned: 0
Duplicate queries: #91
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '140'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '140' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.57 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 6.556 MB Rows returned: 0
Duplicate queries: #92
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '141'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '141' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.21 ms After last query: 0.22 ms Query memory: 0.028 MB Memory before query: 6.586 MB Rows returned: 0
Duplicate queries: #93
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '141'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '141' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/vertical.php:97
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 4.06 ms After last query: 9.61 ms Query memory: 0.030 MB Memory before query: 6.637 MB Rows returned: 5
```
SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2`  
  FROM `veneno_jshopping_products` AS prod
                  
  INNER JOIN `veneno_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = prod.product_id
                  
  LEFT JOIN `veneno_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                  
                  
  WHERE prod.product_publish=1 
  AND cat.category_publish=1  
  AND prod.access IN (1,1) 
  AND cat.access IN (1,1)
                  
  GROUP BY prod.product_id 
				  
  ORDER BY prod.hits 
				  desc 
  LIMIT 5
```
Explain
EXPLAIN not possible on query: SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2` FROM `veneno_jshopping_products` AS prod INNER JOIN `veneno_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `veneno_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.access IN (1,1) AND cat.access IN (1,1) GROUP BY prod.product_id ORDER BY prod.hits desc LIMIT 5
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/product.php:991
JROOT/modules/mod_vina_ticker_jshopping/helper.php:88
JROOT/modules/mod_vina_ticker_jshopping/helper.php:31
JROOT/modules/mod_vina_ticker_jshopping/mod_vina_ticker_jshopping.php:31
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.78 ms After last query: 47.08 ms Query memory: 0.019 MB Memory before query: 7.040 MB
```
CREATE TABLE IF NOT EXISTS veneno_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
```
Explain
EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS veneno_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1404
JROOT/modules/mod_vvisit_counter/helper.php:482
JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.64 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 7.060 MB Rows returned: 1
```
SELECT count( * ) AS records, MAX( id ) AS max 
  FROM veneno_vvisitcounter
```
Explain
EXPLAIN not possible on query: SELECT count( * ) AS records, MAX( id ) AS max FROM veneno_vvisitcounter
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1417
JROOT/modules/mod_vvisit_counter/helper.php:482
JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.25 ms Query memory: 0.019 MB Memory before query: 7.080 MB
```
DELETE 
  FROM veneno_vvisitcounter 
  WHERE id<='182742'
```
Explain
EXPLAIN not possible on query: DELETE FROM veneno_vvisitcounter WHERE id<='182742'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1560
JROOT/modules/mod_vvisit_counter/helper.php:482
JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.79 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 7.100 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM veneno_vvisitcounter 
  WHERE ip=UNHEX(SHA1('18.97.9.170')) 
  AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
```
Explain
EXPLAIN not possible on query: SELECT COUNT(*) FROM veneno_vvisitcounter WHERE ip=UNHEX(SHA1('18.97.9.170')) AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1612
JROOT/modules/mod_vvisit_counter/helper.php:482
JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.15 ms After last query: 0.28 ms Query memory: 0.019 MB Memory before query: 7.120 MB
```
INSERT INTO veneno_vvisitcounter ( tm, ip, data ) 
  VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.97.9.170')) , NULL )
```
Explain
EXPLAIN not possible on query: INSERT INTO veneno_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.97.9.170')) , NULL )
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1651
JROOT/modules/mod_vvisit_counter/helper.php:482
JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.65 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 7.142 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM veneno_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
  AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
```
Explain
EXPLAIN not possible on query: SELECT COUNT(*) FROM veneno_vvisitcounter WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1920
JROOT/modules/mod_vvisit_counter/helper.php:763
JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.92 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 7.162 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM veneno_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) 
  AND UNIX_TIMESTAMP(DATE(NOW()))
```
Explain
EXPLAIN not possible on query: SELECT COUNT(*) FROM veneno_vvisitcounter WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) AND UNIX_TIMESTAMP(DATE(NOW()))
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1935
JROOT/modules/mod_vvisit_counter/helper.php:774
JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.81 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 7.183 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM veneno_vvisitcounter 
  WHERE tm BETWEEN 1742144400 
  AND 1742749200
```
Explain
EXPLAIN not possible on query: SELECT COUNT(*) FROM veneno_vvisitcounter WHERE tm BETWEEN 1742144400 AND 1742749200
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1979
JROOT/modules/mod_vvisit_counter/helper.php:784
JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.12 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 7.204 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM veneno_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01")) 
  AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)
```
Explain
EXPLAIN not possible on query: SELECT COUNT(*) FROM veneno_vvisitcounter WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01")) AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_vvisit_counter/helper.php:1994
JROOT/modules/mod_vvisit_counter/helper.php:808
JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/document/renderer/html/module.php:93
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.37 ms Query memory: 0.023 MB Memory before query: 7.217 MB Rows returned: 9
Duplicate queries: #46
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '0'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '0' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:131
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.72 ms After last query: 2.63 ms Query memory: 0.026 MB Memory before query: 7.264 MB Rows returned: 0
Duplicate queries: #47
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '1'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '1' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 0.27 ms Query memory: 0.028 MB Memory before query: 7.294 MB Rows returned: 0
Duplicate queries: #48
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 7.313 MB Rows returned: 0
Duplicate queries: #49
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '105'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '105' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.60 ms After last query: 0.29 ms Query memory: 0.028 MB Memory before query: 7.343 MB Rows returned: 0
Duplicate queries: #50
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '105'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '105' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.66 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 7.363 MB Rows returned: 0
Duplicate queries: #51
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '113'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '113' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 0.26 ms Query memory: 0.028 MB Memory before query: 7.392 MB Rows returned: 0
Duplicate queries: #52
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '113'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '113' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.63 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 7.412 MB Rows returned: 0
Duplicate queries: #53
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '134'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '134' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 0.25 ms Query memory: 0.028 MB Memory before query: 7.442 MB Rows returned: 0
Duplicate queries: #54
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '134'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '134' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.60 ms After last query: 0.20 ms Query memory: 0.026 MB Memory before query: 7.461 MB Rows returned: 0
Duplicate queries: #55
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '135'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '135' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.60 ms After last query: 0.28 ms Query memory: 0.028 MB Memory before query: 7.491 MB Rows returned: 0
Duplicate queries: #56
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '135'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '135' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 7.510 MB Rows returned: 0
Duplicate queries: #57
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '136'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '136' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.25 ms Query memory: 0.028 MB Memory before query: 7.540 MB Rows returned: 0
Duplicate queries: #58
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '136'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '136' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 7.560 MB Rows returned: 0
Duplicate queries: #59
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '137'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '137' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.60 ms After last query: 0.28 ms Query memory: 0.028 MB Memory before query: 7.589 MB Rows returned: 0
Duplicate queries: #60
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '137'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '137' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.49 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 7.609 MB Rows returned: 0
Duplicate queries: #61
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '140'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '140' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.19 ms Query memory: 0.028 MB Memory before query: 7.639 MB Rows returned: 0
Duplicate queries: #62
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '140'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '140' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[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.14 ms Query memory: 0.026 MB Memory before query: 7.658 MB Rows returned: 0
Duplicate queries: #63
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '141'  
  AND category_publish = '1'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '141' AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:20
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.58 ms After last query: 0.26 ms Query memory: 0.028 MB Memory before query: 7.688 MB Rows returned: 0
Duplicate queries: #64
```
SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`
                   
  WHERE category_parent_id = '141'  
  AND access IN (1,1)
                   
  ORDER BY category_id asc
```
Explain
EXPLAIN not possible on query: SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image FROM `veneno_jshopping_categories` WHERE category_parent_id = '141' AND access IN (1,1) ORDER BY category_id asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:71
JROOT/modules/mod_vina_cmenu_jshopping/helper.php:117
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default_items.php:21
JROOT/templates/vina_veneno/html/mod_vina_cmenu_jshopping/default.php:112
JROOT/modules/mod_vina_cmenu_jshopping/mod_vina_cmenu_jshopping.php:135
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:169
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:590
JROOT/libraries/joomla/document/renderer/html/module.php:90
JROOT/libraries/joomla/document/renderer/html/modules.php:42
JROOT/libraries/joomla/document/html.php:486
JROOT/libraries/joomla/document/html.php:777
JROOT/libraries/joomla/document/html.php:552
JROOT/libraries/cms/application/cms.php:1112
JROOT/libraries/cms/application/site.php:777
JROOT/libraries/cms/application/cms.php:271
JROOT/index.php:68
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

38 × SELECT `name_vi-VN` as name,`description_vi-VN` as description,`short_description_vi-VN` as short_description, category_id, category_publish, ordering, category_image 
  FROM `veneno_jshopping_categories`

7 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `veneno_jshopping_products_images` as I 
      
  left join `veneno_jshopping_products` as P 
  on P.product_id=I.product_id

5 × SELECT COUNT(*) 
  FROM veneno_vvisitcounter

1 × select manufacturer_id as id, `name_vi-VN` as name, manufacturer_logo, manufacturer_url 
  from veneno_jshopping_manufacturers

1 × SELECT tax_id, tax_name, tax_value 
  FROM `veneno_jshopping_taxes

1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2`  
  FROM `veneno_jshopping_products` AS prod
               
  INNER JOIN `veneno_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = prod.product_id
               
  LEFT JOIN `veneno_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

1 × SELECT F.id, F.`name_vi-VN` as name, F.`description_vi-VN` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_vi-VN` as groupname, multilist 
  FROM `veneno_jshopping_products_extra_fields` as F 
  left join `veneno_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group

1 × SELECT id, `name_vi-VN` as name, field_id 
  FROM `veneno_jshopping_products_extra_field_values`

1 × select category_id as id, `alias_vi-VN` as alias 
  from veneno_jshopping_categories

1 × SELECT count( * ) AS records, MAX( id ) AS max 
  FROM veneno_vvisitcounte

1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_vi-VN` as name, prod.`short_description_vi-VN` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2`  
  FROM `veneno_jshopping_products` AS prod
                   
  INNER JOIN `veneno_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = prod.product_id
                   
  LEFT JOIN `veneno_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

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

1 × SELECT id, image, `name_vi-VN` as name 
  FROM `veneno_jshopping_product_labels`

1 × SELECT id, alias, `text_vi-VN` as text 
  FROM `veneno_jshopping_config_statictext`

1 × SELECT `enabled` 
  FROM `veneno_extensions`

1 × SELECT * 
  FROM veneno_jshopping_config

1 × SELECT id, rules 
  FROM `veneno_viewlevels

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

1 × SELECT `session_id` 
  FROM `veneno_session`

1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `veneno_jshopping_currencies`

1 × SELECT * 
  FROM `veneno_jshopping_config_display_prices

1 × SELECT id, alias, `title_vi-VN` as title, `keyword_vi-VN` as keyword, `description_vi-VN` as description 
  FROM `veneno_jshopping_config_seo`

1 × select * 
  from veneno_jshopping_language

1 × select id,link 
  from veneno_menu

1 × select product_id as id, `alias_vi-VN` as alias 
  from veneno_jshopping_products

1 × SELECT `data` 
  FROM `veneno_session`

OTHER Tables:

2 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_users

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_product_labels

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products_extra_field_values

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products_extra_fields

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_categories

1 × INSERT INTO veneno_vvisitcounter ( tm, ip, data ) 
  VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('18.97.9.170')) , NULL

1 × DELETE 
  FROM veneno_vvisitcounter

1 × CREATE TABLE IF NOT EXISTS veneno_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_statictext

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config

1 × UPDATE `veneno_extensions` 
  SET `params` = '{\"mediaversion\":\"0c2d0eb74b3628ac5a1de197512c21d9\"}'

1 × INSERT INTO `veneno_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('tisvsrvnrnomjonkltrdl8tf32', 1, '1742705705', 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_currencies

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_usergroups

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_seo

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_display_prices

```
1 × DELETE  
  FROM `veneno_session`
```

Hôm nay	30
Hôm qua	174
Tuần	642
Tháng	3951
Tổng	282743

GIAO HÀNG TOÀN QUỐC

Luôn có khuyến mãi

Đổi trả hàng

Trọn bộ 1-8 Camera Dahua giá rẻ HD720P (1.0MP)

Camera Quan Sát Yi Cloud Dome 1080P 360 Độ Quốc Tế - Hàng Chính Hãng

Trọn bộ 1-8 Camera Hikvision HD720P giá rẻ lắp cho gia đình

Trọn bộ 1-8 Camera Hikvision chất lượng HD1080P cho Nhà hàng

Camera Wifi thông minh EZVIZ C6N 1080P

Hệ thống Smarthome

Uy Tín - Tận Tâm

Về Chúng Tôi

Hỗ trợ

Mạng xã hội

CAM KẾT CHUNG