Query Time: 0.56 ms
SELECT `data`
FROM `veneno_session`
WHERE `session_id` = 'f679v9l7mh0nml2skbvbbkgif2'
EXPLAIN not possible on query: SELECT `data`
FROM `veneno_session`
WHERE `session_id` = 'f679v9l7mh0nml2skbvbbkgif2'
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 0.42 ms After last query: 2.38 ms
DELETE
FROM `veneno_session`
WHERE `time` < '1741805957'
EXPLAIN not possible on query: DELETE
FROM `veneno_session`
WHERE `time` < '1741805957'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:756
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:43
Query Time: 0.56 ms After last query: 0.18 ms
SELECT `session_id`
FROM `veneno_session`
WHERE `session_id` = 'f679v9l7mh0nml2skbvbbkgif2'
LIMIT 0, 1
EXPLAIN not possible on query: SELECT `session_id`
FROM `veneno_session`
WHERE `session_id` = 'f679v9l7mh0nml2skbvbbkgif2' LIMIT 0, 1
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 1.93 ms After last query: 0.18 ms
INSERT INTO `veneno_session`
(`session_id`, `client_id`, `time`)
VALUES
('f679v9l7mh0nml2skbvbbkgif2', 0, '1741809557')
EXPLAIN not possible on query: INSERT INTO `veneno_session`
(`session_id`, `client_id`, `time`) VALUES
('f679v9l7mh0nml2skbvbbkgif2', 0, '1741809557')
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 0.25 ms After last query: 5.17 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 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 0.20 ms After last query: 0.33 ms
SELECT id, rules
FROM `veneno_viewlevels`
EXPLAIN not possible on query: SELECT id, rules
FROM `veneno_viewlevels`
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 1.97 ms After last query: 8.97 ms
UPDATE `veneno_extensions`
SET `params` = '{\"mediaversion\":\"ed13422cf05f19e4dd4fa0991d0450d0\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `veneno_extensions`
SET `params` = '{\"mediaversion\":\"ed13422cf05f19e4dd4fa0991d0450d0\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 1.84 ms After last query: 15.94 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 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 4.51 ms After last query: 33.41 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_config`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config`
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 0.41 ms After last query: 3.99 ms
SELECT *
FROM veneno_jshopping_config
WHERE `id` = '1'
EXPLAIN not possible on query: SELECT *
FROM veneno_jshopping_config
WHERE `id` = '1'
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 1.48 ms After last query: 1.49 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_currencies`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_currencies`
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 0.20 ms After last query: 0.27 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 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 2.33 ms After last query: 0.56 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 2.34 ms After last query: 0.92 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_users`
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 1.37 ms After last query: 1.36 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_usergroups`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_usergroups`
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 1.17 ms After last query: 0.92 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_config_display_prices`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_config_display_prices`
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 0.20 ms After last query: 0.25 ms
SELECT *
FROM `veneno_jshopping_config_display_prices`
EXPLAIN not possible on query: SELECT * FROM `veneno_jshopping_config_display_prices`
No SHOW PROFILE (maybe because there are more than 100 queries)
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:14
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
Query Time: 0.21 ms After last query: 0.31 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 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)
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 0.20 ms After last query: 50.95 ms
select *
from veneno_jshopping_languages
EXPLAIN not possible on query: select * from veneno_jshopping_languages
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 3.26 ms After last query: 9.90 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_manufacturers`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_manufacturers`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/components/com_jshopping/tables/manufacturer.php:15
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:600
JROOT/components/com_jshopping/controllers/manufacturer.php:52
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
Query Time: 3.58 ms After last query: 0.62 ms
SELECT *
FROM veneno_jshopping_manufacturers
WHERE `manufacturer_id` = '24'
EXPLAIN not possible on query: SELECT *
FROM veneno_jshopping_manufacturers
WHERE `manufacturer_id` = '24'
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_jshopping/controllers/manufacturer.php:53
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
Query Time: 0.25 ms After last query: 12.45 ms
SELECT option_value
FROM veneno_imagerecycle_options
WHERE option_name ='queue_process_lastRun'
LIMIT 1
EXPLAIN not possible on query: SELECT option_value FROM veneno_imagerecycle_options WHERE option_name ='queue_process_lastRun' LIMIT 1
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:70
JROOT/components/com_jshopping/controllers/manufacturer.php:54
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
Query Time: 0.19 ms After last query: 0.14 ms
SELECT option_value
FROM veneno_imagerecycle_options
WHERE option_name ='queue_process_status'
LIMIT 1
EXPLAIN not possible on query: SELECT option_value FROM veneno_imagerecycle_options WHERE option_name ='queue_process_status' LIMIT 1
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:70
JROOT/components/com_jshopping/controllers/manufacturer.php:54
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
Query Time: 1.88 ms After last query: 2.75 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_vendors`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_vendors`
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:227
JROOT/components/com_jshopping/models/productlist.php:168
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 0.13 ms After last query: 0.46 ms
SELECT id
FROM veneno_jshopping_vendors
WHERE `main`=1
EXPLAIN not possible on query: SELECT id FROM veneno_jshopping_vendors WHERE `main`=1
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:227
JROOT/components/com_jshopping/models/productlist.php:168
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 0.14 ms After last query: 0.31 ms
SELECT *
FROM veneno_jshopping_vendors
WHERE `id` = '1'
EXPLAIN not possible on query: SELECT *
FROM veneno_jshopping_vendors
WHERE `id` = '1'
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:227
JROOT/components/com_jshopping/models/productlist.php:168
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 0.80 ms After last query: 0.69 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_taxes`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_taxes`
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:114
JROOT/components/com_jshopping/models/productlist.php:172
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 0.15 ms After last query: 0.14 ms
SELECT tax_id, tax_name, tax_value
FROM `veneno_jshopping_taxes`
EXPLAIN not possible on query: SELECT tax_id, tax_name, tax_value FROM `veneno_jshopping_taxes`
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:114
JROOT/components/com_jshopping/models/productlist.php:172
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 1.67 ms After last query: 0.12 ms
SELECT COUNT(distinct prod.product_id)
FROM `veneno_jshopping_products` as prod
LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)
LEFT JOIN `veneno_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE prod.product_manufacturer_id = '24'
AND prod.product_publish = '1'
AND cat.category_publish='1'
AND prod.access IN (1,1)
AND cat.access IN (1,1)
EXPLAIN not possible on query: SELECT COUNT(distinct prod.product_id) FROM `veneno_jshopping_products` as prod
LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)
LEFT JOIN `veneno_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
WHERE prod.product_manufacturer_id = '24' AND prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1)
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_jshopping/tables/manufacturer.php:126
JROOT/components/com_jshopping/models/productlist.php:172
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 2.18 ms After last query: 2.20 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)
LEFT JOIN `veneno_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
WHERE prod.product_manufacturer_id = '24'
AND prod.product_publish = '1'
AND cat.category_publish='1'
AND prod.access IN (1,1)
AND cat.access IN (1,1)
GROUP BY prod.product_id
ORDER BY name ASC
LIMIT 40, 40
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)
LEFT JOIN `veneno_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
WHERE prod.product_manufacturer_id = '24' AND prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1)
GROUP BY prod.product_id ORDER BY name ASC LIMIT 40, 40
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_jshopping/tables/manufacturer.php:106
JROOT/components/com_jshopping/models/productlist.php:185
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 1.02 ms After last query: 1.24 ms
select product_id as id, `alias_vi-VN` as alias
from veneno_jshopping_products
where `alias_vi-VN`!=''
EXPLAIN not possible on query: select product_id as id, `alias_vi-VN` as alias from veneno_jshopping_products where `alias_vi-VN`!=''
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_jshopping/lib/factory.php:276
JROOT/components/com_jshopping/router.php:69
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/components/com_jshopping/lib/functions.php:479
JROOT/components/com_jshopping/lib/functions.php:429
JROOT/components/com_jshopping/lib/functions.php:763
JROOT/components/com_jshopping/tables/manufacturer.php:107
JROOT/components/com_jshopping/models/productlist.php:185
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 0.14 ms After last query: 0.57 ms
select category_id as id, `alias_vi-VN` as alias
from veneno_jshopping_categories
where `alias_vi-VN`!=''
EXPLAIN not possible on query: select category_id as id, `alias_vi-VN` as alias from veneno_jshopping_categories where `alias_vi-VN`!=''
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_jshopping/lib/factory.php:242
JROOT/components/com_jshopping/router.php:70
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/components/com_jshopping/lib/functions.php:479
JROOT/components/com_jshopping/lib/functions.php:429
JROOT/components/com_jshopping/lib/functions.php:763
JROOT/components/com_jshopping/tables/manufacturer.php:107
JROOT/components/com_jshopping/models/productlist.php:185
JROOT/components/com_jshopping/controllers/manufacturer.php:67
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
Query Time: 2.70 ms After last query: 11.40 ms
SELECT distinct cat.category_id as id, cat.`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_categories` as cat
on cat.category_id=categ.category_id
WHERE prod.product_publish = '1'
AND prod.product_manufacturer_id='24'
AND cat.category_publish='1'
AND prod.access IN (1,1)
AND cat.access IN (1,1)
order by name
EXPLAIN not possible on query: SELECT distinct cat.category_id as id, cat.`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_categories` as cat on cat.category_id=categ.category_id
WHERE prod.product_publish = '1' AND prod.product_manufacturer_id='24' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) order by name
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_jshopping/tables/manufacturer.php:144
JROOT/components/com_jshopping/models/productlist.php:225
JROOT/components/com_jshopping/controllers/manufacturer.php:80
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
Query Time: 1.35 ms After last query: 1.19 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_products_reviews`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products_reviews`
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer.php:81
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
Query Time: 2.18 ms After last query: 5.13 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_products`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_products`
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.88 ms After last query: 0.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 = '422'
ORDER BY sort, I.ordering
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 = '422' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.74 ms After last query: 1.55 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 = '423'
ORDER BY sort, I.ordering
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 = '423' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.71 ms After last query: 1.15 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 = '437'
ORDER BY sort, I.ordering
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 = '437' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.89 ms After last query: 1.24 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 = '768'
ORDER BY sort, I.ordering
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 = '768' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.68 ms After last query: 1.17 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 = '799'
ORDER BY sort, I.ordering
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 = '799' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.73 ms After last query: 1.24 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 = '439'
ORDER BY sort, I.ordering
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 = '439' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.72 ms After last query: 1.22 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 = '405'
ORDER BY sort, I.ordering
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 = '405' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.69 ms After last query: 1.21 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 = '479'
ORDER BY sort, I.ordering
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 = '479' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.64 ms After last query: 1.05 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 = '593'
ORDER BY sort, I.ordering
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 = '593' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.94 ms After last query: 1.10 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 = '490'
ORDER BY sort, I.ordering
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 = '490' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.71 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 = '480'
ORDER BY sort, I.ordering
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 = '480' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 0.64 ms After last query: 1.34 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 = '1097'
ORDER BY sort, I.ordering
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 = '1097' ORDER BY sort, I.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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/manufacturer/products.php:20
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/manufacturer/view.html.php:13
JROOT/components/com_jshopping/controllers/manufacturer.php:111
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
Query Time: 2.12 ms After last query: 43.11 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-12 19:59:17')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-12 19:59:17')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 568 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
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-12 19:59:17') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-12 19:59:17') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 568 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
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
Query Time: 1.67 ms After last query: 70.52 ms
SHOW FULL COLUMNS
FROM `veneno_jshopping_categories`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `veneno_jshopping_categories`
No SHOW PROFILE (maybe because there are more than 100 queries)
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/lib/functions.php:333
JROOT/modules/mod_jshopping_ajaxsearch/mod_jshopping_ajaxsearch.php:25
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/html/renderer/module.php:99
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:46
Query Time: 0.23 ms After last query: 0.53 ms
SELECT `name_vi-VN` as name, category_id, category_parent_id, category_publish
FROM `veneno_jshopping_categories`
where category_publish = '1'
and access IN (1,1)
ORDER BY category_parent_id, ordering
EXPLAIN not possible on query: SELECT `name_vi-VN` as name, category_id, category_parent_id, category_publish FROM `veneno_jshopping_categories`
where category_publish = '1' and access IN (1,1) ORDER BY category_parent_id, ordering
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_jshopping/tables/category.php:115
JROOT/components/com_jshopping/lib/functions.php:333
JROOT/modules/mod_jshopping_ajaxsearch/mod_jshopping_ajaxsearch.php:25
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/plugins/system/helix/core/classes/joomla30/helper.php:601
JROOT/libraries/joomla/document/html/renderer/module.php:99
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:46
12 × 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
1 × select product_id as id, `alias_vi-VN` as alias
from veneno_jshopping_products
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)
LEFT JOIN `veneno_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
1 × SELECT COUNT(distinct prod.product_id)
FROM `veneno_jshopping_products` as prod
LEFT JOIN `veneno_jshopping_products_to_categories` AS pr_cat USING (product_id)
LEFT JOIN `veneno_jshopping_categories` AS cat
ON pr_cat.category_id = cat.category_id
1 × SELECT tax_id, tax_name, tax_value
FROM `veneno_jshopping_taxes
1 × select category_id as id, `alias_vi-VN` as alias
from veneno_jshopping_categories
1 × SELECT distinct cat.category_id as id, cat.`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_categories` as cat
on cat.category_id=categ.category_id
1 × SELECT `name_vi-VN` as name, category_id, category_parent_id, category_publish
FROM `veneno_jshopping_categories`
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 `session_id`
FROM `veneno_session`
1 × SELECT *
FROM veneno_jshopping_vendors
1 × SELECT id
FROM veneno_jshopping_vendors
1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `veneno_jshopping_currencies`
1 × SELECT *
FROM veneno_jshopping_config
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 *
FROM `veneno_jshopping_config_display_prices
1 × select id,link
from veneno_menu
1 × SELECT `data`
FROM `veneno_session`
1 × SELECT *
FROM veneno_jshopping_manufacturers
1 × select *
from veneno_jshopping_language
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
Điện thoại: 098.779.4000
Facebook
Youtube
Google +