Joomla! Debug Console

81 Queries Logged 118.6 ms

2 duplicate found!

2 duplicates: #16 #17

Query Time: 0.92 ms
```
SELECT `data`

  FROM `veneno_session`

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

  FROM `veneno_session`

  WHERE `session_id` = 'q969seko4t7c61uhaa5b3quhv4' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `veneno_session` WHERE `session_id` = 'q969seko4t7c61uhaa5b3quhv4' LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:43
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 7.90 ms After last query: 0.33 ms
```
INSERT INTO `veneno_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('q969seko4t7c61uhaa5b3quhv4', 0, '1742235488')
```
Explain
EXPLAIN not possible on query: INSERT INTO `veneno_session` (`session_id`, `client_id`, `time`) VALUES ('q969seko4t7c61uhaa5b3quhv4', 0, '1742235488')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:43
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.28 ms After last query: 7.45 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM veneno_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM veneno_extensions WHERE `type` = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.30 ms After last query: 2.68 ms
```
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:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.19 ms After last query: 0.39 ms
```
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:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.86 ms After last query: 1.70 ms
```
SELECT folder AS type, element AS name, params

  FROM veneno_extensions

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

  ORDER BY ordering
```
Explain
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM veneno_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.93 ms After last query: 11.02 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM veneno_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM veneno_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/backup/backup.php:4
JROOT/libraries/cms/plugin/helper.php:230
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.25 ms After last query: 2.49 ms
```
UPDATE `veneno_extensions`

  SET `params` = '{\"mediaversion\":\"9eb3977962491cce323d46086b4a44b5\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `veneno_extensions` SET `params` = '{\"mediaversion\":\"9eb3977962491cce323d46086b4a44b5\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/backup/backup.php:4
JROOT/libraries/cms/plugin/helper.php:230
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.83 ms After last query: 19.44 ms
```
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM veneno_menu AS m

  LEFT JOIN veneno_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft
```
Explain
EXPLAIN not possible on query: SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM veneno_menu AS m LEFT JOIN veneno_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/application/site.php:438
JROOT/plugins/system/helix/core/helix.php:65
JROOT/plugins/system/helix/core/helix.php:114
JROOT/plugins/system/helix/core/helix.php:302
JROOT/plugins/system/helix/core/helix.php:290
JROOT/plugins/system/helix/core/helix.php:1592
JROOT/plugins/system/helix/helix.php:22
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.29 ms After last query: 6.83 ms
```
SELECT id, home, template, s.params

  FROM veneno_template_styles as s

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

  WHERE s.client_id = 0 
  AND e.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT id, home, template, s.params FROM veneno_template_styles as s LEFT JOIN veneno_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/site.php:484
JROOT/plugins/system/helix/core/helix.php:65
JROOT/plugins/system/helix/core/helix.php:114
JROOT/plugins/system/helix/core/helix.php:302
JROOT/plugins/system/helix/core/helix.php:290
JROOT/plugins/system/helix/core/helix.php:1592
JROOT/plugins/system/helix/helix.php:22
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:654
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 4.68 ms After last query: 34.98 ms
```
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:241
JROOT/libraries/joomla/table/table.php:162
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.84 ms After last query: 4.90 ms
```
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:728
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.55 ms After last query: 1.67 ms
```
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:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/currency.php:14
JROOT/libraries/joomla/table/table.php:305
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.23 ms After last query: 0.36 ms
```
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.49 ms After last query: 0.76 ms
Duplicate queries: #17
```
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:241
JROOT/libraries/joomla/table/table.php:162
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:67
JROOT/components/com_jshopping/tables/config.php:288
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 3.35 ms After last query: 1.50 ms
Duplicate queries: #16
```
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:241
JROOT/libraries/joomla/table/table.php:162
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:71
JROOT/components/com_jshopping/tables/config.php:288
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.87 ms After last query: 1.68 ms
```
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:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/usergroup.php:14
JROOT/libraries/joomla/table/table.php:305
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:71
JROOT/components/com_jshopping/tables/config.php:288
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.70 ms After last query: 1.07 ms
```
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:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/configdisplayprice.php:19
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/tables/config.php:79
JROOT/components/com_jshopping/tables/config.php:288
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.25 ms After last query: 0.36 ms
```
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:38
JROOT/components/com_jshopping/tables/config.php:80
JROOT/components/com_jshopping/tables/config.php:288
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:1546
JROOT/components/com_jshopping/router.php:210
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 6.69 ms
```
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:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_jshopping/router.php:216
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.36 ms After last query: 1.39 ms
```
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:287
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.43 ms After last query: 1.35 ms
```
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:130
JROOT/components/com_jshopping/lib/shop_item_menu.php:41
JROOT/components/com_jshopping/lib/shop_item_menu.php:35
JROOT/components/com_jshopping/router.php:15
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:46
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.35 ms After last query: 3.94 ms
```
SELECT *

  FROM veneno_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN not possible on query: SELECT * FROM veneno_languages WHERE published=1 ORDER BY ordering ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/libraries/cms/application/site.php:329
JROOT/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.34 ms After last query: 60.30 ms
```
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:281
JROOT/components/com_jshopping/loadparams.php:32
JROOT/components/com_jshopping/jshopping.php:16
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.83 ms After last query: 14.07 ms
```
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:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/category.php:15
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/controllers/category.php:56
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.47 ms After last query: 1.02 ms
```
SELECT *

  FROM veneno_jshopping_categories

  WHERE `category_id` = '1'
```
Explain
EXPLAIN not possible on query: SELECT * FROM veneno_jshopping_categories WHERE `category_id` = '1'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_jshopping/controllers/category.php:57
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.35 ms After last query: 15.75 ms
```
SELECT option_value 
  FROM veneno_imagerecycle_options 
  WHERE option_name ='queue_process_lastRun' 
  LIMIT 1
```
Explain
EXPLAIN not possible on query: SELECT option_value FROM veneno_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_imagerecycle/helpers/imagerecycle.php:185
JROOT/plugins/content/imagerecycle/imagerecycle.php:61
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_jshopping/lib/functions.php:914
JROOT/components/com_jshopping/tables/category.php:251
JROOT/components/com_jshopping/tables/category.php:66
JROOT/components/com_jshopping/controllers/category.php:58
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.21 ms After last query: 0.17 ms
```
SELECT option_value 
  FROM veneno_imagerecycle_options 
  WHERE option_name ='queue_process_status' 
  LIMIT 1
```
Explain
EXPLAIN not possible on query: SELECT option_value FROM veneno_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_imagerecycle/helpers/imagerecycle.php:185
JROOT/plugins/content/imagerecycle/imagerecycle.php:62
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_jshopping/lib/functions.php:914
JROOT/components/com_jshopping/tables/category.php:251
JROOT/components/com_jshopping/tables/category.php:66
JROOT/components/com_jshopping/controllers/category.php:58
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.17 ms After last query: 0.41 ms
```
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 ordering 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 ordering asc
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:34
JROOT/components/com_jshopping/tables/category.php:119
JROOT/components/com_jshopping/controllers/category.php:66
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.50 ms After last query: 5.48 ms
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_vendors`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_vendors`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/vendor.php:15
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/lib/factory.php:414
JROOT/components/com_jshopping/lib/functions.php:1409
JROOT/components/com_jshopping/tables/category.php:304
JROOT/components/com_jshopping/models/productlist.php:168
JROOT/components/com_jshopping/controllers/category.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.39 ms After last query: 0.94 ms
```
SELECT id 
  FROM veneno_jshopping_vendors 
  WHERE `main`=1
```
Explain
EXPLAIN not possible on query: SELECT id FROM veneno_jshopping_vendors WHERE `main`=1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/vendor.php:23
JROOT/components/com_jshopping/lib/factory.php:415
JROOT/components/com_jshopping/lib/functions.php:1409
JROOT/components/com_jshopping/tables/category.php:304
JROOT/components/com_jshopping/models/productlist.php:168
JROOT/components/com_jshopping/controllers/category.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.38 ms After last query: 0.60 ms
```
SELECT *

  FROM veneno_jshopping_vendors

  WHERE `id` = '1'
```
Explain
EXPLAIN not possible on query: SELECT * FROM veneno_jshopping_vendors WHERE `id` = '1'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_jshopping/tables/vendor.php:24
JROOT/components/com_jshopping/lib/factory.php:415
JROOT/components/com_jshopping/lib/functions.php:1409
JROOT/components/com_jshopping/tables/category.php:304
JROOT/components/com_jshopping/models/productlist.php:168
JROOT/components/com_jshopping/controllers/category.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.87 ms After last query: 1.31 ms
```
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:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/tax.php:14
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/lib/factory.php:342
JROOT/components/com_jshopping/lib/functions.php:955
JROOT/components/com_jshopping/lib/jtableauto.php:101
JROOT/components/com_jshopping/lib/jtableauto.php:88
JROOT/components/com_jshopping/tables/category.php:178
JROOT/components/com_jshopping/models/productlist.php:172
JROOT/components/com_jshopping/controllers/category.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.28 ms After last query: 0.38 ms
```
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:955
JROOT/components/com_jshopping/lib/jtableauto.php:101
JROOT/components/com_jshopping/lib/jtableauto.php:88
JROOT/components/com_jshopping/tables/category.php:178
JROOT/components/com_jshopping/models/productlist.php:172
JROOT/components/com_jshopping/controllers/category.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.59 ms After last query: 0.35 ms
```
SELECT count(*) 
  FROM `veneno_jshopping_products_to_categories` AS pr_cat
                  
  INNER JOIN `veneno_jshopping_products` AS prod 
  ON pr_cat.product_id = prod.product_id
                   
                  
  WHERE pr_cat.category_id = '1' 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1)
```
Explain
EXPLAIN not possible on query: SELECT count(*) FROM `veneno_jshopping_products_to_categories` AS pr_cat INNER JOIN `veneno_jshopping_products` AS prod ON pr_cat.product_id = prod.product_id WHERE pr_cat.category_id = '1' AND prod.product_publish = '1' AND prod.access IN (1,1)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:188
JROOT/components/com_jshopping/models/productlist.php:172
JROOT/components/com_jshopping/controllers/category.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 4.81 ms After last query: 13.02 ms
```
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 
  FROM `veneno_jshopping_products` AS prod
                  
  LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)
                  
                  
  WHERE pr_cat.category_id = '1' 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1)  
  ORDER BY name ASC 
  LIMIT 0, 40
```
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 FROM `veneno_jshopping_products` AS prod LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id) WHERE pr_cat.category_id = '1' AND prod.product_publish = '1' AND prod.access IN (1,1) ORDER BY name ASC LIMIT 0, 40
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:170
JROOT/components/com_jshopping/models/productlist.php:185
JROOT/components/com_jshopping/controllers/category.php:73
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.56 ms After last query: 42.18 ms
```
SELECT distinct man.manufacturer_id as id, man.`name_vi-VN` as name 
  FROM `veneno_jshopping_products` AS prod
                  
  LEFT JOIN `veneno_jshopping_products_to_categories` AS categ USING (product_id)
                  
  LEFT JOIN `veneno_jshopping_manufacturers` as man 
  on prod.product_manufacturer_id=man.manufacturer_id 
                  
  WHERE categ.category_id = '1' 
  AND prod.product_publish = '1' 
  AND prod.product_manufacturer_id!=0  
  AND prod.access IN (1,1) 
  order by man.ordering
```
Explain
EXPLAIN not possible on query: SELECT distinct man.manufacturer_id as id, man.`name_vi-VN` as name FROM `veneno_jshopping_products` AS prod LEFT JOIN `veneno_jshopping_products_to_categories` AS categ USING (product_id) LEFT JOIN `veneno_jshopping_manufacturers` as man on prod.product_manufacturer_id=man.manufacturer_id WHERE categ.category_id = '1' AND prod.product_publish = '1' AND prod.product_manufacturer_id!=0 AND prod.access IN (1,1) order by man.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_jshopping/tables/category.php:227
JROOT/components/com_jshopping/models/productlist.php:205
JROOT/components/com_jshopping/controllers/category.php:86
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.82 ms After last query: 1.51 ms
```
SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products_reviews`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_reviews`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/review.php:14
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/models/productlist.php:252
JROOT/components/com_jshopping/controllers/category.php:87
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 4.37 ms After last query: 7.12 ms
```
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:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/product.php:15
JROOT/libraries/joomla/table/table.php:305
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:10
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.72 ms After last query: 1.20 ms
```
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 = '755' 
  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 = '755' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.32 ms After last query: 2.65 ms
```
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 = '1113' 
  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 = '1113' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.25 ms After last query: 1.96 ms
```
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 = '397' 
  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 = '397' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.30 ms After last query: 1.98 ms
```
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 = '838' 
  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 = '838' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.37 ms After last query: 1.80 ms
```
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 = '840' 
  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 = '840' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.28 ms After last query: 1.75 ms
```
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 = '1029' 
  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 = '1029' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[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.70 ms
```
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 = '781' 
  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 = '781' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.23 ms After last query: 1.63 ms
```
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 = '477' 
  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 = '477' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[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.56 ms
```
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 = '612' 
  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 = '612' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.16 ms After last query: 1.57 ms
```
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 = '827' 
  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 = '827' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.39 ms After last query: 1.48 ms
```
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 = '833' 
  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 = '833' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.12 ms After last query: 2.00 ms
```
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 = '842' 
  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 = '842' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.21 ms After last query: 1.67 ms
```
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 = '750' 
  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 = '750' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.08 ms After last query: 2.33 ms
```
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 = '452' 
  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 = '452' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.10 ms After last query: 1.99 ms
```
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 = '440' 
  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 = '440' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.06 ms After last query: 1.73 ms
```
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 = '443' 
  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 = '443' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.14 ms After last query: 1.65 ms
```
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 = '1083' 
  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 = '1083' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.12 ms After last query: 1.63 ms
```
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 = '470' 
  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 = '470' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.14 ms After last query: 1.77 ms
```
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 = '923' 
  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 = '923' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.07 ms After last query: 1.51 ms
```
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 = '469' 
  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 = '469' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.71 ms After last query: 1.64 ms
```
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 = '554' 
  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 = '554' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.47 ms After last query: 1.66 ms
```
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 = '801' 
  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 = '801' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.26 ms After last query: 1.72 ms
```
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 = '1035' 
  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 = '1035' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.08 ms After last query: 1.65 ms
```
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 = '350' 
  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 = '350' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.10 ms After last query: 1.59 ms
```
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 = '371' 
  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 = '371' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.84 ms After last query: 1.78 ms
```
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 = '824' 
  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 = '824' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.41 ms After last query: 1.68 ms
```
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 = '901' 
  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 = '901' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.31 ms After last query: 1.74 ms
```
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 = '914' 
  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 = '914' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.21 ms After last query: 1.70 ms
```
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 = '999' 
  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 = '999' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.25 ms After last query: 1.65 ms
```
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 = '864' 
  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 = '864' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[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.70 ms
```
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 = '348' 
  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 = '348' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.23 ms After last query: 1.68 ms
```
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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.79 ms After last query: 1.64 ms
```
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 = '340' 
  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 = '340' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.32 ms After last query: 1.78 ms
```
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 = '364' 
  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 = '364' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.84 ms After last query: 1.53 ms
```
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 = '798' 
  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 = '798' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.43 ms After last query: 1.63 ms
```
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 = '398' 
  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 = '398' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.43 ms After last query: 1.76 ms
```
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 = '403' 
  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 = '403' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.40 ms After last query: 1.67 ms
```
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 = '406' 
  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 = '406' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.23 ms After last query: 2.13 ms
```
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 = '777' 
  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 = '777' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.52 ms After last query: 2.27 ms
```
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 = '1048' 
  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 = '1048' 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:333
JROOT/templates/vina_veneno/html/com_jshopping/list_products/product.php:12
JROOT/templates/vina_veneno/html/com_jshopping/list_products/list_products.php:18
JROOT/templates/vina_veneno/html/com_jshopping/category/products.php:16
JROOT/templates/vina_veneno/html/com_jshopping/category/category_default.php:47
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
JROOT/components/com_jshopping/views/category/view.html.php:13
JROOT/components/com_jshopping/controllers/category.php:121
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.70 ms After last query: 43.10 ms
```
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-17 18:18:09') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-17 18:18:09') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 560 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-17 18:18:09') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-17 18:18:09') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 560 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/html.php:501
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/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

39 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

40 × 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

2 × SELECT option_value 
  FROM veneno_imagerecycle_options

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

1 × 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`

1 × SELECT id 
  FROM veneno_jshopping_vendors

1 × SELECT * 
  FROM veneno_jshopping_categories

1 × SELECT * 
  FROM veneno_jshopping_vendors

1 × select * 
  from veneno_jshopping_language

1 × SELECT count(*) 
  FROM `veneno_jshopping_products_to_categories` AS pr_cat
                   
  INNER JOIN `veneno_jshopping_products` AS prod 
  ON pr_cat.product_id = prod.product_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 distinct man.manufacturer_id as id, man.`name_vi-VN` as name 
  FROM `veneno_jshopping_products` AS prod
                   
  LEFT JOIN `veneno_jshopping_products_to_categories` AS categ USING (product_id)
                   
  LEFT JOIN `veneno_jshopping_manufacturers` as man 
  on prod.product_manufacturer_id=man.manufacturer_id

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 
  FROM `veneno_jshopping_products` AS prod
                   
  LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)

```
1 × SELECT * 
  FROM veneno_languages
```

1 × SELECT tax_id, tax_name, tax_value 
  FROM `veneno_jshopping_taxes

1 × select id,link 
  from veneno_menu

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

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

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 id, home, template, s.params 
  FROM veneno_template_styles as s 
  LEFT JOIN veneno_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM veneno_jshopping_config

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

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

1 × SELECT * 
  FROM `veneno_jshopping_config_display_prices

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

1 × SELECT `data` 
  FROM `veneno_session`

OTHER Tables:

2 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_users

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_vendors

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_taxes

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products_reviews

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_products

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_categories

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_usergroups

1 × UPDATE `veneno_extensions` 
  SET `params` = '{\"mediaversion\":\"9eb3977962491cce323d46086b4a44b5\"}'

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_currencies

1 × INSERT INTO `veneno_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('q969seko4t7c61uhaa5b3quhv4', 0, '1742235488'

1 × SHOW FULL COLUMNS 
  FROM `veneno_jshopping_config_display_prices

Mỹ phẩm Nhật Bản xách tay

Kệ hoa chúc mừng - DH900

Lẵng hoa khai trương 2 tầng -DH101

Hoa khai trương 2 tầng - DH07

Hoa khai trương 1 tầng - DH13

Hoa khai trương 2 tầng - DH28

Hoa Khai Trương

ĐIỆN HOA TOÀN QUỐC

Về Chúng Tôi

Hỗ trợ

Mạng xã hội

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

81 Queries Logged 118.6 ms

2 duplicate found!

39 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: