{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1773733352,
                "last": 1773733352,
                "now": 1773733352
            },
            "token": "oKDVp9xrAolzRwqYZE79HHrSdrikuxAJ"
        },
        "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": [
                "13"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_rsfirewall": {
            "geoip": ""
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 510,
        "vmlastvisitedcategoryid": 18,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":\"5\",\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":true,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":\"144\",\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false}",
        "vmlastvisitedproductids": [
            100
        ]
    }
}

Time

Memory

68 Queries Logged 47.04 ms

1. Query Time: 0.39 ms Query memory: 0.017 MB Memory before query: 0.914 MB Rows returned: 0

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = '1k3cj008o49i4hbnjdtbtpv342'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	766	const	1

   Profile

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   12	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   11	JSessionStorageDatabase->read()	Same as call in the line below.
   10	session_start()	JROOT/libraries/joomla/session/handler/native.php:79
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:628
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:755
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
   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: 0.32 ms After last query: 1.10 ms Query memory: 0.012 MB Memory before query: 0.976 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = '1k3cj008o49i4hbnjdtbtpv342' 
     LIMIT 0, 1

   Explain

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

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:781
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
   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: 9.00 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 0.988 MB

   INSERT INTO `jos_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('1k3cj008o49i4hbnjdtbtpv342', 0, '1773733352')

   Explain

   EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('1k3cj008o49i4hbnjdtbtpv342', 0, '1773733352')

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.01 ms
   Update	0.06 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	8.62 ms
   Writing to binlog	0.04 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:209
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:781
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:411
   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.70 ms After last query: 2.62 ms Query memory: 0.014 MB Memory before query: 1.120 MB Rows returned: 2

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	1.17 ms
   End of update loop	0.03 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
   9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
   8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	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:264
   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: 0.34 ms After last query: 0.22 ms Query memory: 0.013 MB Memory before query: 1.139 MB Rows returned: 6

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
   8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	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:264
   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: 0.39 ms After last query: 3.05 ms Query memory: 0.017 MB Memory before query: 1.341 MB Rows returned: 0

   SELECT `path`
   
     FROM jos_rsfirewall_ignored
   
     WHERE `type`='ignore_folder' OR `type`='ignore_file'

   Explain

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

   Profile

   Status	Duration
   Starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:52
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   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: 0.34 ms After last query: 0.13 ms Query memory: 0.017 MB Memory before query: 1.358 MB Rows returned: 0

   SELECT `file`
   
     FROM jos_rsfirewall_hashes
   
     WHERE `type`='protect'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	216	Using where

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.07 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:59
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   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: 0.35 ms After last query: 0.09 ms Query memory: 0.019 MB Memory before query: 1.372 MB Rows returned: 51

   SELECT *
   
     FROM jos_rsfirewall_configuration

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_rsfirewall_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	51

   Profile

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:67
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   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: 0.88 ms After last query: 3.77 ms Query memory: 0.024 MB Memory before query: 1.684 MB Rows returned: 10

   SHOW FULL COLUMNS 
     FROM `jos_rsfirewall_logs`

   Explain

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

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   closing tables	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.28 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Filling schema table	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   checking permissions	0.05 ms
   closing tables	0.01 ms
   checking permissions	0.01 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Removing tmp table	0.08 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
   14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
   13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
   12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:35
   11	RSFirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:305
   10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:22
   9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:56
   8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
   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.54 ms After last query: 4.27 ms Query memory: 0.013 MB Memory before query: 2.111 MB Rows returned: 1

    SELECT `enabled`
    
      FROM `jos_extensions`
    
      WHERE `element` = 'com_akeeba' 
      AND `type` = 'component'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
    7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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.03 ms After last query: 4.09 ms Query memory: 0.032 MB Memory before query: 2.486 MB Rows returned: 30

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM jos_menu AS m
    
      LEFT JOIN jos_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	128	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c30allboard.m.component_id	1	Using where

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.46 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    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:133
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:442
    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:196
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:538
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1104
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.58 ms After last query: 11.86 ms Query memory: 0.021 MB Memory before query: 3.015 MB Rows returned: 1

    SHOW TABLES LIKE "jos_virtuemart_configs"

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.24 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:722
    14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:563
    13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:774
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.32 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 3.047 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:814
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.41 ms After last query: 1.76 ms Query memory: 0.023 MB Memory before query: 3.162 MB Rows returned: 1

    SELECT a.rules
    
      FROM jos_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
    13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.80 ms After last query: 0.88 ms Query memory: 0.031 MB Memory before query: 3.254 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `jos_assets`

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.27 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.05 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.08 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    19	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:61
    18	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:305
    17	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:100
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
    13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.33 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 3.300 MB Rows returned: 1

    SELECT id
    
      FROM jos_assets
    
      WHERE parent_id = 0

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1216
    17	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:101
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
    13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.76 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 3.326 MB Rows returned: 1

    SELECT b.rules
    
      FROM jos_assets AS a
    
      LEFT JOIN jos_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.id = 1)
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Using filesort
    1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	1	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.22 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.08 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
    13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.87 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 3.355 MB Rows returned: 2

    SELECT b.rules
    
      FROM jos_assets AS a
    
      LEFT JOIN jos_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_virtuemart')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	Using temporary; Using filesort
    1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	272	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.03 ms
    Preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.30 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.08 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
    13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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.52 ms After last query: 1.65 ms Query memory: 0.018 MB Memory before query: 3.434 MB Rows returned: 1

    SELECT `id` 
      FROM `jos_menu` 
      WHERE `home`="1" 
      and (language="*" or language = "en-GB" ) 
      ORDER BY `language` DESC

    Explain

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

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.12 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:853
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.65 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 3.454 MB Rows returned: 14

    SELECT * 
      FROM `jos_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	Extra
    1	SIMPLE	jos_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	192	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.22 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1274
    13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:860
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.33 ms After last query: 0.50 ms Query memory: 0.019 MB Memory before query: 3.483 MB Rows returned: 1

    SELECT l.virtuemart_product_id  
      FROM `jos_virtuemart_products_en_gb` as l  
      WHERE l.slug = "sony-vaio-red"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l	const	slug	slug	578	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1209
    12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1159
    11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:704
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.26 ms After last query: 0.14 ms Query memory: 0.020 MB Memory before query: 3.502 MB Rows returned: 0

    SELECT l.virtuemart_category_id  
      FROM `jos_virtuemart_categories_en_gb` as l  
      WHERE l.slug = ""

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1209
    13	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1042
    12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:1163
    11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:704
    10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1105
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.35 ms After last query: 0.24 ms Query memory: 0.016 MB Memory before query: 3.521 MB Rows returned: 0

    SELECT *
    
      FROM jos_rsfirewall_hashes
    
      WHERE `type`='protect' 
      AND `flag`!='C'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	216	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:947
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1114
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.25 ms After last query: 0.23 ms Query memory: 0.017 MB Memory before query: 3.540 MB Rows returned: 0

    SELECT *
    
      FROM jos_rsfirewall_snapshots
    
      WHERE `type`='protect'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:46
    10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:970
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1114
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.32 ms After last query: 0.15 ms Query memory: 0.017 MB Memory before query: 3.556 MB Rows returned: 0

    SELECT `ip`,`reason`
    
      FROM jos_rsfirewall_lists
    
      WHERE (`ip`='216.73.216.136' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='1' 
      AND `published`='1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_rsfirewall_lists	ref	published,type	type	1	const	1	Using where

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
    10	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:998
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1114
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 0.36 ms After last query: 0.16 ms Query memory: 0.017 MB Memory before query: 3.572 MB Rows returned: 0

    SELECT `ip`,`reason`
    
      FROM jos_rsfirewall_lists
    
      WHERE (`ip`='216.73.216.136' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='0' 
      AND `published`='1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_rsfirewall_lists	ALL	published,type	NO INDEX KEY COULD BE USED	NULL	NULL	74	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
    10	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1002
    9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1114
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:264
    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: 1.63 ms After last query: 1.51 ms Query memory: 0.012 MB Memory before query: 3.604 MB

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

    Explain

    EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"f7c13aa831e56d113b0b7ce6898fe0c4\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.06 ms
    Updating	0.06 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	1.22 ms
    Writing to binlog	0.02 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 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:737
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
    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:264
    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: 0.45 ms After last query: 10.12 ms Query memory: 0.027 MB Memory before query: 4.487 MB Rows returned: 1

    SELECT * 
      FROM `jos_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	Extra
    1	SIMPLE	jos_virtuemart_shoppergroups	ALL	virtuemart_vendor_id,shared,published	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1391
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.33 ms After last query: 0.28 ms Query memory: 0.031 MB Memory before query: 4.558 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028
    17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1391
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.48 ms After last query: 1.13 ms Query memory: 0.032 MB Memory before query: 4.652 MB Rows returned: 1

    SELECT `jos_virtuemart_products`.* ,`jos_virtuemart_products_en_gb`.*  
      FROM `jos_virtuemart_products` 
      INNER JOIN `jos_virtuemart_products_en_gb` using (`virtuemart_product_id`) 
      WHERE `jos_virtuemart_products`.`virtuemart_product_id` = "100"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_products	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	jos_virtuemart_products_en_gb	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1419
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.37 ms After last query: 0.71 ms Query memory: 0.019 MB Memory before query: 4.761 MB Rows returned: 1

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "100" 
      ORDER BY `ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	1	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1424
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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.28 ms After last query: 0.49 ms Query memory: 0.019 MB Memory before query: 4.824 MB Rows returned: 0

    SELECT `virtuemart_shoppergroup_id` 
      FROM `jos_virtuemart_product_shoppergroups` 
      WHERE `virtuemart_product_id` = "100"

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1427
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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.46 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 4.839 MB Rows returned: 1

    SELECT * 
      FROM `jos_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "100"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2026-03-17 07:42:32" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-03-17 07:42:32" ) ) 
      ORDER BY `product_price` DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1242
    12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1439
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.27 ms After last query: 0.52 ms Query memory: 0.019 MB Memory before query: 4.901 MB Rows returned: 0

    SELECT `virtuemart_manufacturer_id` 
      FROM `jos_virtuemart_product_manufacturers` 
      WHERE `virtuemart_product_id` = "100"

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
    12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1443
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.29 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 4.920 MB Rows returned: 1

    SELECT * 
      FROM `jos_virtuemart_product_categories`  
      WHERE `virtuemart_product_id` = 100

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	1

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
    14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1679
    13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1656
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.40 ms After last query: 0.24 ms Query memory: 0.028 MB Memory before query: 5.009 MB Rows returned: 1

    SELECT `jos_virtuemart_categories`.* ,`jos_virtuemart_categories_en_gb`.*  
      FROM `jos_virtuemart_categories` 
      INNER JOIN `jos_virtuemart_categories_en_gb` using (`virtuemart_category_id`) 
      WHERE `jos_virtuemart_categories`.`virtuemart_category_id` = "18"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_categories	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	jos_virtuemart_categories_en_gb	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1660
    12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
    11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.48 ms After last query: 0.92 ms Query memory: 0.025 MB Memory before query: 5.104 MB Rows returned: 0

    SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
    		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
    		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
    		
      FROM `jos_virtuemart_customs` AS c 
      LEFT JOIN `jos_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (100) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering` ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	c30allboard.field.virtuemart_custom_id	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
    11	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1105
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.51 ms After last query: 0.78 ms Query memory: 0.033 MB Memory before query: 5.202 MB Rows returned: 1

    SELECT *  
      FROM `jos_virtuemart_currencies` AS c
    			
      LEFT JOIN `jos_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	Extra
    1	SIMPLE	v	system	PRIMARY,vendor_currency	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:287
    16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
    15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.38 ms After last query: 0.93 ms Query memory: 0.030 MB Memory before query: 5.318 MB Rows returned: 1

    SELECT `jos_virtuemart_currencies`.*  
      FROM `jos_virtuemart_currencies`  
      WHERE `jos_virtuemart_currencies`.`virtuemart_currency_id` = "144"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_currencies	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028
    15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
    14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.91 ms After last query: 0.86 ms Query memory: 0.036 MB Memory before query: 5.471 MB Rows returned: 31

    SHOW FULL COLUMNS  
      FROM `jos_virtuemart_userfields`

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.26 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.10 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.09 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
    24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:683
    23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
    22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:209
    21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
    20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
    19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:600
    18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
    17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:552
    16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:252
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.62 ms After last query: 0.36 ms Query memory: 0.038 MB Memory before query: 5.569 MB Rows returned: 17

    SELECT * 
      FROM `jos_virtuemart_userfields` 
      WHERE 1 = 1 
      AND `account`="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	Extra
    1	SIMPLE	jos_virtuemart_userfields	ALL	published,account	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
    18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
    17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:487
    16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:263
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.39 ms After last query: 0.53 ms Query memory: 0.026 MB Memory before query: 5.712 MB Rows returned: 2

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
    17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1027
    16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:268
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.90 ms After last query: 0.88 ms Query memory: 0.057 MB Memory before query: 5.835 MB Rows returned: 246

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.50 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:856
    19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:111
    18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:144
    17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:836
    16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:268
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.63 ms After last query: 5.47 ms Query memory: 0.038 MB Memory before query: 6.600 MB Rows returned: 14

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_userfields	ALL	published,shipment	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.15 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
    18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
    17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:493
    16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:263
    15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
    14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.59 ms After last query: 3.73 ms Query memory: 0.027 MB Memory before query: 6.830 MB Rows returned: 1

    SELECT c.* 
      FROM jos_virtuemart_calcs as c  
      LEFT JOIN jos_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 <= "2026-03-17 07:42:32" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-03-17 07:42:32" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cs	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:171
    14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
    13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
    12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
    11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.28 ms After last query: 0.32 ms Query memory: 0.020 MB Memory before query: 6.874 MB Rows returned: 0

    SELECT `jos_virtuemart_ratings`.*  
      FROM `jos_virtuemart_ratings`  
      WHERE `jos_virtuemart_ratings`.`virtuemart_product_id` = "100"

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1143
    10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:74
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.36 ms After last query: 0.44 ms Query memory: 0.026 MB Memory before query: 6.971 MB Rows returned: 1

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "128"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_medias	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:437
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1192
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:140
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.36 ms After last query: 1.44 ms Query memory: 0.018 MB Memory before query: 7.152 MB Rows returned: 1

    SELECT `virtuemart_media_id` 
      FROM `jos_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "18" 
      ORDER BY `ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
    11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:92
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:198
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.32 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 7.172 MB Rows returned: 1

    SELECT `jos_virtuemart_medias`.*  
      FROM `jos_virtuemart_medias`  
      WHERE `jos_virtuemart_medias`.`virtuemart_media_id` = "56"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_medias	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:437
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1192
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:202
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.75 ms After last query: 4.51 ms Query memory: 0.018 MB Memory before query: 7.245 MB Rows returned: 1

    SELECT COLLATION_NAME 
      from information_schema.columns 
      where TABLE_SCHEMA = "c30allboard"
    				
      and TABLE_NAME = "jos_users"
    				
      and COLUMN_NAME = "name";

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	columns	ALL	NULL	TABLE_SCHEMA,TABLE_NAME	NULL	NULL	NULL	Using where; Open_frm_only; Scanned 0 databases

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.20 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.07 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.08 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/ratings.php:94
    11	VirtueMartModelRatings::getSelect()	JROOT/administrator/components/com_virtuemart/models/ratings.php:212
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:275
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 0.59 ms After last query: 0.11 ms Query memory: 0.018 MB Memory before query: 7.262 MB Rows returned: 1

    SELECT COLLATION_NAME 
      from information_schema.columns 
      where TABLE_SCHEMA = "c30allboard"
    				
      and TABLE_NAME = "jos_virtuemart_rating_reviews"
    				
      and COLUMN_NAME = "customer";

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	columns	ALL	NULL	TABLE_SCHEMA,TABLE_NAME	NULL	NULL	NULL	Using where; Open_frm_only; Scanned 0 databases

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.15 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.06 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.07 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/ratings.php:102
    11	VirtueMartModelRatings::getSelect()	JROOT/administrator/components/com_virtuemart/models/ratings.php:212
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:275
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    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: 1.58 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 7.282 MB Rows returned: 0

    SELECT  `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer   
      FROM `jos_virtuemart_rating_reviews` AS `pr`
    			
      INNER JOIN `jos_virtuemart_products_en_gb` AS `l` 
      ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`  
      LEFT JOIN `jos_virtuemart_rating_votes` AS `rv` 
      on
    			(`pr`.`virtuemart_rating_vote_id` IS NOT NULL 
      AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR
    			(`pr`.`virtuemart_rating_vote_id` IS NULL 
      AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` 
      and `rv`.`created_by`=`pr`.`created_by`) )
    			
      LEFT JOIN `jos_users` AS `u`	
      ON `pr`.`created_by` = `u`.`id` 
     
      WHERE  `pr`.`virtuemart_product_id` = "100" 
    
     
      ORDER BY created_on DESC 
      LIMIT 0, 3

    Explain

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

    Profile

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	1.07 ms
    Query end	0.03 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:856
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/ratings.php:213
    10	VirtueMartModelRatings->getReviews()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:275
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.28 ms After last query: 0.22 ms Query memory: 0.019 MB Memory before query: 7.297 MB Rows returned: 0

    SELECT * 
      FROM `jos_virtuemart_rating_votes` 
      WHERE `virtuemart_product_id` = "100" 
      AND `created_by` = "0"

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/ratings.php:346
    10	VirtueMartModelRatings->getVoteByProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:279
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 1.09 ms After last query: 21.26 ms Query memory: 0.029 MB Memory before query: 8.425 MB Rows returned: 1
    Duplicate queries: #58

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
      FROM jos_virtuemart_shipmentmethods as i 
     
      LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l 
      ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`shipment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s 
      ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
      WHERE i.`published` = "1" 
      AND j.`element` = "weight_countries"
    	    						
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
    	    						
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
      GROUP BY i.`virtuemart_shipmentmethod_id` 
      ORDER BY i.`ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	system	virtuemart_shipmentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
    1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition
    1	SIMPLE	i	ALL	shipment_jplugin_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	c30allboard.i.virtuemart_shipmentmethod_id	1

    Profile

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.30 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.07 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:522
    14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:418
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.45 ms After last query: 0.49 ms Query memory: 0.031 MB Memory before query: 8.483 MB Rows returned: 0

    SELECT * 
      FROM jos_virtuemart_calcs  
      LEFT JOIN jos_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 <= "2026-03-17 07:42:32" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-03-17 07:42:32" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	jos_virtuemart_calcs	ref|filter	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published|calc_kind	1|50	const	1 (50%)	Using where; Using rowid filter

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1359
    17	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:750
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.37 ms After last query: 0.08 ms Query memory: 0.031 MB Memory before query: 8.507 MB Rows returned: 0

    SELECT * 
      FROM jos_virtuemart_calcs  
      LEFT JOIN jos_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 <= "2026-03-17 07:42:32" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-03-17 07:42:32" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	jos_virtuemart_calcs	ref|filter	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published|calc_kind	1|50	const	1 (50%)	Using where; Using rowid filter

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1359
    17	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:751
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.34 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 8.531 MB Rows returned: 0

    SELECT * 
      FROM jos_virtuemart_calcs  
      LEFT JOIN jos_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 <= "2026-03-17 07:42:32" )
    				
      AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-03-17 07:42:32" )
     
      AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	jos_virtuemart_calcs	ref|filter	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published|calc_kind	1|50	const	1 (50%)	Using where; Using rowid filter

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
    18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1359
    17	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:752
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.88 ms After last query: 0.18 ms Query memory: 0.041 MB Memory before query: 8.565 MB Rows returned: 1
    Duplicate queries: #54

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
      FROM jos_virtuemart_shipmentmethods as i 
     
      LEFT JOIN `jos_virtuemart_shipmentmethods_en_gb` as l 
      ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`shipment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_virtuemart_shipmentmethod_shoppergroups` AS s 
      ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
      WHERE i.`published` = "1" 
      AND j.`element` = "weight_countries"
    	    						
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
    	    						
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
      GROUP BY i.`virtuemart_shipmentmethod_id` 
      ORDER BY i.`ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	system	virtuemart_shipmentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
    1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition
    1	SIMPLE	i	ALL	shipment_jplugin_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	c30allboard.i.virtuemart_shipmentmethod_id	1

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.28 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.07 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:522
    25	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:896
    24	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:206
    23	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:527
    22	plgVmShipmentWeight_countries->plgVmOnCheckAutomaticSelectedShipment()	Same as call in the line below.
    21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1490
    18	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1471
    17	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:932
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.34 ms After last query: 0.39 ms Query memory: 0.034 MB Memory before query: 8.606 MB Rows returned: 1
    Duplicate queries: #64

    SELECT vm.* 
      FROM `jos_virtuemart_shipmentmethods` AS vm,
    						jos_extensions AS j 
      WHERE vm.`virtuemart_shipmentmethod_id` = "5"
    						
      AND vm.shipment_jplugin_id = j.extension_id 
      AND vm.published = 1 
      AND j.element = "weight_countries"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vm	const	PRIMARY,shipment_jplugin_id	PRIMARY	4	const	1
    1	SIMPLE	j	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    24	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:291
    23	vmPlugin->selectedThisByMethodId()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:170
    22	vmPSPlugin->onSelectedCalculatePrice()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:512
    21	plgVmShipmentWeight_countries->plgVmOnSelectedCalculatePriceShipment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1475
    17	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:932
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.30 ms After last query: 0.28 ms Query memory: 0.037 MB Memory before query: 8.694 MB Rows returned: 1

    SELECT `jos_virtuemart_shipmentmethods`.* ,`jos_virtuemart_shipmentmethods_en_gb`.*  
      FROM `jos_virtuemart_shipmentmethods` 
      INNER JOIN `jos_virtuemart_shipmentmethods_en_gb` using (`virtuemart_shipmentmethod_id`) 
      WHERE `jos_virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` = "5"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_virtuemart_shipmentmethods	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	jos_virtuemart_shipmentmethods_en_gb	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    25	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
    24	VmTable->load()	JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:581
    23	vmPlugin->getVmPluginMethod()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:173
    22	vmPSPlugin->onSelectedCalculatePrice()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:512
    21	plgVmShipmentWeight_countries->plgVmOnSelectedCalculatePriceShipment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1475
    17	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:932
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 0.82 ms After last query: 0.44 ms Query memory: 0.041 MB Memory before query: 8.734 MB Rows returned: 0
    Duplicate queries: #65

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc 
      FROM jos_virtuemart_paymentmethods as i 
     
      LEFT JOIN `jos_virtuemart_paymentmethods_en_gb` as l 
      ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`payment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s 
      ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
      WHERE i.`published` = "1" 
      AND j.`element` = "paypal"
    	    						
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
    	    						
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
      GROUP BY i.`virtuemart_paymentmethod_id` 
      ORDER BY i.`ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition; Using temporary; Using filesort
    1	SIMPLE	i	ALL	payment_jplugin_id,virtuemart_vendor_id	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	c30allboard.i.virtuemart_paymentmethod_id	1
    1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	c30allboard.i.virtuemart_paymentmethod_id	1	Using where; Using index

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.25 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:522
    25	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:896
    24	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:206
    23	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmpayment/paypal/paypal.php:1564
    22	plgVmPaymentPaypal->plgVmOnCheckAutomaticSelectedPayment()	Same as call in the line below.
    21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1490
    18	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1512
    17	calculationHelper->calculatePaymentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:934
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.77 ms After last query: 0.17 ms Query memory: 0.041 MB Memory before query: 8.768 MB Rows returned: 0

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc 
      FROM jos_virtuemart_paymentmethods as i 
     
      LEFT JOIN `jos_virtuemart_paymentmethods_en_gb` as l 
      ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`payment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s 
      ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
      WHERE i.`published` = "1" 
      AND j.`element` = "standard"
    	    						
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
    	    						
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
      GROUP BY i.`virtuemart_paymentmethod_id` 
      ORDER BY i.`ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition; Using temporary; Using filesort
    1	SIMPLE	i	ALL	payment_jplugin_id,virtuemart_vendor_id	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	c30allboard.i.virtuemart_paymentmethod_id	1
    1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	c30allboard.i.virtuemart_paymentmethod_id	1	Using where; Using index

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.23 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:522
    25	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:896
    24	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:206
    23	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmpayment/standard/standard.php:379
    22	plgVmPaymentStandard->plgVmOnCheckAutomaticSelectedPayment()	Same as call in the line below.
    21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1490
    18	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1512
    17	calculationHelper->calculatePaymentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:934
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.93 ms After last query: 0.16 ms Query memory: 0.041 MB Memory before query: 8.802 MB Rows returned: 1

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc 
      FROM jos_virtuemart_paymentmethods as i 
     
      LEFT JOIN `jos_virtuemart_paymentmethods_en_gb` as l 
      ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`payment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s 
      ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
      WHERE i.`published` = "1" 
      AND j.`element` = "stripe"
    	    						
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
    	    						
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
      GROUP BY i.`virtuemart_paymentmethod_id` 
      ORDER BY i.`ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition; Using temporary; Using filesort
    1	SIMPLE	i	ALL	payment_jplugin_id,virtuemart_vendor_id	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	c30allboard.i.virtuemart_paymentmethod_id	1
    1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	c30allboard.i.virtuemart_paymentmethod_id	1	Using where; Using index

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.26 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:522
    25	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:896
    24	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:206
    23	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmpayment/stripe/stripe.php:1822
    22	plgVmPaymentStripe->plgVmOnCheckAutomaticSelectedPayment()	Same as call in the line below.
    21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1490
    18	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1512
    17	calculationHelper->calculatePaymentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:934
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:435
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 0.53 ms After last query: 0.88 ms Query memory: 0.034 MB Memory before query: 8.942 MB Rows returned: 1
    Duplicate queries: #59

    SELECT vm.* 
      FROM `jos_virtuemart_shipmentmethods` AS vm,
    						jos_extensions AS j 
      WHERE vm.`virtuemart_shipmentmethod_id` = "5"
    						
      AND vm.shipment_jplugin_id = j.extension_id 
      AND vm.published = 1 
      AND j.element = "weight_countries"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vm	const	PRIMARY,shipment_jplugin_id	PRIMARY	4	const	1
    1	SIMPLE	j	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    24	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:291
    23	vmPlugin->selectedThisByMethodId()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:170
    22	vmPSPlugin->onSelectedCalculatePrice()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:512
    21	plgVmShipmentWeight_countries->plgVmOnSelectedCalculatePriceShipment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1475
    17	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:932
    16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1555
    15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1654
    14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:457
    13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 1.20 ms After last query: 0.57 ms Query memory: 0.029 MB Memory before query: 8.968 MB Rows returned: 0
    Duplicate queries: #61

    SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
    			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc 
      FROM jos_virtuemart_paymentmethods as i 
     
      LEFT JOIN `jos_virtuemart_paymentmethods_en_gb` as l 
      ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
     
      LEFT JOIN `jos_extensions` as j 
      ON j.`extension_id` =  i.`payment_jplugin_id`  
     
      LEFT 
      OUTER JOIN `jos_virtuemart_paymentmethod_shoppergroups` AS s 
      ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
      WHERE i.`published` = "1" 
      AND j.`element` = "paypal"
    	    						
      AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
    	    						
      AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
      GROUP BY i.`virtuemart_paymentmethod_id` 
      ORDER BY i.`ordering`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition; Using temporary; Using filesort
    1	SIMPLE	i	ALL	payment_jplugin_id,virtuemart_vendor_id	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	c30allboard.i.virtuemart_paymentmethod_id	1
    1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	c30allboard.i.virtuemart_paymentmethod_id	1	Using where; Using index

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.38 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.09 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:522
    14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/paypal/paypal.php:250
    13	plgVmPaymentPaypal->plgVmOnProductDisplayPayment()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:348
    9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
    8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
    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:264
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 1.00 ms After last query: 29.31 ms Query memory: 0.020 MB Memory before query: 9.420 MB Rows returned: 13

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-03-17 07:42:32') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-17 07:42:32') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 510 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profile

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.08 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.34 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:418
    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/illusion/index.php:97
    7	require JROOT/templates/illusion/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1061
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:270
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.44 ms After last query: 12.73 ms Query memory: 0.018 MB Memory before query: 9.584 MB Rows returned: 1

    SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
    				
      FROM  jos_virtuemart_category_categories AS `xref`
    				
      WHERE `xref`.`category_child_id`= 18

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	category_child_id	category_child_id	4	const	1

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
    11	VirtueMartModelCategory->getCategoryRecurse()	JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:64
    10	include JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php	JROOT/libraries/cms/module/helper.php:190
    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:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1075
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:270
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.29 ms After last query: 0.11 ms Query memory: 0.019 MB Memory before query: 9.602 MB Rows returned: 1

    SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
    				
      FROM  jos_virtuemart_category_categories AS `xref`
    				
      WHERE `xref`.`category_child_id`= 17

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	category_child_id	category_child_id	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
    12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:770
    11	VirtueMartModelCategory->getCategoryRecurse()	JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php:64
    10	include JROOT/modules/mod_virtuemart_category/mod_virtuemart_category.php	JROOT/libraries/cms/module/helper.php:190
    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:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1075
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:270
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---