**Query Time: 0.66 ms**
SELECT `data`
FROM `xu5z7_session`
WHERE `session_id` = 'ea24eea6910c8c972acc232d218825a2'
**EXPLAIN not possible on query: SELECT `data`
FROM `xu5z7_session`
WHERE `session_id` = 'ea24eea6910c8c972acc232d218825a2'**
**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:665
JROOT/libraries/joomla/session/session.php:603
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
**Query Time: 0.53 ms** **After last query: 0.69 ms**
DELETE
FROM `xu5z7_session`
WHERE `time` < '1764992897'
**EXPLAIN not possible on query: DELETE
FROM `xu5z7_session`
WHERE `time` < '1764992897'**
**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:42
**Query Time: 0.70 ms** **After last query: 1.89 ms**
SELECT extension_id AS id, element AS "option", params, enabled
FROM xu5z7_extensions
WHERE `type` = 'component'
**EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM xu5z7_extensions
WHERE `type` = 'component'**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 0.92 ms** **After last query: 1.06 ms**
SELECT folder AS type, element AS name, params
FROM xu5z7_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
**EXPLAIN not possible on query: SELECT folder AS type, element AS name, params
FROM xu5z7_extensions
WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDER BY ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 0.77 ms** **After last query: 13.23 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 xu5z7_menu AS m
LEFT JOIN xu5z7_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 xu5z7_menu AS m
LEFT JOIN xu5z7_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/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 0.65 ms** **After last query: 0.59 ms**
SELECT extension_id AS id, element AS "option", params, enabled
FROM xu5z7_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
**EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM xu5z7_extensions
WHERE `type` = 'library' AND `element` = 'joomla'**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
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/advancedmodules/advancedmodules.php:80
JROOT/plugins/system/advancedmodules/advancedmodules.php:32
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 0.60 ms** **After last query: 0.65 ms**
UPDATE `xu5z7_extensions`
SET `params` = '{\"mediaversion\":\"c841cf0748d27889a835dfcbf547b94a\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
**EXPLAIN not possible on query: UPDATE `xu5z7_extensions`
SET `params` = '{\"mediaversion\":\"c841cf0748d27889a835dfcbf547b94a\"}'
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/advancedmodules/advancedmodules.php:80
JROOT/plugins/system/advancedmodules/advancedmodules.php:32
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 1.37 ms** **After last query: 3.70 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_config`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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:15
JROOT/components/com_jshopping/lib/factory.php:28
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
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:45
**Query Time: 0.86 ms** **After last query: 1.58 ms**
SELECT *
FROM xu5z7_jshopping_config
WHERE `id` = '1'
**EXPLAIN not possible on query: SELECT *
FROM xu5z7_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:32
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
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:45
**Query Time: 1.01 ms** **After last query: 0.86 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_currencies`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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:22
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:623
JROOT/components/com_jshopping/tables/config.php:54
JROOT/components/com_jshopping/lib/factory.php:34
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
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:45
**Query Time: 0.57 ms** **After last query: 0.06 ms**
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `xu5z7_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 `xu5z7_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:30
JROOT/components/com_jshopping/lib/factory.php:624
JROOT/components/com_jshopping/tables/config.php:54
JROOT/components/com_jshopping/lib/factory.php:34
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
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:45
**Query Time: 0.58 ms** **After last query: 0.07 ms**
select id,link
from xu5z7_menu
where `type`='component'
and published=1
and link like '%option=com_jshopping%'
and client_id=0
and (language='*' or language='en-GB')
and access IN (1,1,5)
**EXPLAIN not possible on query: select id,link from xu5z7_menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='en-GB') and access IN (1,1,5)**
**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:16
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:45
**Query Time: 0.60 ms** **After last query: 0.53 ms**
SELECT *
FROM xu5z7_languages
WHERE published=1
ORDER BY ordering ASC
**EXPLAIN not possible on query: SELECT *
FROM xu5z7_languages
WHERE published=1
ORDER BY ordering ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
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:45
**Query Time: 0.59 ms** **After last query: 0.18 ms**
SELECT id, home, template, s.params
FROM xu5z7_template_styles as s
LEFT JOIN xu5z7_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 not possible on query: SELECT id, home, template, s.params
FROM xu5z7_template_styles as s
LEFT JOIN xu5z7_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**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/application/site.php:165
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 1.91 ms** **After last query: 29.38 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_categories`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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:675
JROOT/components/com_jshopping/controllers/category.php:70
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:45
**Query Time: 0.65 ms** **After last query: 0.24 ms**
SELECT *
FROM xu5z7_jshopping_categories
WHERE `category_id` = '1'
**EXPLAIN not possible on query: SELECT *
FROM xu5z7_jshopping_categories
WHERE `category_id` = '1'**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_jshopping/controllers/category.php:71
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:45
**Query Time: 1.09 ms** **After last query: 1.66 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_vendors`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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:14
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:489
JROOT/components/com_jshopping/lib/functions.php:1401
JROOT/components/com_jshopping/controllers/category.php:103
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:45
**Query Time: 0.59 ms** **After last query: 0.19 ms**
SELECT id
FROM xu5z7_jshopping_vendors
WHERE `main`=1
**EXPLAIN not possible on query: SELECT id FROM xu5z7_jshopping_vendors WHERE `main`=1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/vendor.php:22
JROOT/components/com_jshopping/lib/factory.php:490
JROOT/components/com_jshopping/lib/functions.php:1401
JROOT/components/com_jshopping/controllers/category.php:103
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:45
**Query Time: 0.68 ms** **After last query: 0.13 ms**
SELECT *
FROM xu5z7_jshopping_vendors
WHERE `id` = '1'
**EXPLAIN not possible on query: SELECT *
FROM xu5z7_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:23
JROOT/components/com_jshopping/lib/factory.php:490
JROOT/components/com_jshopping/lib/functions.php:1401
JROOT/components/com_jshopping/controllers/category.php:103
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:45
**Query Time: 0.75 ms** **After last query: 0.33 ms**
SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image
FROM `xu5z7_jshopping_categories`
WHERE category_parent_id = '1'
AND category_publish = '1'
AND access IN (1,1,5)
ORDER BY ordering asc
**EXPLAIN not possible on query: SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `xu5z7_jshopping_categories`
WHERE category_parent_id = '1' AND category_publish = '1' AND access IN (1,1,5)
ORDER BY ordering asc**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/category.php:34
JROOT/components/com_jshopping/tables/category.php:112
JROOT/components/com_jshopping/controllers/category.php:110
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:45
**Query Time: 1.23 ms** **After last query: 0.45 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_products_extra_fields`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_products_extra_fields`**
**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/productfield.php:16
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:550
JROOT/components/com_jshopping/lib/functions.php:1097
JROOT/components/com_jshopping/lib/jtableauto.php:37
JROOT/components/com_jshopping/tables/category.php:172
JROOT/components/com_jshopping/controllers/category.php:116
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:45
**Query Time: 0.97 ms** **After last query: 0.09 ms**
SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_en-GB` as groupname, multilist
FROM `xu5z7_jshopping_products_extra_fields` as F
left join `xu5z7_jshopping_products_extra_field_groups` as G
on G.id=F.
group
order by G.ordering, F.ordering
**EXPLAIN not possible on query: SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`group`, G.`name_en-GB` as groupname, multilist FROM `xu5z7_jshopping_products_extra_fields` as F left join `xu5z7_jshopping_products_extra_field_groups` as G on G.id=F.group order by G.ordering, F.ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/productfield.php:50
JROOT/components/com_jshopping/lib/factory.php:551
JROOT/components/com_jshopping/lib/functions.php:1097
JROOT/components/com_jshopping/lib/jtableauto.php:37
JROOT/components/com_jshopping/tables/category.php:172
JROOT/components/com_jshopping/controllers/category.php:116
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:45
**Query Time: 1.01 ms** **After last query: 0.35 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_taxes`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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:17
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:417
JROOT/components/com_jshopping/lib/functions.php:973
JROOT/components/com_jshopping/lib/jtableauto.php:87
JROOT/components/com_jshopping/lib/jtableauto.php:74
JROOT/components/com_jshopping/tables/category.php:172
JROOT/components/com_jshopping/controllers/category.php:116
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:45
**Query Time: 0.45 ms** **After last query: 0.05 ms**
SELECT tax_id, tax_name, tax_value
FROM `xu5z7_jshopping_taxes`
**EXPLAIN not possible on query: SELECT tax_id, tax_name, tax_value FROM `xu5z7_jshopping_taxes`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/tax.php:24
JROOT/components/com_jshopping/lib/factory.php:403
JROOT/components/com_jshopping/lib/factory.php:418
JROOT/components/com_jshopping/lib/functions.php:973
JROOT/components/com_jshopping/lib/jtableauto.php:87
JROOT/components/com_jshopping/lib/jtableauto.php:74
JROOT/components/com_jshopping/tables/category.php:172
JROOT/components/com_jshopping/controllers/category.php:116
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:45
**Query Time: 0.93 ms** **After last query: 0.05 ms**
SELECT count(*)
FROM `xu5z7_jshopping_products_to_categories` AS pr_cat
INNER JOIN `xu5z7_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,5)
**EXPLAIN not possible on query: SELECT count(*) FROM `xu5z7_jshopping_products_to_categories` AS pr_cat
INNER JOIN `xu5z7_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,5)**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/category.php:182
JROOT/components/com_jshopping/controllers/category.php:116
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:45
**Query Time: 1.18 ms** **After last query: 0.08 ms**
SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` 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 `xu5z7_jshopping_products` AS prod
LEFT JOIN `xu5z7_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,5)
ORDER BY name ASC
LIMIT 0, 10
**EXPLAIN not possible on query: SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` 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 `xu5z7_jshopping_products` AS prod
LEFT JOIN `xu5z7_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,5) ORDER BY name ASC LIMIT 0, 10**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/category.php:164
JROOT/components/com_jshopping/controllers/category.php:122
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:45
**Query Time: 1.10 ms** **After last query: 0.14 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_users`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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/usershop.php:14
JROOT/components/com_jshopping/lib/factory.php:122
JROOT/components/com_jshopping/lib/functions.php:662
JROOT/components/com_jshopping/tables/category.php:165
JROOT/components/com_jshopping/controllers/category.php:122
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:45
**Query Time: 1.04 ms** **After last query: 0.46 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_products_extra_field_values`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_products_extra_field_values`**
**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/productfieldvalue.php:16
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:559
JROOT/components/com_jshopping/lib/functions.php:805
JROOT/components/com_jshopping/lib/functions.php:730
JROOT/components/com_jshopping/tables/category.php:165
JROOT/components/com_jshopping/controllers/category.php:122
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:45
**Query Time: 0.75 ms** **After last query: 0.05 ms**
**Duplicate queries**:
#36SELECT id, `name_en-GB` as name, field_id
FROM `xu5z7_jshopping_products_extra_field_values`
order by ordering
**EXPLAIN not possible on query: SELECT id, `name_en-GB` as name, field_id FROM `xu5z7_jshopping_products_extra_field_values` order by ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/productfieldvalue.php:27
JROOT/components/com_jshopping/lib/factory.php:560
JROOT/components/com_jshopping/lib/functions.php:805
JROOT/components/com_jshopping/lib/functions.php:730
JROOT/components/com_jshopping/tables/category.php:165
JROOT/components/com_jshopping/controllers/category.php:122
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:45
**Query Time: 0.62 ms** **After last query: 0.63 ms**
select product_id as id, `alias_en-GB` as alias
from xu5z7_jshopping_products
where `alias_en-GB`!=''
**EXPLAIN not possible on query: select product_id as id, `alias_en-GB` as alias from xu5z7_jshopping_products where `alias_en-GB`!=''**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/lib/factory.php:351
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:518
JROOT/components/com_jshopping/lib/functions.php:468
JROOT/components/com_jshopping/controllers/category.php:123
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:45
**Query Time: 0.47 ms** **After last query: 0.03 ms**
select category_id as id, `alias_en-GB` as alias
from xu5z7_jshopping_categories
where `alias_en-GB`!=''
**EXPLAIN not possible on query: select category_id as id, `alias_en-GB` as alias from xu5z7_jshopping_categories where `alias_en-GB`!=''**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/lib/factory.php:317
JROOT/components/com_jshopping/router.php:71
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:518
JROOT/components/com_jshopping/lib/functions.php:468
JROOT/components/com_jshopping/controllers/category.php:123
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:45
**Query Time: 1.03 ms** **After last query: 12.06 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_products_reviews`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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:675
JROOT/components/com_jshopping/controllers/category.php:140
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:45
**Query Time: 0.96 ms** **After last query: 8.74 ms**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xu5z7_modules AS m
LEFT JOIN xu5z7_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xu5z7_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-12-06 04:03:18')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-06 04:03:18')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 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 xu5z7_modules AS m
LEFT JOIN xu5z7_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN xu5z7_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-12-06 04:03:18') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-06 04:03:18') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
JROOT/templates/yoo_sun/layouts/theme.config.php:26
JROOT/templates/yoo_sun/layouts/theme.php:5
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 1.18 ms** **After last query: 29.47 ms**
SHOW FULL COLUMNS
FROM `xu5z7_jshopping_usergroups`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_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/modules/mod_jshopping_filters/mod_jshopping_filters.php:45
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.94 ms** **After last query: 0.62 ms**
SELECT
COUNT(prod.product_id) AS count_prod
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
COUNT(prod.product_id) AS count_prod
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:316
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:915
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.76 ms** **After last query: 0.26 ms**
**Duplicate queries**:
#29SELECT id, `name_en-GB` as name, field_id
FROM `xu5z7_jshopping_products_extra_field_values`
order by ordering
**EXPLAIN not possible on query: SELECT id, `name_en-GB` as name, field_id FROM `xu5z7_jshopping_products_extra_field_values` order by ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_jshopping/tables/productfieldvalue.php:35
JROOT/components/com_jshopping/lib/factory.php:569
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1257
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.95 ms** **After last query: 0.39 ms**
SELECT
prod.extra_field_2 AS f_2, prod.extra_field_5 AS f_5, prod.extra_field_7 AS f_7, prod.extra_field_6 AS f_6, prod.extra_field_3 AS f_3, prod.extra_field_1 AS f_1
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat
WHERE
pr_cat.product_id = prod.product_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
prod.extra_field_2 AS f_2, prod.extra_field_5 AS f_5, prod.extra_field_7 AS f_7, prod.extra_field_6 AS f_6, prod.extra_field_3 AS f_3, prod.extra_field_1 AS f_1
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat
WHERE
pr_cat.product_id = prod.product_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:50
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1265
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.95 ms** **After last query: 3.23 ms**
SELECT
prod.extra_field_2 AS f_2
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
prod.extra_field_2 AS f_2
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:167
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1302
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.90 ms** **After last query: 0.13 ms**
SELECT
prod.extra_field_5 AS f_5
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
prod.extra_field_5 AS f_5
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:167
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1302
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.88 ms** **After last query: 0.18 ms**
SELECT
prod.extra_field_7 AS f_7
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
prod.extra_field_7 AS f_7
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:167
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1302
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.83 ms** **After last query: 0.10 ms**
SELECT
prod.extra_field_6 AS f_6
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
prod.extra_field_6 AS f_6
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:167
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1302
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.78 ms** **After last query: 0.09 ms**
SELECT
prod.extra_field_3 AS f_3
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
prod.extra_field_3 AS f_3
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:167
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1302
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**Query Time: 0.78 ms** **After last query: 0.10 ms**
SELECT
prod.extra_field_1 AS f_1
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1
**EXPLAIN not possible on query: SELECT
prod.extra_field_1 AS f_1
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr
WHERE
pr_cat.product_id = prod.product_id
AND
curr.currency_id = prod.currency_id
AND
pr_cat.category_id = 1**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/modules/mod_jshopping_filters/lib/jsfilter_model.php:167
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:1302
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
**2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM xu5z7_extensions**
**2 × SELECT id, `name_en-GB` as name, field_id
FROM `xu5z7_jshopping_products_extra_field_values`**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM xu5z7_modules AS m
LEFT JOIN xu5z7_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN xu5z7_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**
**1 × SELECT
COUNT(prod.product_id) AS count_prod
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr****1 × select category_id as id, `alias_en-GB` as alias
from xu5z7_jshopping_categories**
**1 × select product_id as id, `alias_en-GB` as alias
from xu5z7_jshopping_products**
**1 × SELECT
prod.extra_field_2 AS f_2, prod.extra_field_5 AS f_5, prod.extra_field_7 AS f_7, prod.extra_field_6 AS f_6, prod.extra_field_3 AS f_3, prod.extra_field_1 AS f_1
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat****1 × SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` 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 `xu5z7_jshopping_products` AS prod
LEFT JOIN `xu5z7_jshopping_products_to_categories` AS pr_cat USING (product_id)**
**1 × SELECT
prod.extra_field_2 AS f_2
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr****1 × SELECT
prod.extra_field_3 AS f_3
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr****1 × SELECT
prod.extra_field_1 AS f_1
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr****1 × SELECT
prod.extra_field_6 AS f_6
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr****1 × SELECT
prod.extra_field_7 AS f_7
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr****1 × SELECT
prod.extra_field_5 AS f_5
FROM
xu5z7_jshopping_products AS prod,
xu5z7_jshopping_products_to_categories AS pr_cat,
xu5z7_jshopping_currencies AS curr****1 × SELECT count(*)
FROM `xu5z7_jshopping_products_to_categories` AS pr_cat
INNER JOIN `xu5z7_jshopping_products` AS prod
ON pr_cat.product_id = prod.product_id**
**1 × SELECT tax_id, tax_name, tax_value
FROM `xu5z7_jshopping_taxes**
**1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value
FROM `xu5z7_jshopping_currencies`**
**1 × select id,link
from xu5z7_menu**
**1 × SELECT *
FROM xu5z7_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 xu5z7_menu AS m
LEFT JOIN xu5z7_extensions AS e
ON m.component_id = e.extension_id**
**1 × SELECT folder AS type, element AS name, params
FROM xu5z7_extensions**
**1 × SELECT *
FROM xu5z7_languages**
**1 × SELECT id, home, template, s.params
FROM xu5z7_template_styles as s
LEFT JOIN xu5z7_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id**
**1 × SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image
FROM `xu5z7_jshopping_categories`**
**1 × SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`
group`, G.`name_en-GB` as groupname, multilist
FROM `xu5z7_jshopping_products_extra_fields` as F
left join `xu5z7_jshopping_products_extra_field_groups` as G
on G.id=F.
group**
**1 × SELECT *
FROM xu5z7_jshopping_vendors**
**1 × SELECT id
FROM xu5z7_jshopping_vendors**
**1 × SELECT *
FROM xu5z7_jshopping_categories**
**1 × SELECT `data`
FROM `xu5z7_session`**