Gallery Browse

Stay Informed

Gallery Search

Art critic Ian Mayes summed up his work most succinctly in his review of his 1975 exhibition at St Catherine’s College, Cambridge.

“I know of few artists whose work communicates such a sense of joy in life as that which comes from these beautifully quiet, very modest and English paintings, so accurate in their evocation of the changing moods and feeling of nature. The landscapes (which together with the related paintings of enclosed gardens and cricket matches I consider to be his finest work) show that in his use of colour and simplified shapes he has found a personal and eloquent language, perfectly suited to its purpose; and an important part of that purpose is the expression of wonderment and delight in nature. “

The Art Critic Paddy Kitchin wrote one of the most thoughtful and perceptive criticisms of his work, then being shown at a retrospective at Northampton Art Gallery. Her article was published in Country Life Magazine of January 16^th 1992 under the title of ‘A kind of Renaissance Man’. The text is illustrated by a reproduction of The Storm, 1950, a gouache that demonstrates perfectly his ability to show both “beauty and threat in the landscape”

45 Queries Logged 53.6 ms

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

  FROM `jos_session`

  WHERE `session_id` = 'odempejrh7caj7ubfjde15m366'
```
**Explain**
**EXPLAIN not possible on query: SELECT `data` FROM `jos_session` WHERE `session_id` = 'odempejrh7caj7ubfjde15m366'**
**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: 1.26 ms** **After last query: 1.35 ms**
```
DELETE 

  FROM `jos_session`

  WHERE `time` < '1713625233'
```
**Explain**
**EXPLAIN not possible on query: DELETE FROM `jos_session` WHERE `time` < '1713625233'**
**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.81 ms** **After last query: 0.21 ms**
```
SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'odempejrh7caj7ubfjde15m366' 
  LIMIT 0, 1
```
**Explain**
**EXPLAIN not possible on query: SELECT `session_id` FROM `jos_session` WHERE `session_id` = 'odempejrh7caj7ubfjde15m366' 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.39 ms** **After last query: 0.29 ms**
```
INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('odempejrh7caj7ubfjde15m366', 0, '1713626133')
```
**Explain**
**EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('odempejrh7caj7ubfjde15m366', 0, '1713626133')**
**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: 1.25 ms** **After last query: 1.39 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.28 ms** **After last query: 0.77 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.27 ms** **After last query: 0.40 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: 1.73 ms** **After last query: 0.34 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.41 ms** **After last query: 24.64 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.87 ms** **After last query: 2.20 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: 1.13 ms** **After last query: 0.51 ms**
```
UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"7a1c12a7d36614ca88f16864414dec9f\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Explain**
**EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"7a1c12a7d36614ca88f16864414dec9f\"}' 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.18 ms** **After last query: 0.86 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.92 ms** **After last query: 0.54 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.42 ms** **After last query: 57.54 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/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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: 3.51 ms** **After last query: 0.43 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_content')

  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_content') 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/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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: 2.98 ms** **After last query: 0.76 ms**
```
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  on c.id = a.catid

  LEFT JOIN jos_users AS u 
  on u.id = a.created_by

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 76 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 15:15:33') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 15:15:33') 
  AND (a.state = 1 OR a.state =2)
```
**Explain**
**EXPLAIN not possible on query: SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 76 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 15:15:33') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 15:15:33') AND (a.state = 1 OR a.state =2)**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_content/models/article.php:159
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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: 5.37 ms** **After last query: 18.59 ms**
```
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=78 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft
```
**Explain**
**EXPLAIN not possible on query: SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=78 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/components/com_content/views/article/view.html.php:71
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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.66 ms** **After last query: 45.59 ms**
```
SELECT `m`.`tag_id`,`t`.*

  FROM `jos_contentitem_tag_map` AS m 

  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 76 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)
```
**Explain**
**EXPLAIN not possible on query: SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS m INNER JOIN `jos_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 76 AND `t`.`published` = 1 AND t.access IN (1,1)**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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: 3.30 ms** **After last query: 76.94 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_content.article.76')

  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_content.article.76') 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/plugins/content/pagenavigation/pagenavigation.php:54
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_content/views/article/view.html.php:166
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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.79 ms** **After last query: 0.51 ms**
```
SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM jos_content AS a

  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 78 
  AND a.state = 1 
  AND a.access IN (1,1)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-20 15:15:33') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 15:15:33')

  ORDER BY a.ordering
```
**Explain**
**EXPLAIN not possible on query: SELECT a.id, a.title, a.catid, a.language, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid WHERE a.catid = 78 AND a.state = 1 AND a.access IN (1,1) AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-20 15:15:33') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-20 15:15:33') ORDER BY a.ordering**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/plugins/content/pagenavigation/pagenavigation.php:152
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_content/views/article/view.html.php:166
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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: 2.91 ms** **After last query: 14.12 ms**
```
SHOW FULL COLUMNS 
  FROM `jos_content`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos_content`**
**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/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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.40 ms** **After last query: 38.39 ms**
```
SELECT *

  FROM jos_content

  WHERE `id` = '76'
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM jos_content WHERE `id` = '76'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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.72 ms** **After last query: 0.31 ms**
```
UPDATE jos_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '76'
```
**Explain**
**EXPLAIN not possible on query: UPDATE jos_content SET `hits` = (`hits` + 1) WHERE `id` = '76'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_content/models/article.php:266
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
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: 2.03 ms** **After last query: 42.21 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-20 15:15:33') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 15:15:33') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 470 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-20 15:15:33') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 15:15:33') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 470 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.**]
**Query Time: 0.25 ms** **After last query: 25.92 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/modules/mod_virtuemart_category/mod_virtuemart_category.php:26
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.18 ms** **After last query: 0.33 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/modules/mod_virtuemart_category/mod_virtuemart_category.php:26
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.30 ms** **After last query: 0.09 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/modules/mod_virtuemart_category/mod_virtuemart_category.php:26
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.38 ms** **After last query: 2.46 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 0  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 0 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php: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: 0.60 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.49 ms** **After last query: 0.26 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "2" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "2" 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php: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: 0.24 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "3" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "3" 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.57 ms** **After last query: 0.24 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "4" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "4" 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.58 ms** **After last query: 0.25 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "5" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "5" 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.50 ms** **After last query: 0.26 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "6" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "6" 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.23 ms** **After last query: 0.23 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "8" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "8" 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.50 ms** **After last query: 0.24 ms**
```
SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "9" 
  ORDER BY `ordering`
```
**Explain**
**EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `jos_virtuemart_category_medias` WHERE `virtuemart_category_id` = "9" 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:240
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.84 ms** **After last query: 1.00 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 1  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 1 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.96 ms** **After last query: 0.85 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 2  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 2 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.74 ms** **After last query: 0.86 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 3  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 3 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php: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: 0.86 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 4  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 4 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.68 ms** **After last query: 0.85 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 5  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 5 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php: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: 0.85 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 6  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 6 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.77 ms** **After last query: 0.88 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 8  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 8 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.77 ms** **After last query: 0.87 ms**
```
SELECT l.*
					
  FROM `jos_virtuemart_categories_en_gb` as l
					
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 9  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT l.* FROM `jos_virtuemart_categories_en_gb` as l INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `jos_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 9 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY category_name ASC**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:234
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:158
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:51
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.57 ms** **After last query: 0.30 ms**
```
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  jos_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 0
```
**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`= 0**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/administrator/components/com_virtuemart/models/category.php:757
JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:65
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**9 × SELECT l.*      
  FROM `jos_virtuemart_categories_en_gb` as l      
  INNER JOIN `jos_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `jos_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`**

**8 × SELECT `virtuemart_media_id` 
  FROM `jos_virtuemart_category_medias`**

**3 × 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 * 
  FROM jos_content**
```

**1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid**

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jos_contentitem_tag_map` AS m  
  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**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 `config` 
  FROM `jos_virtuemart_configs`**

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

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

**1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM jos_categories as c 
  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jos_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**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 id, rules 
  FROM `jos_viewlevels**

**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 `data` 
  FROM `jos_session`**

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

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

OTHER Tables:

**1 × UPDATE jos_content 
  SET `hits` = (`hits` + 1)**

**1 × SHOW TABLES LIKE "jos_virtuemart_configs**

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

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

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

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


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

COM_VIRTUEMART_VIRTUEMART_CATEGORY_ID="VIRTUEMART VIRTUEMART CATEGORY ID??"
COM_VIRTUEMART_STRING_ERROR_PRIMARY_KEY="VIRTUEMART STRING ERROR PRIMARY KEY"
COM_VIRTUEMART_VIRTUEMART_CATEGORY_ID="VIRTUEMART VIRTUEMART CATEGORY ID"

Gallery Browse

Stay Informed

Gallery Search

Reviews

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

45 Queries Logged 53.6 ms

27 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

Reviews

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**45 Queries Logged** 53.6 ms

**27 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

45 Queries Logged 53.6 ms

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings