**Query Time: 1.15 ms**
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'rcdotfh8budi6dtjv5t5g6rmo4'
**EXPLAIN not possible on query: SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'rcdotfh8budi6dtjv5t5g6rmo4'**
**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:42
**Query Time: 1.00 ms** **After last query: 1.29 ms**
DELETE
FROM `jos_session`
WHERE `time` < '1711631621'
**EXPLAIN not possible on query: DELETE
FROM `jos_session`
WHERE `time` < '1711631621'**
**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.82 ms** **After last query: 0.13 ms**
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'rcdotfh8budi6dtjv5t5g6rmo4'
LIMIT 0, 1
**EXPLAIN not possible on query: SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'rcdotfh8budi6dtjv5t5g6rmo4' 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:42
**Query Time: 1.21 ms** **After last query: 0.15 ms**
INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`)
VALUES
('rcdotfh8budi6dtjv5t5g6rmo4', 0, '1711632521')
**EXPLAIN not possible on query: INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) VALUES
('rcdotfh8budi6dtjv5t5g6rmo4', 0, '1711632521')**
**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:42
**Query Time: 1.00 ms** **After last query: 0.97 ms**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
**EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_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.31 ms** **After last query: 0.74 ms**
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_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 jos_usergroups AS a
LEFT JOIN jos_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:45
**Query Time: 0.19 ms** **After last query: 0.18 ms**
SELECT id, rules
FROM `jos_viewlevels`
**EXPLAIN not possible on query: SELECT id, rules
FROM `jos_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:45
**Query Time: 1.08 ms** **After last query: 0.21 ms**
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
**EXPLAIN not possible on query: SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1)
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: 1.37 ms** **After last query: 14.59 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 jos_menu AS m
LEFT JOIN jos_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 jos_menu AS m
LEFT JOIN jos_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.86 ms** **After last query: 1.39 ms**
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
**EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_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/libraries/joomla/application/web.php:990
JROOT/libraries/cms/application/site.php:130
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 1.16 ms** **After last query: 0.56 ms**
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"eb79bf15c362c1e151b42da1e1436059\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
**EXPLAIN not possible on query: UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"eb79bf15c362c1e151b42da1e1436059\"}'
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/libraries/joomla/application/web.php:990
JROOT/libraries/cms/application/site.php:130
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
**Query Time: 0.20 ms** **After last query: 0.71 ms**
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
**EXPLAIN not possible on query: SELECT *
FROM jos_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.75 ms** **After last query: 0.34 ms**
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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 jos_template_styles as s
LEFT JOIN jos_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: 0.28 ms** **After last query: 7.97 ms**
SELECT a.rules
FROM jos_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
**EXPLAIN not possible on query: SELECT a.rules
FROM jos_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/administrator/components/com_virtuemart/helpers/config.php:538
JROOT/administrator/components/com_virtuemart/helpers/config.php:511
JROOT/administrator/components/com_virtuemart/helpers/config.php:793
JROOT/components/com_virtuemart/virtuemart.php:24
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.19 ms** **After last query: 0.39 ms**
SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
**EXPLAIN not possible on query: SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/administrator/components/com_virtuemart/helpers/config.php:538
JROOT/administrator/components/com_virtuemart/helpers/config.php:511
JROOT/administrator/components/com_virtuemart/helpers/config.php:793
JROOT/components/com_virtuemart/virtuemart.php:24
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.43 ms** **After last query: 0.30 ms**
SHOW TABLES LIKE "jos_virtuemart_configs"
**EXPLAIN not possible on query: SHOW TABLES LIKE "jos_virtuemart_configs"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/config.php:499
JROOT/administrator/components/com_virtuemart/helpers/config.php:796
JROOT/components/com_virtuemart/virtuemart.php:24
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.19 ms** **After last query: 0.09 ms**
SELECT `config`
FROM `jos_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
**EXPLAIN not possible on query: SELECT `config` FROM `jos_virtuemart_configs` WHERE `virtuemart_config_id` = "1";**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/config.php:848
JROOT/components/com_virtuemart/virtuemart.php:24
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.28 ms** **After last query: 9.56 ms**
SELECT `virtuemart_custom_id`, `custom_title`
FROM `jos_virtuemart_customs`
WHERE `field_type` ="P"
**EXPLAIN not possible on query: SELECT `virtuemart_custom_id`, `custom_title` FROM `jos_virtuemart_customs` WHERE `field_type` ="P"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/components/com_virtuemart/views/category/view.html.php:361
JROOT/components/com_virtuemart/views/category/view.html.php:62
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.28 ms** **After last query: 2.74 ms**
SELECT `virtuemart_custom_id`, `custom_title`
FROM `jos_virtuemart_customs`
WHERE `custom_element` ="specification"
**EXPLAIN not possible on query: SELECT `virtuemart_custom_id`, `custom_title` FROM `jos_virtuemart_customs` WHERE `custom_element` ="specification"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/plugins/vmcustom/specification/specification.php:77
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_virtuemart/views/category/view.html.php:378
JROOT/components/com_virtuemart/views/category/view.html.php:62
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.32 ms** **After last query: 2.16 ms**
SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*
FROM `jos_virtuemart_categories`
INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "9"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.* FROM `jos_virtuemart_categories` INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`) WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "9"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/category.php:70
JROOT/components/com_virtuemart/views/category/view.html.php:109
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.17 ms** **After last query: 0.79 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "9"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "9" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/category.php:73
JROOT/components/com_virtuemart/views/category/view.html.php:109
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.08 ms**
SELECT `category_child_id`
FROM `jos_virtuemart_category_categories`
WHERE `category_parent_id` = 9
**EXPLAIN not possible on query: SELECT `category_child_id`
FROM `jos_virtuemart_category_categories`
WHERE `category_parent_id` = 9**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/category.php:663
JROOT/administrator/components/com_virtuemart/models/category.php:84
JROOT/components/com_virtuemart/views/category/view.html.php:109
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.74 ms** **After last query: 0.08 ms**
SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total
FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`
WHERE `jos_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 9
AND `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id`
AND `jos_virtuemart_products`.`published` = "1"
**EXPLAIN not possible on query: SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total
FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`
WHERE `jos_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `jos_virtuemart_product_categories`.`virtuemart_category_id` = 9
AND `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id`
AND `jos_virtuemart_products`.`published` = "1"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/category.php:389
JROOT/administrator/components/com_virtuemart/models/category.php:91
JROOT/components/com_virtuemart/views/category/view.html.php:109
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.80 ms** **After last query: 0.10 ms**
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 9
**EXPLAIN not possible on query: SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM jos_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 9**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/category.php:757
JROOT/administrator/components/com_virtuemart/models/category.php:692
JROOT/administrator/components/com_virtuemart/models/category.php:94
JROOT/components/com_virtuemart/views/category/view.html.php:109
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.72 ms** **After last query: 0.09 ms**
SELECT `virtuemart_category_id`, `category_name`
FROM `jos_virtuemart_categories_en_gb` as l
WHERE `virtuemart_category_id`= 9
**EXPLAIN not possible on query: SELECT `virtuemart_category_id`, `category_name` FROM `jos_virtuemart_categories_en_gb` as l WHERE `virtuemart_category_id`= 9**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/category.php:728
JROOT/administrator/components/com_virtuemart/models/category.php:94
JROOT/components/com_virtuemart/views/category/view.html.php:109
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.22 ms** **After last query: 1.71 ms**
SELECT *
FROM `jos_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:119
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
JROOT/administrator/components/com_virtuemart/models/user.php:163
JROOT/administrator/components/com_virtuemart/models/user.php:114
JROOT/administrator/components/com_virtuemart/models/product.php:367
JROOT/components/com_virtuemart/views/category/view.html.php:120
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.23 ms** **After last query: 0.22 ms**
SELECT `jos_virtuemart_shoppergroups`.*
FROM `jos_virtuemart_shoppergroups`
WHERE `jos_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_shoppergroups`.* FROM `jos_virtuemart_shoppergroups` WHERE `jos_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:124
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
JROOT/administrator/components/com_virtuemart/models/user.php:163
JROOT/administrator/components/com_virtuemart/models/user.php:114
JROOT/administrator/components/com_virtuemart/models/product.php:367
JROOT/components/com_virtuemart/views/category/view.html.php:120
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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: 3.08 ms** **After last query: 2.26 ms**
SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
FROM `jos_virtuemart_products` as p
LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_categories_en_gb` as cl
ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( `pc`.`virtuemart_category_id` = 9
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `category_name` ASC, `virtuemart_product_id` ASC
LIMIT 18, 18
**EXPLAIN not possible on query: SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `jos_virtuemart_products` as p
LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `jos_virtuemart_categories_en_gb` as cl ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( `pc`.`virtuemart_category_id` = 9 AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" )
group by p.`virtuemart_product_id`
ORDER BY `category_name` ASC, `virtuemart_product_id` ASC LIMIT 18, 18**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:839
JROOT/administrator/components/com_virtuemart/models/product.php:661
JROOT/components/com_virtuemart/views/category/view.html.php:120
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.50 ms** **After last query: 0.11 ms**
SELECT FOUND_ROWS()
**EXPLAIN not possible on query: SELECT FOUND_ROWS()**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:853
JROOT/administrator/components/com_virtuemart/models/product.php:661
JROOT/components/com_virtuemart/views/category/view.html.php:120
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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: 4.48 ms** **After last query: 2.59 ms**
SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `jos_virtuemart_manufacturers_en_gb` as l
INNER JOIN `jos_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
INNER JOIN `jos_virtuemart_products` as p
ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
INNER JOIN `jos_virtuemart_product_categories` as c
ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
WHERE p.`published` =1
AND c.`virtuemart_category_id` =9
ORDER BY `mf_name`
**EXPLAIN not possible on query: SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id` FROM `jos_virtuemart_manufacturers_en_gb` as l INNER JOIN `jos_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`) INNER JOIN `jos_virtuemart_products` as p ON p.`virtuemart_product_id` = pm.`virtuemart_product_id` INNER JOIN `jos_virtuemart_product_categories` as c ON c.`virtuemart_product_id` = pm.`virtuemart_product_id` WHERE p.`published` =1 AND c.`virtuemart_category_id` =9 ORDER BY `mf_name`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/manufacturer.php:211
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/product.php:2327
JROOT/components/com_virtuemart/views/category/view.html.php:130
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.33 ms** **After last query: 1.82 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1800"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1800"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.35 ms** **After last query: 1.19 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1800"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1800" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.80 ms** **After last query: 0.78 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1800"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1800"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.34 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1800"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1800" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.83 ms** **After last query: 0.51 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1800"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1800"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.32 ms** **After last query: 0.13 ms**
SELECT `jos_virtuemart_manufacturers`.* ,`jos_virtuemart_manufacturers_en_gb`.*
FROM `jos_virtuemart_manufacturers`
INNER JOIN `jos_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
WHERE `jos_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_manufacturers`.* ,`jos_virtuemart_manufacturers_en_gb`.* FROM `jos_virtuemart_manufacturers` INNER JOIN `jos_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`) WHERE `jos_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1190
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.95 ms** **After last query: 0.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1800
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1800**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.78 ms** **After last query: 1.24 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1800)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1800) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.23 ms** **After last query: 1.26 ms**
SELECT *
FROM `jos_virtuemart_currencies` AS c
, `jos_virtuemart_vendors` AS v
WHERE v.virtuemart_vendor_id = 1
AND v.vendor_currency = c.virtuemart_currency_id
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_currencies` AS c
, `jos_virtuemart_vendors` AS v
WHERE v.virtuemart_vendor_id = 1
AND v.vendor_currency = c.virtuemart_currency_id**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/vendor.php:256
JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:49
JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:98
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.37 ms** **After last query: 0.59 ms**
SELECT `jos_virtuemart_currencies`.*
FROM `jos_virtuemart_currencies`
WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "52"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_currencies`.* FROM `jos_virtuemart_currencies` WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "52"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:114
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.46 ms** **After last query: 1.14 ms**
SHOW FULL COLUMNS
FROM `jos_virtuemart_userfields`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_virtuemart_userfields`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:647
JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:204
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593
JROOT/administrator/components/com_virtuemart/models/userfields.php:51
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545
JROOT/components/com_virtuemart/helpers/cart.php:248
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.22 ms** **After last query: 2.41 ms**
SELECT *
FROM `jos_virtuemart_userfields`
WHERE 1 = 1
AND `account`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY ordering
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_userfields` WHERE 1 = 1 AND `account`=1 AND published = 1 AND FIND_IN_SET(name, 'address_type') = 0 ORDER BY ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
JROOT/administrator/components/com_virtuemart/models/userfields.php:586
JROOT/administrator/components/com_virtuemart/models/userfields.php:487
JROOT/components/com_virtuemart/helpers/cart.php:259
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.42 ms** **After last query: 0.83 ms**
SHOW FULL COLUMNS
FROM `jos_assets`
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_assets`**
**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/libraries/joomla/table/asset.php:61
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/joomla/access/access.php:100
JROOT/libraries/joomla/user/user.php:393
JROOT/administrator/components/com_virtuemart/helpers/config.php:1261
JROOT/administrator/components/com_virtuemart/models/userfields.php:751
JROOT/components/com_virtuemart/helpers/cart.php:264
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.18 ms** **After last query: 0.27 ms**
SELECT id
FROM jos_assets
WHERE parent_id = 0
**EXPLAIN not possible on query: SELECT id
FROM jos_assets
WHERE parent_id = 0**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/joomla/table/nested.php:1226
JROOT/libraries/joomla/access/access.php:101
JROOT/libraries/joomla/user/user.php:393
JROOT/administrator/components/com_virtuemart/helpers/config.php:1261
JROOT/administrator/components/com_virtuemart/models/userfields.php:751
JROOT/components/com_virtuemart/helpers/cart.php:264
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.19 ms** **After last query: 0.16 ms**
SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
**EXPLAIN not possible on query: SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/administrator/components/com_virtuemart/helpers/config.php:1261
JROOT/administrator/components/com_virtuemart/models/userfields.php:751
JROOT/components/com_virtuemart/helpers/cart.php:264
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.17 ms** **After last query: 0.74 ms**
SELECT fieldtitle, fieldvalue
FROM jos_virtuemart_userfield_values
WHERE virtuemart_userfield_id = 10
ORDER BY ordering
**EXPLAIN not possible on query: SELECT fieldtitle, fieldvalue FROM jos_virtuemart_userfield_values WHERE virtuemart_userfield_id = 10 ORDER BY ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
JROOT/administrator/components/com_virtuemart/models/userfields.php:981
JROOT/components/com_virtuemart/helpers/cart.php:264
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.43 ms** **After last query: 1.42 ms**
SELECT *
FROM `jos_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:843
JROOT/administrator/components/com_virtuemart/models/country.php:113
JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:154
JROOT/administrator/components/com_virtuemart/models/userfields.php:811
JROOT/components/com_virtuemart/helpers/cart.php:264
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.28 ms** **After last query: 17.81 ms**
SELECT *
FROM `jos_virtuemart_userfields`
WHERE 1 = 1
AND `shipment`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY ordering
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_userfields` WHERE 1 = 1 AND `shipment`=1 AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
JROOT/administrator/components/com_virtuemart/models/userfields.php:586
JROOT/administrator/components/com_virtuemart/models/userfields.php:493
JROOT/components/com_virtuemart/helpers/cart.php:259
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.00 ms** **After last query: 15.69 ms**
SELECT *
FROM jos_virtuemart_calcs
LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-03-28 13:28:41" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-28 13:28:41" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
**EXPLAIN not possible on query: SELECT * FROM jos_virtuemart_calcs LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-03-28 13:28:41" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-28 13:28:41" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:179
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2251
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.79 ms** **After last query: 0.39 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1803"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1803"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.80 ms** **After last query: 0.57 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1803"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1803" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1803"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1803"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.55 ms** **After last query: 0.10 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1803"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1803" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1803"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1803"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.24 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1803
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1803**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.70 ms** **After last query: 0.27 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1803)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1803) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.72 ms** **After last query: 0.46 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1805"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1805"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.86 ms** **After last query: 0.43 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1805"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1805" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.49 ms** **After last query: 0.26 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1805"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1805"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.53 ms** **After last query: 0.08 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1805"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1805" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.58 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1805"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1805"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.64 ms** **After last query: 0.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1805
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1805**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.16 ms** **After last query: 0.26 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1805)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1805) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.21 ms** **After last query: 0.42 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1806"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1806"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.20 ms** **After last query: 0.46 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1806"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1806" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.27 ms** **After last query: 0.27 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1806"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1806"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.10 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1806"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1806" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.17 ms** **After last query: 0.31 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1806"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1806"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.16 ms** **After last query: 0.22 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1806
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1806**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.20 ms** **After last query: 0.27 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1806)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1806) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.69 ms** **After last query: 0.44 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1807"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1807"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.61 ms** **After last query: 0.50 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1807"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1807" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.25 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1807"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1807"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.57 ms** **After last query: 0.09 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1807"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1807" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.58 ms** **After last query: 0.33 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1807"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1807"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.22 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1807
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1807**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.32 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1807)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1807) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.70 ms** **After last query: 0.63 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1811"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1811"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.54 ms** **After last query: 0.45 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1811"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1811" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.25 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1811"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1811"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.54 ms** **After last query: 0.10 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1811"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1811" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.31 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1811"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1811"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.49 ms** **After last query: 0.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1811
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1811**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.00 ms** **After last query: 0.24 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1811)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1811) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.39 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1812"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1812"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.45 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1812"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1812" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.43 ms** **After last query: 0.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1812"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1812"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.09 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1812"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1812" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1812"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1812"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1812
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1812**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.05 ms** **After last query: 0.25 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1812)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1812) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.64 ms** **After last query: 0.43 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1813"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1813"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.50 ms** **After last query: 0.44 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1813"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1813" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.43 ms** **After last query: 0.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1813"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1813"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.09 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1813"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1813" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1813"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1813"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.53 ms** **After last query: 0.20 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1813
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1813**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.00 ms** **After last query: 0.24 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1813)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1813) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.66 ms** **After last query: 0.41 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1822"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1822"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.43 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1822"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1822" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.44 ms** **After last query: 0.26 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1822"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1822"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.53 ms** **After last query: 0.08 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1822"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1822" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1822"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1822"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.50 ms** **After last query: 0.20 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1822
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1822**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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: 0.25 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1822)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1822) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.63 ms** **After last query: 0.43 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1825"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1825"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.53 ms** **After last query: 0.42 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1825"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1825" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1825"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1825"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.53 ms** **After last query: 0.09 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1825"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1825" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.30 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1825"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1825"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1825
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1825**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.06 ms** **After last query: 0.24 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1825)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1825) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.63 ms** **After last query: 0.43 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1826"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1826"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.50 ms** **After last query: 0.44 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1826"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1826" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.43 ms** **After last query: 0.25 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1826"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1826"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.09 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1826"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1826" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.49 ms** **After last query: 0.31 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1826"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1826"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1826
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1826**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.02 ms** **After last query: 0.24 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1826)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1826) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.63 ms** **After last query: 0.44 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1829"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1829"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.44 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1829"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1829" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.43 ms** **After last query: 0.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1829"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1829"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.08 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1829"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1829" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.31 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1829"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1829"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.20 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1829
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1829**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.24 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1829)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1829) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.20 ms** **After last query: 0.43 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1831"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "1831"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.17 ms** **After last query: 0.43 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1831"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1831" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.19 ms** **After last query: 0.27 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1831"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1831"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.51 ms** **After last query: 0.10 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1831"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1831" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.17 ms** **After last query: 0.31 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "1831"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1831"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.16 ms** **After last query: 0.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 1831
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1831**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.21 ms** **After last query: 0.24 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (1831)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (1831) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.64 ms** **After last query: 0.45 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2154"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2154"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.43 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "2154"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2154" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.42 ms** **After last query: 0.25 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "2154"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "2154"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.53 ms** **After last query: 0.08 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "2154"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2154" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.49 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "2154"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "2154"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.20 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2154
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2154**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.98 ms** **After last query: 0.25 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (2154)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (2154) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.64 ms** **After last query: 0.40 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2155"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2155"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.50 ms** **After last query: 0.44 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "2155"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2155" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.43 ms** **After last query: 0.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "2155"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "2155"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.53 ms** **After last query: 0.08 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "2155"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2155" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.50 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "2155"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "2155"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.20 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2155
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2155**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.98 ms** **After last query: 0.26 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (2155)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (2155) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.66 ms** **After last query: 0.39 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2156"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2156"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.43 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "2156"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2156" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.43 ms** **After last query: 0.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "2156"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "2156"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.09 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "2156"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2156" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.48 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "2156"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "2156"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.46 ms** **After last query: 0.21 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2156
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2156**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.25 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (2156)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (2156) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.63 ms** **After last query: 0.39 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2157"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2157"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.43 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "2157"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2157" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.41 ms** **After last query: 0.25 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "2157"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "2157"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.09 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "2157"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2157" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.49 ms** **After last query: 0.29 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "2157"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "2157"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.50 ms** **After last query: 0.22 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2157
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2157**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.07 ms** **After last query: 0.26 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (2157)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (2157) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.64 ms** **After last query: 0.39 ms**
SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*
FROM `jos_virtuemart_products`
INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2158"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.* FROM `jos_virtuemart_products` INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "2158"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1162
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.52 ms** **After last query: 0.43 ms**
SELECT `virtuemart_media_id`
FROM `jos_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "2158"
ORDER BY `ordering`
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "2158" ORDER BY `ordering`**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1167
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.61 ms** **After last query: 0.24 ms**
SELECT `virtuemart_shoppergroup_id`
FROM `jos_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "2158"
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "2158"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1170
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.92 ms** **After last query: 0.12 ms**
SELECT *
FROM `jos_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "2158"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) )
ORDER BY `product_price` DESC
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "2158" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-03-28 13:28:41" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 13:28:41" ) ) ORDER BY `product_price` DESC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1014
JROOT/administrator/components/com_virtuemart/models/product.php:1033
JROOT/administrator/components/com_virtuemart/models/product.php:1182
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.57 ms**
SELECT `virtuemart_manufacturer_id`
FROM `jos_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "2158"
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "2158"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1185
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.74 ms** **After last query: 0.34 ms**
SELECT *
FROM `jos_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2158
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2158**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/product.php:1391
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.46 ms** **After last query: 0.40 ms**
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c
LEFT JOIN `jos_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (2158)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
**EXPLAIN not possible on query: SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `jos_virtuemart_customs` AS c LEFT JOIN `jos_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (2158) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2244
JROOT/administrator/components/com_virtuemart/models/product.php:914
JROOT/administrator/components/com_virtuemart/models/product.php:1533
JROOT/components/com_virtuemart/views/category/view.html.php:132
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.85 ms** **After last query: 1.55 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1351"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1351"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.78 ms** **After last query: 1.14 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1352"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1352"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.76 ms** **After last query: 0.65 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1353"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1353"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.28 ms** **After last query: 0.63 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1354"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1354"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.76 ms** **After last query: 0.52 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1566"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1566"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.77 ms** **After last query: 0.62 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1356"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1356"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.05 ms** **After last query: 0.63 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1110"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1110"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.78 ms** **After last query: 0.57 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1120"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1120"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.82 ms** **After last query: 0.62 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1359"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1359"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.77 ms** **After last query: 0.48 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1360"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1360"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.12 ms** **After last query: 0.61 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1361"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1361"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.79 ms** **After last query: 0.62 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1362"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1362"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.30 ms** **After last query: 0.63 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1363"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1363"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.76 ms** **After last query: 0.47 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1528"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1528"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.64 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1529"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1529"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.85 ms** **After last query: 0.61 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1530"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1530"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.76 ms** **After last query: 0.62 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1531"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1531"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.76 ms** **After last query: 0.51 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1532"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1532"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:134
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.32 ms** **After last query: 27.25 ms**
SELECT `jos_virtuemart_medias`.*
FROM `jos_virtuemart_medias`
WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1331"
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1331"**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/media.php:98
JROOT/administrator/components/com_virtuemart/models/media.php:415
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
JROOT/components/com_virtuemart/views/category/view.html.php:215
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:124
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.79 ms** **After last query: 27.57 ms**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2024-03-28 13:28:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 13:28:41')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 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 jos_modules AS m
LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2024-03-28 13:28:41') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 13:28:41') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 0 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:514
JROOT/templates/siteground-j16-24/index.php:72
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