Joomla! Debug Console

Time

Memory

222 Queries Logged 49.5 ms

1. Query Time: 0.26 ms

   DELETE 
   
     FROM `new_session`
   
     WHERE `time` < '1624067701'

   Explain

   EXPLAIN not possible on query: DELETE FROM `new_session` WHERE `time` < '1624067701'

   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:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.34 ms After last query: 0.09 ms

   SELECT `session_id`
   
     FROM `new_session`
   
     WHERE `session_id` = 'mr8legj0lgqm72iai90pgui1i4' 
     LIMIT 0, 1

   Explain

   EXPLAIN not possible on query: SELECT `session_id` FROM `new_session` WHERE `session_id` = 'mr8legj0lgqm72iai90pgui1i4' 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:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.49 ms After last query: 0.08 ms

   INSERT INTO `new_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('mr8legj0lgqm72iai90pgui1i4', 0, '1624068901')

   Explain

   EXPLAIN not possible on query: INSERT INTO `new_session` (`session_id`, `client_id`, `time`) VALUES ('mr8legj0lgqm72iai90pgui1i4', 0, '1624068901')

   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:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 0.12 ms After last query: 2.02 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM new_extensions
   
     WHERE `type` = 'component'

   Explain

   EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM new_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:52

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.11 ms After last query: 0.79 ms

   SELECT b.id
   
     FROM new_usergroups AS a
   
     LEFT JOIN new_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   EXPLAIN not possible on query: SELECT b.id FROM new_usergroups AS a LEFT JOIN new_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9

   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:52

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.07 ms After last query: 0.31 ms

   SELECT id, rules
   
     FROM `new_viewlevels`

   Explain

   EXPLAIN not possible on query: SELECT id, rules FROM `new_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:52

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 0.45 ms After last query: 0.10 ms

   SELECT folder AS type, element AS name, params
   
     FROM new_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM new_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) 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:52

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 0.52 ms After last query: 6.80 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 new_menu AS m
   
     LEFT JOIN new_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 new_menu AS m LEFT JOIN new_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:52

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.28 ms After last query: 0.57 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM new_extensions
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM new_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/plugins/system/sef/sef.php:29

   JROOT/libraries/joomla/event/event.php:69

   JROOT/libraries/joomla/event/dispatcher.php:160

   JROOT/libraries/joomla/application/base.php:106

   JROOT/libraries/cms/application/cms.php:1098

   JROOT/libraries/cms/application/site.php:763

   JROOT/libraries/cms/application/site.php:215

   JROOT/libraries/cms/application/cms.php:252

   JROOT/index.php:52

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 0.21 ms After last query: 0.72 ms

    UPDATE `new_extensions`
    
      SET `params` = '{\"mediaversion\":\"2ef051c002618629c10df19cbfec8da8\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `new_extensions` SET `params` = '{\"mediaversion\":\"2ef051c002618629c10df19cbfec8da8\"}' 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/plugins/system/sef/sef.php:29

    JROOT/libraries/joomla/event/event.php:69

    JROOT/libraries/joomla/event/dispatcher.php:160

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1098

    JROOT/libraries/cms/application/site.php:763

    JROOT/libraries/cms/application/site.php:215

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.11 ms After last query: 2.66 ms

    SELECT *
    
      FROM new_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM new_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:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 0.32 ms After last query: 0.19 ms

    SELECT id, home, template, s.params
    
      FROM new_template_styles as s
    
      LEFT JOIN new_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 new_template_styles as s LEFT JOIN new_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:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.09 ms After last query: 5.76 ms

    SELECT a.rules
    
      FROM new_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 new_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:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 0.08 ms After last query: 0.33 ms

    SELECT b.rules
    
      FROM new_assets AS a
    
      LEFT JOIN new_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 new_assets AS a LEFT JOIN new_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:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 0.69 ms After last query: 0.64 ms

    SHOW TABLES LIKE "new_virtuemart_configs"

    Explain

    EXPLAIN not possible on query: SHOW TABLES LIKE "new_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:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 0.11 ms After last query: 0.05 ms

    SELECT `config` 
      FROM `new_virtuemart_configs` 
      WHERE `virtuemart_config_id` = "1";

    Explain

    EXPLAIN not possible on query: SELECT `config` FROM `new_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:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 0.09 ms After last query: 9.12 ms

    SELECT `virtuemart_custom_id`, `custom_title` 
      FROM `new_virtuemart_customs` 
      WHERE `field_type` ="P"

    Explain

    EXPLAIN not possible on query: SELECT `virtuemart_custom_id`, `custom_title` FROM `new_virtuemart_customs` WHERE `field_type` ="P"

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_virtuemart/views/category/view.html.php:361

    JROOT/components/com_virtuemart/views/category/view.html.php:62

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 0.08 ms After last query: 3.29 ms

    SELECT `virtuemart_custom_id`, `custom_title` 
      FROM `new_virtuemart_customs` 
      WHERE `custom_element` ="specification"

    Explain

    EXPLAIN not possible on query: SELECT `virtuemart_custom_id`, `custom_title` FROM `new_virtuemart_customs` WHERE `custom_element` ="specification"

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/plugins/vmcustom/specification/specification.php:77

    JROOT/libraries/joomla/event/event.php:69

    JROOT/libraries/joomla/event/dispatcher.php:160

    JROOT/components/com_virtuemart/views/category/view.html.php:378

    JROOT/components/com_virtuemart/views/category/view.html.php:62

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 0.09 ms After last query: 4.40 ms

    SELECT `new_virtuemart_categories`.* ,`new_virtuemart_categories_ru_ru`.*  
      FROM `new_virtuemart_categories` 
      INNER JOIN `new_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) 
      WHERE `new_virtuemart_categories`.`virtuemart_category_id` = "91"

    Explain

    EXPLAIN not possible on query: SELECT `new_virtuemart_categories`.* ,`new_virtuemart_categories_ru_ru`.* FROM `new_virtuemart_categories` INNER JOIN `new_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) WHERE `new_virtuemart_categories`.`virtuemart_category_id` = "91"

    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/category.php:70

    JROOT/components/com_virtuemart/views/category/view.html.php:109

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 0.11 ms After last query: 0.59 ms

    SELECT `virtuemart_media_id` 
      FROM `new_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "91" 
      ORDER BY `ordering`

    Explain

    EXPLAIN not possible on query: SELECT `virtuemart_media_id` FROM `new_virtuemart_category_medias` WHERE `virtuemart_category_id` = "91" 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/category/view.html.php:109

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 0.07 ms After last query: 0.05 ms

    SELECT `category_child_id`
    			
      FROM `new_virtuemart_category_categories`
    			
      WHERE `category_parent_id` = 91

    Explain

    EXPLAIN not possible on query: SELECT `category_child_id` FROM `new_virtuemart_category_categories` WHERE `category_parent_id` = 91

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/administrator/components/com_virtuemart/models/category.php:667

    JROOT/administrator/components/com_virtuemart/models/category.php:84

    JROOT/components/com_virtuemart/views/category/view.html.php:109

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 0.08 ms After last query: 0.04 ms

    SELECT count(new_virtuemart_products.virtuemart_product_id) AS total
    			
      FROM `new_virtuemart_products`, `new_virtuemart_product_categories`
    			
      WHERE `new_virtuemart_products`.`virtuemart_vendor_id` = "1"
    			
      AND `new_virtuemart_product_categories`.`virtuemart_category_id` = 91
    			
      AND `new_virtuemart_products`.`virtuemart_product_id` = `new_virtuemart_product_categories`.`virtuemart_product_id`
    			
      AND `new_virtuemart_products`.`published` = "1"

    Explain

    EXPLAIN not possible on query: SELECT count(new_virtuemart_products.virtuemart_product_id) AS total FROM `new_virtuemart_products`, `new_virtuemart_product_categories` WHERE `new_virtuemart_products`.`virtuemart_vendor_id` = "1" AND `new_virtuemart_product_categories`.`virtuemart_category_id` = 91 AND `new_virtuemart_products`.`virtuemart_product_id` = `new_virtuemart_product_categories`.`virtuemart_product_id` AND `new_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/category/view.html.php:109

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 0.07 ms After last query: 0.04 ms

    SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
    				
      FROM  new_virtuemart_category_categories AS `xref`
    				
      WHERE `xref`.`category_child_id`= 91

    Explain

    EXPLAIN not possible on query: SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent` FROM new_virtuemart_category_categories AS `xref` WHERE `xref`.`category_child_id`= 91

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/administrator/components/com_virtuemart/models/category.php:761

    JROOT/administrator/components/com_virtuemart/models/category.php:696

    JROOT/administrator/components/com_virtuemart/models/category.php:94

    JROOT/components/com_virtuemart/views/category/view.html.php:109

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 0.06 ms After last query: 0.04 ms

    SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
    				
      FROM  new_virtuemart_category_categories AS `xref`
    				
      WHERE `xref`.`category_child_id`= 3

    Explain

    EXPLAIN not possible on query: SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent` FROM new_virtuemart_category_categories AS `xref` WHERE `xref`.`category_child_id`= 3

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/administrator/components/com_virtuemart/models/category.php:761

    JROOT/administrator/components/com_virtuemart/models/category.php:768

    JROOT/administrator/components/com_virtuemart/models/category.php:696

    JROOT/administrator/components/com_virtuemart/models/category.php:94

    JROOT/components/com_virtuemart/views/category/view.html.php:109

    JROOT/components/com_virtuemart/controllers/category.php:54

    JROOT/libraries/legacy/controller/legacy.php:728

    JROOT/components/com_virtuemart/virtuemart.php:124

    JROOT/libraries/cms/component/helper.php:392

    JROOT/libraries/cms/component/helper.php:372

    JROOT/libraries/cms/application/site.php:191

    JROOT/libraries/cms/application/site.php:230

    JROOT/libraries/cms/application/cms.php:252

    JROOT/index.php:52

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 0.06 ms After last query: 0.04 ms