Joomla! Debug Console

50 Queries Logged 24.1 ms

**Query Time: 0.44 ms**
```
SELECT `data`

  FROM `jos_session`

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

  FROM `jos_session`

  WHERE `time` < '1714141551'
```
**Explain**
**EXPLAIN not possible on query: DELETE FROM `jos_session` WHERE `time` < '1714141551'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.26 ms** **After last query: 0.10 ms**
```
SELECT `session_id`

  FROM `jos_session`

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

  FROM jos_extensions

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

  FROM `jos_viewlevels`
```
**Explain**
**EXPLAIN not possible on query: SELECT id, rules FROM `jos_viewlevels`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.61 ms** **After last query: 0.12 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.84 ms** **After last query: 8.29 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.32 ms** **After last query: 0.79 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jos_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Explain**
**EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'library' AND `element` = 'joomla'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.87 ms** **After last query: 0.38 ms**
```
UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"5864d609478e7217f2a69c29871f7aa2\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Explain**
**EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"5864d609478e7217f2a69c29871f7aa2\"}' WHERE `type` = 'library' AND `element` = 'joomla'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.10 ms** **After last query: 0.42 ms**
```
SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/language/helper.php:164
JROOT/libraries/cms/application/site.php:329
JROOT/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.36 ms** **After last query: 0.26 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.13 ms** **After last query: 4.52 ms**
```
SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
**Explain**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.09 ms** **After last query: 0.24 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.80 ms** **After last query: 0.17 ms**
```
SHOW TABLES LIKE "jos_virtuemart_configs"
```
**Explain**
**EXPLAIN not possible on query: SHOW TABLES LIKE "jos_virtuemart_configs"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.11 ms** **After last query: 0.05 ms**
```
SELECT `config` 
  FROM `jos_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";
```
**Explain**
**EXPLAIN not possible on query: SELECT `config` FROM `jos_virtuemart_configs` WHERE `virtuemart_config_id` = "1";**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.13 ms** **After last query: 9.09 ms**
```
SELECT * 
  FROM `jos_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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:1137
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.22 ms** **After last query: 0.14 ms**
```
SELECT `jos_virtuemart_shoppergroups`.*  
  FROM `jos_virtuemart_shoppergroups`  
  WHERE `jos_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
```
**Explain**
**EXPLAIN not possible on query: SELECT `jos_virtuemart_shoppergroups`.* FROM `jos_virtuemart_shoppergroups` WHERE `jos_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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:1137
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.75 ms** **After last query: 1.23 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` = "1845"
```
**Explain**
**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` = "1845"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.32 ms** **After last query: 0.44 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "1845" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_product_medias` WHERE `virtuemart_product_id` = "1845" ORDER BY `ordering`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.22 ms** **After last query: 0.25 ms**
```
SELECT `virtuemart_shoppergroup_id` 
  FROM `jos_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "1845"
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_shoppergroup_id` FROM `jos_virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "1845"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.26 ms** **After last query: 0.10 ms**
```
SELECT * 
  FROM `jos_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "1845"  
  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-04-26 14:40:51" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-26 14:40:51" ) ) 
  ORDER BY `product_price` DESC
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = "1845" 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-04-26 14:40:51" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-26 14:40:51" ) ) ORDER BY `product_price` DESC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.64 ms** **After last query: 0.30 ms**
```
SELECT `virtuemart_manufacturer_id` 
  FROM `jos_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "1845"
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_manufacturer_id` FROM `jos_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "1845"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.09 ms** **After last query: 0.16 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**
**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"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.32 ms** **After last query: 0.14 ms**
```
SELECT * 
  FROM `jos_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 1845
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1845**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.34 ms** **After last query: 0.20 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` = "1"
```
**Explain**
**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` = "1"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
JROOT/administrator/components/com_virtuemart/models/product.php:1396
JROOT/administrator/components/com_virtuemart/models/product.php:1201
JROOT/administrator/components/com_virtuemart/models/product.php:845
JROOT/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.88 ms** **After last query: 0.53 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 (1845) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
```
**Explain**
**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 (1845) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.13 ms** **After last query: 0.78 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.08 ms** **After last query: 0.37 ms**
```
SELECT `jos_virtuemart_currencies`.*  
  FROM `jos_virtuemart_currencies`  
  WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "52"
```
**Explain**
**EXPLAIN not possible on query: SELECT `jos_virtuemart_currencies`.* FROM `jos_virtuemart_currencies` WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "52"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.08 ms** **After last query: 0.70 ms**
```
SHOW FULL COLUMNS  
  FROM `jos_virtuemart_userfields`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_virtuemart_userfields`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.11 ms** **After last query: 1.37 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.07 ms** **After last query: 0.64 ms**
```
SHOW FULL COLUMNS 
  FROM `jos_assets`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_assets`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.34 ms** **After last query: 0.15 ms**
```
SELECT id

  FROM jos_assets

  WHERE parent_id = 0
```
**Explain**
**EXPLAIN not possible on query: SELECT id FROM jos_assets WHERE parent_id = 0**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.11 ms** **After last query: 0.09 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.11 ms** **After last query: 0.49 ms**
```
SELECT fieldtitle, fieldvalue 
  FROM jos_virtuemart_userfield_values 
  WHERE virtuemart_userfield_id = 10 
  ORDER BY ordering
```
**Explain**
**EXPLAIN not possible on query: SELECT fieldtitle, fieldvalue FROM jos_virtuemart_userfield_values WHERE virtuemart_userfield_id = 10 ORDER BY ordering**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.25 ms** **After last query: 0.88 ms**
```
SELECT * 
  FROM `jos_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY country_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM `jos_virtuemart_countries` WHERE `published` = 1 ORDER BY country_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.16 ms** **After last query: 10.45 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**
**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**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.87 ms** **After last query: 8.86 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-04-26 14:40:51" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-26 14:40:51" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)
```
**Explain**
**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-04-26 14:40:51" ) AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-26 14:40:51" ) AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/components/com_virtuemart/views/productdetails/view.html.php:83
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.62 ms** **After last query: 1.16 ms**
```
SELECT `jos_virtuemart_medias`.*  
  FROM `jos_virtuemart_medias`  
  WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1369"
```
**Explain**
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1369"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/productdetails/view.html.php:144
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.11 ms** **After last query: 1.18 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_manufacturer_medias` 
  WHERE `virtuemart_manufacturer_id` = "1" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_manufacturer_medias` WHERE `virtuemart_manufacturer_id` = "1" ORDER BY `ordering`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/manufacturer.php:61
JROOT/components/com_virtuemart/views/productdetails/view.html.php:171
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.14 ms** **After last query: 0.68 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "1" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "1" ORDER BY `ordering`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/category.php:73
JROOT/components/com_virtuemart/views/productdetails/view.html.php:184
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.22 ms** **After last query: 0.05 ms**
```
SELECT `category_child_id`
			
  FROM `jos_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 1
```
**Explain**
**EXPLAIN not possible on query: SELECT `category_child_id` FROM `jos_virtuemart_category_categories` WHERE `category_parent_id` = 1**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:663
JROOT/administrator/components/com_virtuemart/models/category.php:84
JROOT/components/com_virtuemart/views/productdetails/view.html.php:184
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.80 ms** **After last query: 0.06 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` = 1
			
  AND `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id`
			
  AND `jos_virtuemart_products`.`published` = "1"
```
**Explain**
**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` = 1 AND `jos_virtuemart_products`.`virtuemart_product_id` = `jos_virtuemart_product_categories`.`virtuemart_product_id` AND `jos_virtuemart_products`.`published` = "1"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:389
JROOT/administrator/components/com_virtuemart/models/category.php:91
JROOT/components/com_virtuemart/views/productdetails/view.html.php:184
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.24 ms** **After last query: 0.09 ms**
```
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  jos_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 1
```
**Explain**
**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`= 1**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/productdetails/view.html.php:184
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.26 ms** **After last query: 0.07 ms**
```
SELECT `virtuemart_category_id`, `category_name`  
  FROM `jos_virtuemart_categories_en_gb` as l 
  WHERE `virtuemart_category_id`= 1
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_category_id`, `category_name` FROM `jos_virtuemart_categories_en_gb` as l WHERE `virtuemart_category_id`= 1**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:728
JROOT/administrator/components/com_virtuemart/models/category.php:94
JROOT/components/com_virtuemart/views/productdetails/view.html.php:184
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.62 ms** **After last query: 0.10 ms**
```
SELECT `jos_virtuemart_medias`.*  
  FROM `jos_virtuemart_medias`  
  WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1324"
```
**Explain**
**EXPLAIN not possible on query: SELECT `jos_virtuemart_medias`.* FROM `jos_virtuemart_medias` WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "1324"**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
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/productdetails/view.html.php:186
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.72 ms** **After last query: 96.95 ms**
```
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
  FROM   `jos_virtuemart_shipmentmethods` as i  
  LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l using (`virtuemart_shipmentmethod_id`) 
 
  LEFT JOIN `jos_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE i.`published` = "1" 
  AND j.`element` = "weight_countries"
	    						
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_shipmentmethod_id` 
  ORDER BY i.`ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.* FROM `jos_virtuemart_shipmentmethods` as i LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l using (`virtuemart_shipmentmethod_id`) LEFT JOIN `jos_extensions` as j ON j.`extension_id` = i.`shipment_jplugin_id` LEFT OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id` WHERE i.`published` = "1" AND j.`element` = "weight_countries" AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1") AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) GROUP BY i.`virtuemart_shipmentmethod_id` ORDER BY i.`ordering`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:530
JROOT/plugins/vmshipment/weight_countries/weight_countries.php:417
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_virtuemart/views/productdetails/view.html.php:305
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.52 ms** **After last query: 0.09 ms**
```
SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
  FROM   `jos_virtuemart_paymentmethods` as i  
  LEFT JOIN `jos_virtuemart_paymentmethods_en_gb` as l using (`virtuemart_paymentmethod_id`) 
 
  LEFT JOIN `jos_extensions` as j 
  ON j.`extension_id` =  i.`payment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s 
  ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
  WHERE i.`published` = "1" 
  AND j.`element` = "klarna"
	    						
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_paymentmethod_id` 
  ORDER BY i.`ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id , l.* FROM `jos_virtuemart_paymentmethods` as i LEFT JOIN `jos_virtuemart_paymentmethods_en_gb` as l using (`virtuemart_paymentmethod_id`) LEFT JOIN `jos_extensions` as j ON j.`extension_id` = i.`payment_jplugin_id` LEFT OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id` WHERE i.`published` = "1" AND j.`element` = "klarna" AND (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1") AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) GROUP BY i.`virtuemart_paymentmethod_id` ORDER BY i.`ordering`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:530
JROOT/plugins/vmpayment/klarna/klarna.php:137
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_virtuemart/views/productdetails/view.html.php:306
JROOT/components/com_virtuemart/controllers/productdetails.php:55
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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.67 ms** **After last query: 14.60 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-04-26 14:40:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 14:40:51') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 471 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering
```
**Explain**
**EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM 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-04-26 14:40:51') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 14:40:51') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 471 OR mm.menuid <= 0) ORDER BY m.position, m.ordering**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/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
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

46 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**2 × SELECT * 
  FROM `jos_virtuemart_userfields`**

**2 × SELECT `jos_virtuemart_medias`.*  
  FROM `jos_virtuemart_medias`**

**2 × SELECT b.rules 
  FROM jos_assets AS a 
  LEFT JOIN jos_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt**

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

**1 × SELECT fieldtitle, fieldvalue 
  FROM jos_virtuemart_userfield_values**

**1 × SELECT * 
  FROM `jos_virtuemart_countries`**

**1 × SELECT * 
  FROM jos_virtuemart_calcs  
  LEFT JOIN jos_virtuemart_calc_shoppergroups using(virtuemart_calc_id)**

```
**1 × SELECT id 
  FROM jos_assets**
```

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

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

**1 × SELECT *  
  FROM `jos_virtuemart_currencies` AS c    , `jos_virtuemart_vendors` AS v**

**1 × SELECT `jos_virtuemart_currencies`.*  
  FROM `jos_virtuemart_currencies`**

**1 × SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_manufacturer_medias`**

**1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  jos_virtuemart_category_categories AS `xref`**

**1 × SELECT `virtuemart_category_id`, `category_name`  
  FROM `jos_virtuemart_categories_en_gb` as l**

**1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,    j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
  FROM   `jos_virtuemart_shipmentmethods` as i  
  LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l using (`virtuemart_shipmentmethod_id`)   
  LEFT JOIN `jos_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`**

**1 × SELECT count(jos_virtuemart_products.virtuemart_product_id) AS total    
  FROM `jos_virtuemart_products`, `jos_virtuemart_product_categories`**

**1 × SELECT `category_child_id`    
  FROM `jos_virtuemart_category_categories`**

**1 × SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*  
  FROM `jos_virtuemart_categories` 
  INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`)**

**1 × SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias`**

**1 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,    j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
  FROM   `jos_virtuemart_paymentmethods` as i  
  LEFT JOIN `jos_virtuemart_paymentmethods_en_gb` as l using (`virtuemart_paymentmethod_id`)   
  LEFT JOIN `jos_extensions` as j 
  ON j.`extension_id` =  i.`payment_jplugin_id`    
  LEFT 
  OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s 
  ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`**

**1 × SELECT `jos_virtuemart_manufacturers`.* ,`jos_virtuemart_manufacturers_en_gb`.*  
  FROM `jos_virtuemart_manufacturers` 
  INNER JOIN `jos_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)**

**1 × SELECT * 
  FROM jos_languages**

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

**1 × SELECT a.rules 
  FROM jos_assets AS a**

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

**1 × SELECT folder AS type, element AS name, params 
  FROM jos_extensions**

**1 × SELECT `session_id` 
  FROM `jos_session`**

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

**1 × SELECT id, rules 
  FROM `jos_viewlevels**

**1 × SELECT `config` 
  FROM `jos_virtuemart_configs`**

**1 × SELECT * 
  FROM `jos_virtuemart_shoppergroups`**

**1 × SELECT * 
  FROM `jos_virtuemart_product_prices`**

**1 × SELECT `virtuemart_manufacturer_id` 
  FROM `jos_virtuemart_product_manufacturers`**

**1 × SELECT `data` 
  FROM `jos_session`**

**1 × SELECT `virtuemart_shoppergroup_id` 
  FROM `jos_virtuemart_product_shoppergroups`**

**1 × SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_product_medias`**

**1 × SELECT `jos_virtuemart_shoppergroups`.*  
  FROM `jos_virtuemart_shoppergroups`**

**1 × SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*  
  FROM `jos_virtuemart_products` 
  INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`)**

**1 × SELECT * 
  FROM `jos_virtuemart_product_categories`**

OTHER Tables:

**1 × SHOW FULL COLUMNS  
  FROM `jos_virtuemart_userfields**

**1 × SHOW FULL COLUMNS 
  FROM `jos_assets**

**1 × SHOW TABLES LIKE "jos_virtuemart_configs**

**1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"5864d609478e7217f2a69c29871f7aa2\"}'**

**1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('v9e4sq7csddslajc3tnjtqrs20', 0, '1714142451'**

```
**1 × DELETE  
  FROM `jos_session`**
```

Parsing errors in language files

Language Files Loaded

Untranslated Strings


# JROOT/administrator/components/com_virtuemart/helpers/vmtable.php

PAINTING_ID="id**"
COM_VIRTUEMART_VIRTUEMART_CATEGORY_ID="VIRTUEMART VIRTUEMART CATEGORY ID??"
COM_VIRTUEMART_VIRTUEMART_MANUFACTURER_ID="VIRTUEMART VIRTUEMART MANUFACTURER ID??"
COM_VIRTUEMART_VIRTUEMART_RATING_ID="VIRTUEMART VIRTUEMART RATING ID??"
COM_VIRTUEMART_VIRTUEMART_USERFIELD_ID="VIRTUEMART VIRTUEMART USERFIELD ID??"
COM_VIRTUEMART_VIRTUEMART_USER_ID="VIRTUEMART VIRTUEMART USER ID??"
COM_VIRTUEMART_VIRTUEMART_VENDOR_ID="VIRTUEMART VIRTUEMART VENDOR ID??"
COM_VIRTUEMART_VIRTUEMART_CATEGORY_ID="VIRTUEMART VIRTUEMART CATEGORY ID"
COM_VIRTUEMART_VIRTUEMART_MANUFACTURER_ID="VIRTUEMART VIRTUEMART MANUFACTURER ID"
COM_VIRTUEMART_VIRTUEMART_RATING_ID="VIRTUEMART VIRTUEMART RATING ID"
COM_VIRTUEMART_VIRTUEMART_USERFIELD_ID="VIRTUEMART VIRTUEMART USERFIELD ID"
COM_VIRTUEMART_VIRTUEMART_USER_ID="VIRTUEMART VIRTUEMART USER ID"
COM_VIRTUEMART_VIRTUEMART_VENDOR_ID="VIRTUEMART VIRTUEMART VENDOR ID"

# JROOT/administrator/components/com_virtuemart/models/shoppergroup.php

ANONYMOUS="-anonymous-"
SHOPPER_GROUP_FOR_ANONYMOUS_SHOPPERS="group for anonymous shoppers"

# JROOT/components/com_virtuemart/views/productdetails/view.html.php

1930S="1930s"

# JROOT/components/com_virtuemart/sublayouts/customfield.php

1934="1934"
B="B"
MODEL_AT_BATTERSEA_POLY_CARTOONS_ON_REVERSE="at Battersea Poly, cartoons on reverse"
WATER_COLOUR_ON_PAPER="colour on paper"

# JROOT/components/com_virtuemart/views/productdetails/tmpl/default.php

1930S="??1930s??"

# JROOT/components/com_virtuemart/sublayouts/prices.php

COM_VIRTUEMART_UNIT_SYMBOL_="VIRTUEMART UNIT SYMBOL ??"
COM_VIRTUEMART_UNIT_SYMBOL_="VIRTUEMART UNIT SYMBOL"

# JROOT/components/com_virtuemart/sublayouts/customfields.php

CONDITION="Condition"
DATE="Date"
MEDIUM="Medium"
SUBJECT="Subject"

# JROOT/administrator/components/com_virtuemart/models/userfields.php

MR="Mr"
MRS="Mrs"

Gallery Browse

Stay Informed

Gallery Search

Tess with horse

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

50 Queries Logged 24.1 ms

46 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings

Gallery Browse

Stay Informed

Gallery Search

Tess with horse

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**50 Queries Logged** 24.1 ms

**46 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

**OTHER Tables:**

**Parsing errors in language files**

**Language Files Loaded**

**Untranslated Strings**

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

50 Queries Logged 24.1 ms

46 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings