{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732439922,
                "last": 1732439922,
                "now": 1732439922
            },
            "client": {
                "forwarded": "3.145.57.5"
            },
            "token": "1czglechFG3EyPW1jOM6zhfhkhgmZaOP"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 101,
        "vmlastvisitedcategoryid": 0,
        "vmlastvisitedmanuid": 0,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}"
    }
}

Time

Memory

52 Queries Logged 109.35 ms

1. Query Time: 1.56 ms Query memory: 0.007 MB Memory before query: 2.474 MB Rows returned: 0

   SELECT `data`
   
     FROM `cb4d7_session`
   
     WHERE `session_id` = '790b07a573dca630d08bd95f74eb2d07'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cb4d7_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.11 ms
   Waiting for query cache lock	0.04 ms
   init	0.03 ms
   checking query cache for query	0.05 ms
   checking permissions	0.03 ms
   Opening tables	0.40 ms
   init	0.06 ms
   System lock	0.04 ms
   Waiting for query cache lock	0.04 ms
   System lock	0.05 ms
   optimizing	0.04 ms
   statistics	0.06 ms
   executing	0.05 ms
   end	0.04 ms
   query end	0.04 ms
   closing tables	0.04 ms
   freeing items	0.04 ms
   Waiting for query cache lock	0.04 ms
   freeing items	0.10 ms
   Waiting for query cache lock	0.04 ms
   freeing items	0.05 ms
   storing result in query cache	0.04 ms
   cleaning up	0.04 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 1.14 ms After last query: 2.80 ms Query memory: 0.004 MB Memory before query: 2.600 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `cb4d7_session`
   
     WHERE `session_id` = '790b07a573dca630d08bd95f74eb2d07' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cb4d7_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profile

   Status	Duration
   starting	0.05 ms
   Waiting for query cache lock	0.04 ms
   init	0.04 ms
   checking query cache for query	0.06 ms
   checking permissions	0.04 ms
   Opening tables	0.06 ms
   init	0.05 ms
   System lock	0.05 ms
   Waiting for query cache lock	0.06 ms
   System lock	0.06 ms
   optimizing	0.04 ms
   statistics	0.07 ms
   executing	0.05 ms
   end	0.05 ms
   query end	0.04 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.04 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.03 ms
   storing result in query cache	0.04 ms
   cleaning up	0.05 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 1.78 ms After last query: 0.19 ms Query memory: 0.003 MB Memory before query: 2.605 MB

   INSERT INTO `cb4d7_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('790b07a573dca630d08bd95f74eb2d07', 0, 1, '1732439922', 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `cb4d7_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('790b07a573dca630d08bd95f74eb2d07', 0, 1, '1732439922', 0, '')

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.04 ms
   Opening tables	0.04 ms
   init	0.05 ms
   System lock	0.03 ms
   update	0.13 ms
   Waiting for query cache lock	0.05 ms
   update	0.04 ms
   end	0.03 ms
   query end	0.06 ms
   closing tables	0.03 ms
   freeing items	0.04 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 1.95 ms After last query: 3.46 ms Query memory: 0.004 MB Memory before query: 2.780 MB Rows returned: 34

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cb4d7_extensions	ref	extension	extension	82	const	34	100.00	Using index condition

   Profile

   Status	Duration
   starting	0.04 ms
   Waiting for query cache lock	0.04 ms
   init	0.04 ms
   checking query cache for query	0.06 ms
   checking permissions	0.04 ms
   Opening tables	0.29 ms
   init	0.05 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.03 ms
   System lock	0.06 ms
   optimizing	0.05 ms
   statistics	0.10 ms
   preparing	0.07 ms
   executing	0.04 ms
   Sending data	0.23 ms
   end	0.05 ms
   query end	0.04 ms
   closing tables	0.05 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.04 ms
   freeing items	0.16 ms
   Waiting for query cache lock	0.05 ms
   freeing items	0.04 ms
   storing result in query cache	0.07 ms
   cleaning up	0.04 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 2.07 ms After last query: 3.12 ms Query memory: 0.005 MB Memory before query: 2.981 MB Rows returned: 2

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

   Profile

   Status	Duration
   starting	0.05 ms
   Waiting for query cache lock	0.04 ms
   init	0.04 ms
   checking query cache for query	0.07 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   Opening tables	0.45 ms
   init	0.05 ms
   System lock	0.07 ms
   Waiting for query cache lock	0.04 ms
   System lock	0.04 ms
   optimizing	0.04 ms
   statistics	0.12 ms
   preparing	0.08 ms
   executing	0.10 ms
   Sending data	0.07 ms
   end	0.03 ms
   query end	0.06 ms
   closing tables	0.05 ms
   freeing items	0.17 ms
   Waiting for query cache lock	0.10 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.08 ms
   freeing items	0.03 ms
   storing result in query cache	0.03 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 2.58 ms After last query: 0.79 ms Query memory: 0.005 MB Memory before query: 3.026 MB Rows returned: 5

   SELECT id, rules
   
     FROM `cb4d7_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cb4d7_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

   Profile

   Status	Duration
   starting	0.06 ms
   Waiting for query cache lock	0.06 ms
   init	0.04 ms
   checking query cache for query	0.05 ms
   checking permissions	0.11 ms
   Opening tables	0.25 ms
   init	0.04 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.05 ms
   System lock	0.07 ms
   optimizing	0.04 ms
   statistics	0.05 ms
   preparing	0.21 ms
   executing	0.16 ms
   Sending data	0.06 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.08 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.03 ms
   storing result in query cache	0.03 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 1.84 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 3.035 MB Rows returned: 46

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cb4d7_extensions	ref	extension	extension	82	const	77	100.00	Using index condition; Using where; Using filesort

   Profile

   Status	Duration
   starting	0.05 ms
   Waiting for query cache lock	0.04 ms
   init	0.03 ms
   checking query cache for query	0.06 ms
   checking permissions	0.04 ms
   Opening tables	0.06 ms
   init	0.06 ms
   System lock	0.05 ms
   Waiting for query cache lock	0.03 ms
   System lock	0.06 ms
   optimizing	0.05 ms
   statistics	0.08 ms
   preparing	0.06 ms
   Sorting result	0.04 ms
   executing	0.04 ms
   Sending data	0.03 ms
   Creating sort index	0.44 ms
   end	0.05 ms
   query end	0.04 ms
   closing tables	0.05 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.06 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.03 ms
   storing result in query cache	0.03 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 2.37 ms After last query: 13.77 ms Query memory: 0.007 MB Memory before query: 4.168 MB Rows returned: 5

   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 cb4d7_menu AS m
   
     LEFT JOIN cb4d7_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

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	5	100.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	user68643_asia.m.component_id	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.07 ms
   Waiting for query cache lock	0.03 ms
   init	0.03 ms
   checking query cache for query	0.07 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   Opening tables	0.46 ms
   init	0.07 ms
   System lock	0.05 ms
   Waiting for query cache lock	0.03 ms
   System lock	0.05 ms
   optimizing	0.04 ms
   statistics	0.07 ms
   preparing	0.05 ms
   Sorting result	0.03 ms
   executing	0.03 ms
   Sending data	0.03 ms
   Creating sort index	0.13 ms
   end	0.03 ms
   query end	0.05 ms
   closing tables	0.05 ms
   freeing items	0.04 ms
   Waiting for query cache lock	0.04 ms
   freeing items	0.07 ms
   Waiting for query cache lock	0.04 ms
   freeing items	0.04 ms
   storing result in query cache	0.05 ms
   cleaning up	0.04 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 1.14 ms After last query: 7.53 ms Query memory: 0.006 MB Memory before query: 4.562 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cb4d7_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

   Profile

   Status	Duration
   starting	0.04 ms
   Waiting for query cache lock	0.03 ms
   init	0.03 ms
   checking query cache for query	0.05 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   init	0.04 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.03 ms
   System lock	0.05 ms
   optimizing	0.03 ms
   statistics	0.09 ms
   preparing	0.04 ms
   executing	0.03 ms
   Sending data	0.06 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.05 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.04 ms
   freeing items	0.05 ms
   storing result in query cache	0.04 ms
   cleaning up	0.04 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
   11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.88 ms After last query: 0.24 ms Query memory: 0.005 MB Memory before query: 4.553 MB

    UPDATE `cb4d7_extensions`
    
      SET `params` = '{\"mediaversion\":\"cf148909089642d3516df2137f3da46a\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.05 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.09 ms
    updating	0.10 ms
    end	0.03 ms
    Waiting for query cache lock	0.03 ms
    end	0.08 ms
    query end	0.12 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 1.48 ms After last query: 2.21 ms Query memory: 0.003 MB Memory before query: 4.695 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.05 ms
    Opening tables	0.38 ms
    init	0.05 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.05 ms
    Sorting result	0.04 ms
    executing	0.04 ms
    Sending data	0.05 ms
    Creating sort index	0.09 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.31 ms After last query: 0.25 ms Query memory: 0.003 MB Memory before query: 4.767 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM cb4d7_template_styles as s
    
      LEFT JOIN cb4d7_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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	user68643_asia.s.template,const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.25 ms
    init	0.05 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.08 ms
    preparing	0.05 ms
    executing	0.03 ms
    Sending data	0.09 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 1.54 ms After last query: 12.60 ms Query memory: 0.006 MB Memory before query: 5.731 MB Rows returned: 1

    SHOW TABLES LIKE "cb4d7_virtuemart_configs"

    Explain

    EXPLAIN not possible on query: SHOW TABLES LIKE "cb4d7_virtuemart_configs"

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.07 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.04 ms
    executing	0.03 ms
    checking permissions	0.62 ms
    Sending data	0.04 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.03 ms
    removing tmp table	0.03 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:699
    9	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:529
    8	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:945
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 2.17 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 5.736 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_virtuemart_configs	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	1.08 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.06 ms
    preparing	0.04 ms
    executing	0.04 ms
    Sending data	0.04 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    8	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:993
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 2.11 ms After last query: 5.11 ms Query memory: 0.009 MB Memory before query: 6.086 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `cb4d7_assets`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cb4d7_assets`

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    Opening tables	0.19 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.04 ms
    executing	0.05 ms
    Opening tables	0.56 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    Sending data	0.06 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    removing tmp table	0.07 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    15	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    14	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    13	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1331
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1015
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 1.05 ms After last query: 0.73 ms Query memory: 0.007 MB Memory before query: 6.122 MB Rows returned: 1

    SELECT *
    
      FROM cb4d7_assets
    
      WHERE `id` = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_assets	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.06 ms
    optimizing	0.04 ms
    statistics	0.06 ms
    preparing	0.04 ms
    executing	0.04 ms
    Sending data	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.04 ms
    storing result in query cache	0.05 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    13	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1331
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1015
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 1.14 ms After last query: 0.12 ms Query memory: 0.007 MB Memory before query: 6.129 MB Rows returned: 1
    Duplicate queries: #19

    SELECT a.rules
    
      FROM cb4d7_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.05 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.06 ms
    executing	0.04 ms
    Sending data	0.12 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.06 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.03 ms
    storing result in query cache	0.04 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1331
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1015
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.07 ms After last query: 0.70 ms Query memory: 0.007 MB Memory before query: 6.154 MB Rows returned: 1

    SELECT id
    
      FROM cb4d7_assets
    
      WHERE parent_id = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_assets	ref	idx_parent_id	idx_parent_id	4	const	1	100.00	Using index

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.04 ms
    executing	0.03 ms
    Sending data	0.06 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.05 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.05 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.06 ms
    freeing items	0.04 ms
    storing result in query cache	0.05 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
    12	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
    11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1331
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1015
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.48 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 6.161 MB Rows returned: 1
    Duplicate queries: #17

    SELECT a.rules
    
      FROM cb4d7_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    checking query cache for query	0.03 ms
    checking privileges on cached	0.03 ms
    checking permissions	0.03 ms
    sending cached result to clien	0.07 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    12	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
    11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1331
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1015
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 1.22 ms After last query: 0.22 ms Query memory: 0.007 MB Memory before query: 6.175 MB Rows returned: 34

    SELECT element
    
      FROM cb4d7_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_extensions	ref	extension	extension	82	const	34	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.05 ms
    init	0.04 ms
    checking query cache for query	0.07 ms
    checking permissions	0.04 ms
    Opening tables	0.05 ms
    init	0.06 ms
    System lock	0.05 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.06 ms
    preparing	0.05 ms
    executing	0.03 ms
    Sending data	0.16 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.04 ms
    storing result in query cache	0.09 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    13	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    12	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1331
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1015
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 2.15 ms After last query: 0.18 ms Query memory: 0.007 MB Memory before query: 6.188 MB Rows returned: 34

    SELECT a.name, a.rules
    
      FROM cb4d7_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtueaffiliate','com_virtuemart','com_virtuemart_allinone','com_wrapper') OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	64	54.69	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    checking query cache for query	0.07 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.09 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    statistics	0.51 ms
    preparing	0.07 ms
    executing	0.03 ms
    Sending data	0.31 ms
    end	0.06 ms
    query end	0.06 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.07 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    13	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    12	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1331
    9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1015
    7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 2.28 ms After last query: 43.18 ms Query memory: 0.010 MB Memory before query: 8.017 MB Rows returned: 4

    SELECT * 
      FROM `cb4d7_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and client_id=0 
      and published=1 
      and (language="*" or language = "en-GB" ) 
      AND ( access="1" OR access="5" )  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	6	100.00	Using index condition; Using where; Using filesort

    Profile

    Status	Duration
    starting	0.12 ms
    Waiting for query cache lock	0.09 ms
    init	0.04 ms
    checking query cache for query	0.12 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    init	0.10 ms
    System lock	0.07 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.05 ms
    optimizing	0.05 ms
    statistics	0.11 ms
    preparing	0.06 ms
    Sorting result	0.03 ms
    executing	0.03 ms
    Sending data	0.04 ms
    Creating sort index	0.26 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.11 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1204
    20	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:802
    19	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:830
    18	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    17	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    13	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    11	JRoute::_()	JROOT/components/com_virtuemart/views/category/view.html.php:520
    10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:129
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 2.93 ms After last query: 17.11 ms Query memory: 0.006 MB Memory before query: 8.696 MB Rows returned: 0

    SELECT `category_child_id`
    			
      FROM `cb4d7_virtuemart_category_categories`
    			
      WHERE `category_parent_id` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.08 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.04 ms
    Opening tables	0.98 ms
    init	0.07 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    statistics	0.04 ms
    executing	0.03 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.10 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:710
    11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:94
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:173
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 3.01 ms After last query: 1.44 ms Query memory: 0.006 MB Memory before query: 8.861 MB Rows returned: 0

    SELECT c.* 
      FROM cb4d7_virtuemart_customs  as c  
      WHERE searchable="1" 
      and (field_type="S" or field_type="P") 
      GROUP BY c.virtuemart_custom_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	PRIMARY,field_type,searchable	searchable	1	const	1	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.38 ms
    init	0.06 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.07 ms
    Sorting result	0.04 ms
    executing	0.04 ms
    Sending data	0.05 ms
    Creating sort index	0.07 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/views/category/view.html.php:548
    10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:213
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 1.65 ms After last query: 3.53 ms Query memory: 0.008 MB Memory before query: 9.115 MB Rows returned: 1

    SELECT * 
      FROM `cb4d7_virtuemart_shoppergroups` 
      WHERE `default` = "2" 
      AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
      AND `published`="1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.56 ms
    init	0.05 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.07 ms
    preparing	0.05 ms
    executing	0.03 ms
    Sending data	0.06 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.06 ms
    freeing items	0.04 ms
    storing result in query cache	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:430
    11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1690
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 3.09 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 9.145 MB Rows returned: 1

    SELECT `cb4d7_virtuemart_shoppergroups`.*  
      FROM `cb4d7_virtuemart_shoppergroups`  
      WHERE `cb4d7_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.03 ms
    statistics	0.05 ms
    preparing	0.04 ms
    executing	0.03 ms
    Sending data	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1023
    18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:910
    17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:430
    11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1690
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 6.39 ms After last query: 13.59 ms Query memory: 0.007 MB Memory before query: 9.684 MB Rows returned: 0

    SELECT  p.`virtuemart_product_id` 
      FROM `cb4d7_virtuemart_products` as p  
     
      INNER JOIN `cb4d7_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
     
      LEFT JOIN `cb4d7_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND p.`product_special`="1"  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
    
      ORDER BY RAND() 
      LIMIT 0, 3

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.12 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	2.13 ms
    init	0.07 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.07 ms
    executing	0.06 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1690
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 3.12 ms After last query: 1.87 ms Query memory: 0.007 MB Memory before query: 9.786 MB Rows returned: 0

    SELECT  p.`virtuemart_product_id` 
      FROM `cb4d7_virtuemart_products` as p  
     
      INNER JOIN `cb4d7_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
     
      LEFT JOIN `cb4d7_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND p.`product_discontinued`="1"  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
    
      ORDER BY RAND() 
      LIMIT 0, 3

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.10 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.03 ms
    optimizing	0.04 ms
    statistics	0.06 ms
    executing	0.03 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1690
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 1.33 ms After last query: 0.17 ms Query memory: 0.007 MB Memory before query: 9.794 MB Rows returned: 0

    SELECT  p.`virtuemart_product_id` 
      FROM `cb4d7_virtuemart_products` as p  
     
      INNER JOIN `cb4d7_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
     
      LEFT JOIN `cb4d7_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
    
      ORDER BY p.`created_on` DESC, `virtuemart_product_id` DESC 
      LIMIT 0, 3

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.13 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    init	0.06 ms
    System lock	0.05 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    statistics	0.08 ms
    executing	0.05 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.11 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1690
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 1.32 ms After last query: 0.15 ms Query memory: 0.007 MB Memory before query: 9.801 MB Rows returned: 0

    SELECT  p.`virtuemart_product_id` 
      FROM `cb4d7_virtuemart_products` as p  
     
      INNER JOIN `cb4d7_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
     
      LEFT JOIN `cb4d7_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND pp.`product_price`>"0.001"  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
     
      ORDER BY p.`product_sales` DESC, `virtuemart_product_id` DESC 
      LIMIT 0, 3

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.04 ms
    init	0.04 ms
    checking query cache for query	0.12 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.07 ms
    statistics	0.08 ms
    executing	0.05 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1690
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 1.29 ms After last query: 0.26 ms Query memory: 0.006 MB Memory before query: 9.809 MB Rows returned: 0
    Duplicate queries: #33

    SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
      FROM `cb4d7_virtuemart_products` as p  
     
      INNER JOIN `cb4d7_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
     
      LEFT JOIN `cb4d7_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
     
      group by p.`virtuemart_product_id` 
     
      ORDER BY `pc`.`ordering` ASC, `product_name` ASC 
      LIMIT 0, 24

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    checking query cache for query	0.13 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    init	0.09 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.06 ms
    optimizing	0.07 ms
    statistics	0.09 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:255
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.64 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 9.815 MB Rows returned: 1

    SELECT FOUND_ROWS()

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	No tables used

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    checking query cache for query	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.03 ms
    optimizing	0.03 ms
    executing	0.05 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:856
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:255
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.55 ms After last query: 0.05 ms Query memory: 0.007 MB Memory before query: 9.829 MB Rows returned: 0
    Duplicate queries: #31

    SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
      FROM `cb4d7_virtuemart_products` as p  
     
      INNER JOIN `cb4d7_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
     
      LEFT JOIN `cb4d7_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
     
      group by p.`virtuemart_product_id` 
     
      ORDER BY `pc`.`ordering` ASC, `product_name` ASC 
      LIMIT 0, 24

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    checking query cache for query	0.04 ms
    checking privileges on cached	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    sending cached result to clien	0.05 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:869
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:255
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 3.14 ms After last query: 10.23 ms Query memory: 0.007 MB Memory before query: 9.994 MB Rows returned: 0

    SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id` 
      FROM `cb4d7_virtuemart_manufacturers_en_gb` as l 
      INNER JOIN `cb4d7_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`) 
      INNER JOIN `cb4d7_virtuemart_products` as p 
      ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`  
      WHERE p.`published` =1 
      ORDER BY `mf_name`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.06 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	1.58 ms
    init	0.09 ms
    System lock	0.05 ms
    Waiting for query cache lock	0.55 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    statistics	0.05 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.05 ms
    freeing items	0.04 ms
    storing result in query cache	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:238
    13	VirtueMartModelManufacturer::getManufacturersOfProductsInCategory()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/product.php:2608
    10	VirtueMartModelProduct->getOrderByList()	JROOT/components/com_virtuemart/views/category/view.html.php:257
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 2.22 ms After last query: 1.84 ms Query memory: 0.007 MB Memory before query: 10.037 MB Rows returned: 0

    SELECT *  
      FROM `cb4d7_virtuemart_currencies` AS c
    			
      LEFT JOIN `cb4d7_virtuemart_vendors` AS v 
      ON  c.virtuemart_currency_id = v.vendor_currency
    			
      WHERE v.virtuemart_vendor_id = "1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	1.10 ms
    init	0.11 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.05 ms
    executing	0.06 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.03 ms
    storing result in query cache	0.04 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
    12	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    11	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:265
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 2.11 ms After last query: 7.38 ms Query memory: 0.007 MB Memory before query: 10.299 MB Rows returned: 0

    SELECT l.*
    					
      FROM `cb4d7_virtuemart_categories_en_gb` as l
    					
      INNER JOIN `cb4d7_virtuemart_categories` as c 
      ON l.`virtuemart_category_id` = c.`virtuemart_category_id`  
      LEFT JOIN `cb4d7_virtuemart_category_categories` as cx 
      on c.`virtuemart_category_id` = cx.`category_child_id`  
      WHERE cx.`category_parent_id` = 0  
      AND c.`published` = 1  
      ORDER BY c.ordering,category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.95 ms
    init	0.06 ms
    System lock	0.05 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.06 ms
    optimizing	0.06 ms
    statistics	0.08 ms
    executing	0.06 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.04 ms
    storing result in query cache	0.04 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:244
    13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:168
    10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/category/view.html.php:320
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 2.00 ms After last query: 1.99 ms Query memory: 0.006 MB Memory before query: 10.430 MB Rows returned: 0

    SELECT `cb4d7_virtuemart_vendors`.* ,`cb4d7_virtuemart_vendors_en_gb`.*  
      FROM `cb4d7_virtuemart_vendors` 
      INNER JOIN `cb4d7_virtuemart_vendors_en_gb` using (`virtuemart_vendor_id`) 
      WHERE `cb4d7_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.39 ms
    init	0.07 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.07 ms
    executing	0.06 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.21 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.03 ms
    storing result in query cache	0.04 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1023
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:86
    10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:379
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 2.44 ms After last query: 0.93 ms Query memory: 0.006 MB Memory before query: 10.498 MB Rows returned: 0

    SELECT `virtuemart_media_id` 
      FROM `cb4d7_virtuemart_vendor_medias` 
      WHERE `virtuemart_vendor_id` = "1" 
      ORDER BY `ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.34 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    executing	0.21 ms
    end	0.05 ms
    query end	0.03 ms
    closing tables	0.05 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    storing result in query cache	0.05 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:97
    10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:379
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 5.71 ms After last query: 12.27 ms Query memory: 0.007 MB Memory before query: 11.136 MB Rows returned: 9

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cb4d7_modules AS m
    
      LEFT JOIN cb4d7_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN cb4d7_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-11-24 09:18:42') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-24 09:18:42') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	11	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	user68643_asia.m.id	1	100.00	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	user68643_asia.m.module,const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.09 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.54 ms
    init	0.07 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.05 ms
    statistics	0.10 ms
    preparing	0.06 ms
    Sorting result	0.03 ms
    executing	0.03 ms
    Sending data	0.03 ms
    Creating sort index	0.30 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    storing result in query cache	0.05 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/vmbeez3/index.php:16
    7	require JROOT/templates/vmbeez3/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 4.83 ms After last query: 8.57 ms Query memory: 0.012 MB Memory before query: 11.524 MB Rows returned: 31

    SHOW FULL COLUMNS  
      FROM `cb4d7_virtuemart_userfields`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cb4d7_virtuemart_userfields`

    Profile

    Status	Duration
    starting	0.13 ms
    checking permissions	0.10 ms
    checking permissions	0.07 ms
    Opening tables	0.17 ms
    init	0.06 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.05 ms
    Opening tables	1.32 ms
    checking permissions	0.08 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    checking permissions	0.10 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.08 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.14 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.08 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    Sending data	0.09 ms
    end	0.06 ms
    query end	0.06 ms
    closing tables	0.03 ms
    removing tmp table	0.08 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:660
    25	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
    24	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:217
    23	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:430
    22	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:392
    21	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:598
    20	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
    19	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:550
    18	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:251
    17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 3.34 ms After last query: 0.24 ms Query memory: 0.010 MB Memory before query: 11.574 MB Rows returned: 21

    SELECT * 
      FROM `cb4d7_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `account`=1 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type') = 0  
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_virtuemart_userfields	ref	published,account	account	1	const	22	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.04 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.10 ms
    preparing	0.19 ms
    Sorting result	0.05 ms
    executing	0.03 ms
    Sending data	0.04 ms
    Creating sort index	0.28 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.03 ms
    storing result in query cache	0.06 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
    20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
    19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:493
    18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
    17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 1.92 ms After last query: 0.31 ms Query memory: 0.010 MB Memory before query: 11.667 MB Rows returned: 2

    SELECT `fieldtitle`, `fieldvalue` 
      FROM `cb4d7_virtuemart_userfield_values` 
      WHERE `virtuemart_userfield_id` = 23 
      ORDER BY `ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_virtuemart_userfield_values	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.04 ms
    init	0.04 ms
    checking query cache for query	0.06 ms
    checking permissions	0.05 ms
    Opening tables	0.63 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.07 ms
    Sorting result	0.04 ms
    executing	0.11 ms
    Sending data	0.05 ms
    Creating sort index	0.11 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
    19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1020
    18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
    17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 2.95 ms After last query: 0.82 ms Query memory: 0.010 MB Memory before query: 11.718 MB Rows returned: 245

    SELECT * 
      FROM `cb4d7_virtuemart_countries`
     
      WHERE `published` = 1
    
     
      ORDER BY country_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_virtuemart_countries	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	245	99.18	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.04 ms
    init	0.04 ms
    checking query cache for query	0.06 ms
    checking permissions	0.04 ms
    Opening tables	0.52 ms
    init	0.06 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.04 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    preparing	0.04 ms
    Sorting result	0.04 ms
    executing	0.03 ms
    Sending data	0.04 ms
    Creating sort index	0.72 ms
    Waiting for query cache lock	0.05 ms
    Creating sort index	0.28 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.04 ms
    storing result in query cache	0.04 ms
    cleaning up	0.14 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
    21	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
    20	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
    19	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:840
    18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
    17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 4.93 ms After last query: 3.06 ms Query memory: 0.010 MB Memory before query: 12.218 MB Rows returned: 14

    SELECT * 
      FROM `cb4d7_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `shipment`=1 
      AND published = 1 
      AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
      ORDER BY ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cb4d7_virtuemart_userfields	ref	published,shipment	shipment	1	const	14	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.07 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.05 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.08 ms
    preparing	0.06 ms
    Sorting result	0.04 ms
    executing	0.04 ms
    Sending data	0.05 ms
    Creating sort index	0.18 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    storing result in query cache	0.05 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
    20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
    19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:499
    18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
    17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
    16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 2.14 ms After last query: 2.30 ms Query memory: 0.009 MB Memory before query: 12.366 MB Rows returned: 0

    SELECT c.* 
      FROM cb4d7_virtuemart_calcs as c 
      LEFT JOIN cb4d7_virtuemart_calc_shoppergroups as cs 
      ON cs.virtuemart_calc_id=c.virtuemart_calc_id 
      WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-11-24 09:18:42" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-11-24 09:18:42" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	1.06 ms
    init	0.08 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.06 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.17 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184
    16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
    15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 1.06 ms After last query: 0.12 ms Query memory: 0.008 MB Memory before query: 12.376 MB Rows returned: 0

    SELECT * 
      FROM cb4d7_virtuemart_calcs  
      LEFT JOIN cb4d7_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="DBTaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-11-24 09:18:42" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-11-24 09:18:42" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.05 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.04 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:726
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1525
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 1.06 ms After last query: 0.07 ms Query memory: 0.008 MB Memory before query: 12.385 MB Rows returned: 0

    SELECT * 
      FROM cb4d7_virtuemart_calcs  
      LEFT JOIN cb4d7_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="TaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-11-24 09:18:42" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-11-24 09:18:42" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.05 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:727
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1525
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 1.11 ms After last query: 0.07 ms Query memory: 0.008 MB Memory before query: 12.394 MB Rows returned: 0

    SELECT * 
      FROM cb4d7_virtuemart_calcs  
      LEFT JOIN cb4d7_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
      WHERE
                    `calc_kind`="DATaxBill"
                    
      AND `published`="1"
                    
      AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
    				
      AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-11-24 09:18:42" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-11-24 09:18:42" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.05 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
    15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:728
    14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1525
    13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1624
    12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1748
    11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
    10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 2.42 ms After last query: 35.65 ms Query memory: 0.007 MB Memory before query: 13.390 MB Rows returned: 0

    SELECT  p.`virtuemart_product_id` 
      FROM `cb4d7_virtuemart_products` as p  
     
      INNER JOIN `cb4d7_virtuemart_products_en_gb` as l 
      ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
     
      LEFT JOIN `cb4d7_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `cb4d7_virtuemart_product_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND p.`product_special`="1"  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
    
      ORDER BY RAND() 
      LIMIT 0, 2

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.12 ms
    Waiting for query cache lock	0.04 ms
    init	0.03 ms
    checking query cache for query	0.12 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    init	0.08 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.10 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.06 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:740
    12	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1690
    11	VirtueMartModelProduct->getProductListing()	JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php:71
    10	include JROOT/modules/mod_virtuemart_product/mod_virtuemart_product.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 1.56 ms After last query: 2.60 ms Query memory: 0.007 MB Memory before query: 13.412 MB Rows returned: 0

    SELECT l.*
    					
      FROM `cb4d7_virtuemart_categories_en_gb` as l
    					
      INNER JOIN `cb4d7_virtuemart_categories` as c 
      ON l.`virtuemart_category_id` = c.`virtuemart_category_id`  
      LEFT JOIN `cb4d7_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 c.ordering,category_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.05 ms
    Waiting for query cache lock	0.05 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.07 ms
    executing	0.05 ms
    end	0.04 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.04 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:244
    14	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    12	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:168
    11	VirtueMartModelCategory->getChildCategoryList()	JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:40
    10	include JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 1.08 ms After last query: 7.28 ms Query memory: 0.006 MB Memory before query: 13.407 MB Rows returned: 0

    SELECT `vendor_accepted_currencies`, `vendor_currency` 
      FROM `cb4d7_virtuemart_vendors` 
      WHERE `virtuemart_vendor_id`=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    init	0.07 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.05 ms
    executing	0.10 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.03 ms
    storing result in query cache	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/models/currency.php:110
    11	VirtueMartModelCurrency->getVendorAcceptedCurrrenciesList()	JROOT/modules/mod_virtuemart_currencies/mod_virtuemart_currencies.php:45
    10	include JROOT/modules/mod_virtuemart_currencies/mod_virtuemart_currencies.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 2.69 ms After last query: 1.25 ms Query memory: 0.007 MB Memory before query: 13.427 MB Rows returned: 0

    SELECT  `m`.*, l.mf_name, l.mf_email, l.mf_desc, l.mf_url, l.slug,  mc.`mf_category_name`,mmex.virtuemart_media_id  
      FROM `cb4d7_virtuemart_manufacturers` as m 
      LEFT JOIN `cb4d7_virtuemart_manufacturers_en_gb` as l 
      ON l.`virtuemart_manufacturer_id` = m.`virtuemart_manufacturer_id`  
      LEFT JOIN `cb4d7_virtuemart_manufacturercategories_en_gb` AS mc 
      on  mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id` 
      LEFT JOIN `cb4d7_virtuemart_manufacturer_medias` as mmex 
      ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id` 
     
      WHERE  `m`.`published` = 1 
     
      GROUP BY `m`.`virtuemart_manufacturer_id` 
     
      ORDER BY mf_name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.03 ms
    init	0.03 ms
    checking query cache for query	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	1.57 ms
    init	0.06 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.03 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.07 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.04 ms
    freeing items	0.04 ms
    storing result in query cache	0.04 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
    12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:209
    11	VirtueMartModelManufacturer->getManufacturers()	JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php:30
    10	include JROOT/modules/mod_virtuemart_manufacturer/mod_virtuemart_manufacturer.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---