**Shopping cart**

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1765182263,
                "last": 1765182263,
                "now": 1765182265
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    },
    "__vm": {
        "vmcartlastVendorId": 1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":1,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":[],\"ST\":{\"address_type_name\":\"**Address Nickname**\"},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":\"47\",\"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,\"OrderIdOrderDone\":false,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":[],\"byDefaultST\":{\"address_type_name\":1},\"productCartLoaded\":[],\"loadedCart\":true,\"lastAddedProduct\":0}",
        "vmlastvisitedItemid": 895,
        "vmlastvisitedcategoryid": 1,
        "vmlastvisitedproductids": [
            14
        ]
    }
}

Profile Information

Time

Memory

**Time**: 34.03 ms / 34.03 ms **Memory**: 0.410 MB / 0.75 MB Application: afterLoad

**Time**: 73.13 ms / 107.16 ms **Memory**: 1.276 MB / 2.03 MB Application: afterInitialise

**Time**: 35.50 ms / 142.66 ms **Memory**: 0.561 MB / 2.59 MB Application: Before Access::preloadComponents (all components)

**Time**: 1.65 ms / 144.32 ms **Memory**: 0.070 MB / 2.66 MB Application: After Access::preloadComponents (all components)

**Time**: 0.03 ms / 144.35 ms **Memory**: -0.004 MB / 2.65 MB Application: Before Access::getAssetRules (id:1 name:root.1)

**Time**: 0.73 ms / 145.08 ms **Memory**: 0.008 MB / 2.66 MB Application: After Access::getAssetRules (id:1 name:root.1)

**Time**: 0.03 ms / 145.11 ms **Memory**: 0.001 MB / 2.66 MB Application: Before Access::getAssetRules (id:274 name:com_virtuemart)

**Time**: 0.01 ms / 145.12 ms **Memory**: 0.002 MB / 2.66 MB Application: After Access::getAssetRules (id:274 name:com_virtuemart)

**Time**: 9.57 ms / 154.69 ms **Memory**: 0.060 MB / 2.72 MB Application: afterRoute

**Time**: 4.13 ms / 158.82 ms **Memory**: 0.046 MB / 2.77 MB Application: beforeRenderComponent com_virtuemart

**Time**: 133.93 ms / 292.75 ms **Memory**: 3.092 MB / 5.86 MB Application: afterRenderComponent com_virtuemart

**Time**: 10.12 ms / 302.87 ms **Memory**: 0.044 MB / 5.90 MB Application: afterDispatch

**Time**: 6.33 ms / 309.20 ms **Memory**: 0.062 MB / 5.97 MB Application: beforeRenderModule mod_menu (Top Menu ENG)

**Time**: 14.84 ms / 324.04 ms **Memory**: 0.139 MB / 6.11 MB Application: afterRenderModule mod_menu (Top Menu ENG)

**Time**: 0.07 ms / 324.11 ms **Memory**: -0.005 MB / 6.10 MB Application: beforeRenderModule mod_custom (Réseaux sociaux (FB+IM))

**Time**: 1.27 ms / 325.38 ms **Memory**: 0.006 MB / 6.11 MB Application: afterRenderModule mod_custom (Réseaux sociaux (FB+IM))

**Time**: 0.03 ms / 325.41 ms **Memory**: -0.002 MB / 6.10 MB Application: beforeRenderModule mod_languages (language switcher)

**Time**: 5.62 ms / 331.03 ms **Memory**: 0.016 MB / 6.12 MB Application: afterRenderModule mod_languages (language switcher)

**Time**: 0.03 ms / 331.06 ms **Memory**: -0.002 MB / 6.12 MB Application: beforeRenderModule mod_virtuemart_cart (VM - Shopping cart)

**Time**: 3.53 ms / 334.59 ms **Memory**: 0.030 MB / 6.15 MB Application: afterRenderModule mod_virtuemart_cart (VM - Shopping cart)

**Time**: 8.37 ms / 342.96 ms **Memory**: 0.282 MB / 6.43 MB Application: afterRender

**Database queries total: 49.15 ms**

Memory Usage

Database Queries

52 Queries Logged 49.15 ms

5 duplicate found!

**3 duplicates**: #35 #49 #51

**2 duplicates**: #41 #45

**Query Time: 0.54 ms** **Query memory: 0.023 MB Memory before query: 1.031 MB** **Rows returned: 1**

SELECT `data`

  FROM `jnew_session`

  WHERE `session_id` = X'7173686d6d307161366a736f396a6e716b32747663386466336c'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_session	const	PRIMARY	PRIMARY	194	const	1

**Profile**

Status	Duration
Starting	0.05 ms
checking permissions	0.02 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.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.02 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	*Same as call in the line below.*
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**Query Time: 0.97 ms** **After last query: 4.01 ms** **Query memory: 0.042 MB Memory before query: 1.082 MB** **Rows returned: 49**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jnew_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_extensions	ref	extension	extension	82	const	49	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.34 ms
End of update loop	0.02 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.02 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	*Same as call in the line below.*
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.48 ms** **After last query: 3.12 ms** **Query memory: 0.021 MB Memory before query: 1.132 MB** **Rows returned: 3**

SELECT id, rules

  FROM `jnew_viewlevels`

**Explain**

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

**Profile**

Status	Duration
Starting	0.05 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.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 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.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.53 ms** **After last query: 0.12 ms** **Query memory: 0.021 MB Memory before query: 1.143 MB** **Rows returned: 1**

SELECT b.id

  FROM jnew_usergroups AS a

  LEFT JOIN jnew_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

**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	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.05 ms
checking permissions	0.02 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.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 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.02 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.35 ms** **After last query: 0.50 ms** **Query memory: 0.031 MB Memory before query: 1.165 MB** **Rows returned: 128**

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM jnew_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	334	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.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.73 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.00 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	*Same as call in the line below.*
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.76 ms** **After last query: 18.86 ms** **Query memory: 0.021 MB Memory before query: 1.613 MB** **Rows returned: 2**

SELECT *

  FROM jnew_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profile**

Status	Duration
Starting	0.06 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.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.11 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.77 ms** **After last query: 0.18 ms** **Query memory: 0.021 MB Memory before query: 1.621 MB** **Rows returned: 4**

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `jnew_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_extensions	ref	extension	extension	82	const	4	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.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.02 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.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 3.12 ms** **After last query: 13.00 ms** **Query memory: 0.133 MB Memory before query: 1.697 MB** **Rows returned: 86**

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 jnew_menu AS m

  LEFT JOIN jnew_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	208	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.m.component_id	1	Using where

**Profile**

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	2.35 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.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	*Same as call in the line below.*
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.44 ms** **After last query: 34.23 ms** **Query memory: 0.024 MB Memory before query: 2.519 MB** **Rows returned: 1**

SHOW TABLES LIKE "jnew_virtuemart_configs"

**Explain**

**EXPLAIN not possible on query: SHOW TABLES LIKE "jnew_virtuemart_configs"**

**Profile**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.04 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
checking permissions	0.88 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.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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:826
15	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:600
14	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:408
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:202
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.51 ms** **After last query: 0.08 ms** **Query memory: 0.022 MB Memory before query: 2.527 MB** **Rows returned: 1**

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_virtuemart_configs	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	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.02 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.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.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:457
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:202
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.41 ms** **After last query: 0.55 ms** **Query memory: 0.030 MB Memory before query: 2.594 MB** **Rows returned: 49**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jnew_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_favicon','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_popup_anywhere','com_postinstall','com_privacy','com_redirect','com_search','com_spambotcheck','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_assets	range	idx_asset_name	idx_asset_name	202	NULL	50	Using index condition

**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.07 ms
Optimizing	0.02 ms
Statistics	0.20 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.65 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:479
13	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:202
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.97 ms** **After last query: 1.49 ms** **Query memory: 0.023 MB Memory before query: 2.666 MB** **Rows returned: 9**

SELECT id, home, template, s.params

  FROM jnew_template_styles as s

  LEFT JOIN jnew_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	15	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	millesimclassicrally-testv16.s.template,const	1	Using index condition; Using where

**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.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.02 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.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:222
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.30 ms** **After last query: 1.15 ms** **Query memory: 0.026 MB Memory before query: 2.690 MB** **Rows returned: 7**

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

**Explain**

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

**Profile**

Status	Duration
Starting	0.08 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.10 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.55 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.02 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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1727
14	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:301
13	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:267
12	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:320
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:121
10	virtuemartParseRoute()	JROOT/components/com_virtuemart/router.php:59
9	VirtuemartRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.62 ms** **After last query: 6.02 ms** **Query memory: 0.022 MB Memory before query: 2.745 MB** **Rows returned: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jnew_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

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

**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.03 ms
Statistics	0.13 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*Same as call in the line below.*
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.62 ms** **After last query: 0.16 ms** **Query memory: 0.005 MB Memory before query: 2.735 MB**

UPDATE `jnew_extensions`

  SET `params` = '{\"mediaversion\":\"aec06337d6e383852ec094c6f02f42db\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

**EXPLAIN not possible on query: UPDATE `jnew_extensions` SET `params` = '{\"mediaversion\":\"aec06337d6e383852ec094c6f02f42db\"}' 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.10 ms
Updating	0.12 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.07 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.68 ms** **After last query: 12.22 ms** **Query memory: 0.023 MB Memory before query: 3.087 MB** **Rows returned: 1**

SELECT * 
  FROM `jnew_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	jnew_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

**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.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.08 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.02 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:101
13	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
12	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
11	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
10	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:198
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:85
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.63 ms** **After last query: 1.08 ms** **Query memory: 0.026 MB Memory before query: 3.123 MB** **Rows returned: 1**

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

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_virtuemart_shoppergroups	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.03 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1161
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
14	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:109
13	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:139
12	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:201
11	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:125
10	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:198
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:85
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.51 ms** **After last query: 0.80 ms** **Query memory: 0.034 MB Memory before query: 3.164 MB** **Rows returned: 33**

SHOW FULL COLUMNS  
  FROM `jnew_virtuemart_userfields`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jnew_virtuemart_userfields`**

**Profile**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.46 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.26 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.16 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:787
18	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
17	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:239
16	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:441
15	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:403
14	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:620
13	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
12	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:572
11	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:381
10	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:85
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.89 ms** **After last query: 0.17 ms** **Query memory: 0.035 MB Memory before query: 3.204 MB** **Rows returned: 16**

SELECT * 
  FROM `jnew_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	jnew_virtuemart_userfields	ALL	published,account	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort

**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.06 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.26 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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
13	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
12	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:441
11	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
10	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:85
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.66 ms** **After last query: 1.72 ms** **Query memory: 0.024 MB Memory before query: 3.363 MB** **Rows returned: 1**

SELECT COUNT(*)

  FROM `jnew_extensions`

  WHERE `element` = 'com_spambotcheck' 
  AND `enabled` = '1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_extensions	ref	element_clientid,element_folder_clientid	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.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/user/spambotcheck/SpambotCheck/SpambotCheckHelpers.php:632
15	plgSpambotCheckHelpers::checkComponentInstalled()	JROOT/plugins/user/spambotcheck/spambotcheck.php:23
14	plgUserSpambotCheck->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
13	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
12	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_virtuemart/models/userfields.php:482
11	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
10	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:85
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.00 ms** **After last query: 1.64 ms** **Query memory: 0.031 MB Memory before query: 3.426 MB** **Rows returned: 14**

SELECT * 
  FROM `jnew_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	jnew_virtuemart_userfields	ALL	published,shipment	NO INDEX KEY COULD BE USED	NULL	NULL	28	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.02 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
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.23 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.06 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
13	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
12	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:447
11	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:422
10	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:265
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:85
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.65 ms** **After last query: 0.47 ms** **Query memory: 0.022 MB Memory before query: 3.502 MB** **Rows returned: 2**

SELECT `fieldtitle`, `fieldvalue` 
  FROM `jnew_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	jnew_virtuemart_userfield_values	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.06 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.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.08 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:513
11	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1020
10	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:425
9	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/controllers/cart.php:93
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.80 ms** **After last query: 2.16 ms** **Query memory: 0.097 MB Memory before query: 3.548 MB** **Rows returned: 249**

SELECT *  
  FROM `jnew_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY ordering, country_name ASC

**Explain**

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

**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.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.23 ms
End of update loop	0.02 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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:892
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:161
12	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:181
11	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:831
10	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:425
9	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/controllers/cart.php:93
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.78 ms** **After last query: 14.01 ms** **Query memory: 0.026 MB Memory before query: 4.393 MB** **Rows returned: 1**

SELECT *  
  FROM `jnew_virtuemart_currencies` AS c
			
  LEFT JOIN `jnew_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	const	PRIMARY,vendor_currency	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

**Profile**

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.05 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.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:316
15	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
14	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
13	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2352
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2466
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:98
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.60 ms** **After last query: 1.14 ms** **Query memory: 0.025 MB Memory before query: 4.433 MB** **Rows returned: 1**

SELECT `jnew_virtuemart_currencies`.*  
  FROM `jnew_virtuemart_currencies`  
  WHERE `jnew_virtuemart_currencies`.`virtuemart_currency_id` = "47"

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_virtuemart_currencies	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.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1161
14	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
13	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2352
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2466
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:98
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.12 ms** **After last query: 0.54 ms** **Query memory: 0.024 MB Memory before query: 4.473 MB** **Rows returned: 1**

SELECT c.* 
  FROM jnew_virtuemart_calcs as c  
  LEFT JOIN jnew_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 (  ( ISNULL(`publish_up`) or `publish_up`="0000-00-00 00:00:00")  OR publish_up <= "2025-12-08 07:24:25" )
				
  AND (  ( ISNULL(`publish_down`) or `publish_down`="0000-00-00 00:00:00")  OR publish_down >= "2025-12-08 07:24:25" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL) 
  ORDER BY c.ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where; Using filesort
1	SIMPLE	cs	ref	virtuemart_calc_id	virtuemart_calc_id	4	millesimclassicrally-testv16.c.virtuemart_calc_id	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.06 ms
Statistics	0.17 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 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.02 ms
Updating status	0.04 ms
Reset for next command	0.04 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:174
13	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:95
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:111
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2352
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2466
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:98
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.90 ms** **After last query: 0.72 ms** **Query memory: 0.023 MB Memory before query: 4.580 MB** **Rows returned: 0**

SELECT * 
  FROM jnew_virtuemart_calcs  
  LEFT JOIN jnew_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-12-08 07:24:25" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-12-08 07:24:25" )
 
  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	jnew_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where
1	SIMPLE	jnew_virtuemart_calc_shoppergroups	ref	virtuemart_calc_id	virtuemart_calc_id	4	millesimclassicrally-testv16.jnew_virtuemart_calcs.virtuemart_calc_id	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.08 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.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1523
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:774
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2356
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2466
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:98
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.80 ms** **After last query: 0.09 ms** **Query memory: 0.023 MB Memory before query: 4.588 MB** **Rows returned: 0**

SELECT * 
  FROM jnew_virtuemart_calcs  
  LEFT JOIN jnew_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-12-08 07:24:25" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-12-08 07:24:25" )
 
  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	jnew_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where
1	SIMPLE	jnew_virtuemart_calc_shoppergroups	ref	virtuemart_calc_id	virtuemart_calc_id	4	millesimclassicrally-testv16.jnew_virtuemart_calcs.virtuemart_calc_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.08 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.07 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1523
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:775
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2356
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2466
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:98
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.74 ms** **After last query: 0.09 ms** **Query memory: 0.023 MB Memory before query: 4.595 MB** **Rows returned: 0**

SELECT * 
  FROM jnew_virtuemart_calcs  
  LEFT JOIN jnew_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( ISNULL(publish_up) or publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-12-08 07:24:25" )
				
  AND ( ISNULL(publish_down) or publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-12-08 07:24:25" )
 
  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	jnew_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	Using where
1	SIMPLE	jnew_virtuemart_calc_shoppergroups	ref	virtuemart_calc_id	virtuemart_calc_id	4	millesimclassicrally-testv16.jnew_virtuemart_calcs.virtuemart_calc_id	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.09 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.08 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.07 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1523
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:776
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2356
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2466
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:98
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.95 ms** **After last query: 51.84 ms** **Query memory: 0.024 MB Memory before query: 5.386 MB** **Rows returned: 0**

SELECT `jnew_virtuemart_vendors`.* ,`jnew_virtuemart_vendors_en_gb`.*  
  FROM `jnew_virtuemart_vendors` 
  INNER JOIN `jnew_virtuemart_vendors_en_gb` 
  ON `jnew_virtuemart_vendors`.`virtuemart_vendor_id` = `jnew_virtuemart_vendors_en_gb`.`virtuemart_vendor_id`  
  WHERE `jnew_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

**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.13 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.01 ms
Executing	0.07 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.04 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:78
12	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/helpers/cart.php:2375
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1886
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:1711
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:126
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.80 ms** **After last query: 0.10 ms** **Query memory: 0.040 MB Memory before query: 5.394 MB** **Rows returned: 1**

SELECT `jnew_virtuemart_vendors`.* ,`jnew_virtuemart_vendors_fr_fr`.*  
  FROM `jnew_virtuemart_vendors` 
  INNER JOIN `jnew_virtuemart_vendors_fr_fr` 
  ON `jnew_virtuemart_vendors`.`virtuemart_vendor_id` = `jnew_virtuemart_vendors_fr_fr`.`virtuemart_vendor_id`  
  WHERE `jnew_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

**Explain**

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

**Profile**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.07 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.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.24 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:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
14	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1207
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:78
12	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/helpers/cart.php:2375
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1886
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:1711
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:126
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.66 ms** **After last query: 0.77 ms** **Query memory: 0.023 MB Memory before query: 5.459 MB** **Rows returned: 2**

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

**Explain**

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

**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.09 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.10 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:78
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:88
12	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/helpers/cart.php:2375
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1886
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:1711
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:126
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.62 ms** **After last query: 0.41 ms** **Query memory: 0.026 MB Memory before query: 5.500 MB** **Rows returned: 1**

SELECT `jnew_virtuemart_medias`.*  
  FROM `jnew_virtuemart_medias`  
  WHERE `jnew_virtuemart_medias`.`virtuemart_media_id` = "3"

**Explain**

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

**Profile**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.06 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.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 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
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.02 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1135
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:99
14	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:560
13	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1321
12	VmModel->addImages()	JROOT/components/com_virtuemart/helpers/cart.php:2376
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1886
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:1711
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:126
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.93 ms** **After last query: 0.65 ms** **Query memory: 0.031 MB Memory before query: 5.515 MB** **Rows returned: 8**

SELECT * 
  FROM `jnew_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`="1" 
  AND published = 1 
  AND required = 1 
  AND type != 'delimiter' 
  AND type != 'captcha' 
  AND FIND_IN_SET(name, 'delimiter_userinfo,name,username,password,password2,address_type_name,address_type,user_is_vendor,agreed') = 0  
  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_virtuemart_userfields	ALL	published,account	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.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.20 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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
13	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
12	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/user.php:1269
11	VirtueMartModelUser->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:1909
10	VirtueMartCart->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:1720
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:126
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.17 ms** **After last query: 1.31 ms** **Query memory: 0.025 MB Memory before query: 5.624 MB** **Rows returned: 0**

**Duplicate queries**: #49 #51

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

**Explain**

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

**Profile**

Status	Duration
Starting	0.09 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.04 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.03 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
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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
18	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
17	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
16	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/helpers/vmview.php:591
10	VmView->prepareContinueLink()	JROOT/components/com_virtuemart/views/cart/view.html.php:47
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.89 ms** **After last query: 1.59 ms** **Query memory: 0.024 MB Memory before query: 5.638 MB** **Rows returned: 2**

SELECT * 
  FROM `jnew_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `cart`="1" 
  AND published = 1 
  AND type != 'delimiter' 
  AND type != 'captcha' 
  AND FIND_IN_SET(name, 'delimiter_userinfo,user_is_vendor,username,password,password2,agreed,address_type') = 0  
  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_virtuemart_userfields	ref	published,cart	cart	1	const	4	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.09 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.07 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:515
11	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:569
10	VirtueMartModelUserfields->getUserFields()	JROOT/components/com_virtuemart/views/cart/view.html.php:108
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.70 ms** **After last query: 1.28 ms** **Query memory: 0.027 MB Memory before query: 5.678 MB** **Rows returned: 1**

SELECT IFNULL(l.slug,ld.slug) as slug  
  FROM `jnew_virtuemart_vendors_fr_fr` as ld   
  LEFT JOIN `jnew_virtuemart_vendors_en_gb` as l 
  ON l.`virtuemart_vendor_id` = ld.`virtuemart_vendor_id` 
  WHERE IFNULL(l.virtuemart_vendor_id,ld.virtuemart_vendor_id) = "1" OR ld.virtuemart_vendor_id = "1"

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ld	index	PRIMARY	slug	767	NULL	1	Using index
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.ld.virtuemart_vendor_id	1	Using where

**Profile**

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.05 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.04 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.08 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.03 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1652
22	vmrouterHelper::getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1611
21	vmrouterHelper::getVendorName()	JROOT/components/com_virtuemart/router.php:728
20	vmrouterHelper::buildRoute()	JROOT/components/com_virtuemart/router.php:85
19	VirtuemartRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/tos.php:64
12	include JROOT/components/com_virtuemart/sublayouts/tos.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:598
11	shopFunctionsF::renderVmSubLayout()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1009
10	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/views/cart/view.html.php:113
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 2.26 ms** **After last query: 0.57 ms** **Query memory: 0.026 MB Memory before query: 5.703 MB** **Rows returned: 2**

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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , IFNULL(l.payment_name,ld.payment_name) as payment_name, IFNULL(l.payment_desc,ld.payment_desc) as payment_desc 
  FROM jnew_virtuemart_paymentmethods as i 
 
  LEFT JOIN `jnew_virtuemart_paymentmethods_fr_fr` as ld 
  ON ld.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
 
  LEFT JOIN `jnew_virtuemart_paymentmethods_en_gb` as l 
  ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
 
  LEFT JOIN `jnew_extensions` as j 
  ON j.`extension_id` =  i.`payment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `jnew_virtuemart_paymentmethod_shoppergroups` AS s 
  ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
  WHERE 
 i.`published` = "1" 
  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` ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	index	virtuemart_vendor_id	PRIMARY	4	NULL	5	Using where; Using temporary; Using filesort
1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1
1	SIMPLE	j	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.payment_jplugin_id	1
1	SIMPLE	s	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.18 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Creating tmp table	0.13 ms
Sorting for group	0.02 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.82 ms
Creating sort index	0.10 ms
Removing tmp table	0.18 ms
Creating sort index	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.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:513
15	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/paypal/paypal.php:315
14	plgVmPaymentPaypal->plgVmOnCheckoutAdvertise()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
11	vDispatcher::trigger()	JROOT/components/com_virtuemart/helpers/cart.php:2486
10	VirtueMartCart->getCheckoutAdvertise()	JROOT/components/com_virtuemart/views/cart/view.html.php:124
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.13 ms** **After last query: 0.19 ms** **Query memory: 0.025 MB Memory before query: 5.725 MB** **Rows returned: 0**

SELECT id 
  FROM `jnew_menu` 
  WHERE `link` like "index.php?option=com_virtuemart&view=cart&task=orderdone%" 
  and (language="*" or language = "en-GB" ) 
  AND client_id=0 
  AND published=1 
  AND ( access="1" )  
  ORDER BY `language` DESC

**Explain**

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

**Profile**

Status	Duration
Starting	0.08 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.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.49 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.00 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
17	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
16	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
15	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
14	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
10	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/cart/view.html.php:156
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.82 ms** **After last query: 0.83 ms** **Query memory: 0.024 MB Memory before query: 5.756 MB** **Rows returned: 1**

SELECT SQL_CALC_FOUND_ROWS i.*, IFNULL(l.shipment_name,ld.shipment_name) as shipment_name, IFNULL(l.shipment_desc,ld.shipment_desc) as shipment_desc  
  FROM `jnew_virtuemart_shipmentmethods` as i  
  LEFT JOIN `jnew_virtuemart_shipmentmethods_fr_fr` as ld 
  ON ld.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`  
  LEFT JOIN `jnew_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`

 
 
  ORDER BY i.ordering DESC 
  LIMIT 0, 24

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using filesort
1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1

**Profile**

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.05 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.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 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.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:892
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:186
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/views/cart/view.html.php:468
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:270
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:164
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.22 ms** **After last query: 0.08 ms** **Query memory: 0.023 MB Memory before query: 5.766 MB** **Rows returned: 1**

**Duplicate queries**: #45

SELECT FOUND_ROWS()

**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	No tables used

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	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:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:902
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:186
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/views/cart/view.html.php:468
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:270
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:164
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.39 ms** **After last query: 0.08 ms** **Query memory: 0.023 MB Memory before query: 5.779 MB** **Rows returned: 0**

SELECT `virtuemart_shoppergroup_id` 
  FROM jnew_virtuemart_shipmentmethod_shoppergroups 
  WHERE `virtuemart_shipmentmethod_id` = "1"

**Explain**

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

**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.02 ms
Statistics	0.05 ms
Preparing	0.03 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.00 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:207
13	VirtueMartModelShipmentmethod->getShipmentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:191
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/views/cart/view.html.php:468
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:270
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:164
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.80 ms** **After last query: 0.15 ms** **Query memory: 0.026 MB Memory before query: 5.784 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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , IFNULL(l.shipment_name,ld.shipment_name) as shipment_name, IFNULL(l.shipment_desc,ld.shipment_desc) as shipment_desc 
  FROM jnew_virtuemart_shipmentmethods as i 
 
  LEFT JOIN `jnew_virtuemart_shipmentmethods_fr_fr` as ld 
  ON ld.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `jnew_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `jnew_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `jnew_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE 
 i.`published` = "1" 
  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` ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	index	NULL	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort
1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1
1	SIMPLE	j	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.shipment_jplugin_id	1
1	SIMPLE	s	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	millesimclassicrally-testv16.i.virtuemart_shipmentmethod_id	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting for group	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.66 ms
Creating sort index	0.08 ms
Removing tmp table	0.16 ms
Creating sort index	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.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:513
16	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:118
15	vmPSPlugin->displayListFE()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:448
14	plgVmShipmentWeight_countries->plgVmDisplayListFEShipment()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/administrator/components/com_virtuemart/helpers/vdispatcher.php:39
11	vDispatcher::trigger()	JROOT/components/com_virtuemart/views/cart/view.html.php:281
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:164
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.81 ms** **After last query: 0.98 ms** **Query memory: 0.024 MB Memory before query: 5.808 MB** **Rows returned: 2**

SELECT SQL_CALC_FOUND_ROWS i.*, IFNULL(l.payment_name,ld.payment_name) as payment_name, IFNULL(l.payment_desc,ld.payment_desc) as payment_desc  
  FROM `jnew_virtuemart_paymentmethods` as i  
  LEFT JOIN `jnew_virtuemart_paymentmethods_fr_fr` as ld 
  ON ld.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`  
  LEFT JOIN `jnew_virtuemart_paymentmethods_en_gb` as l 
  ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
 
  WHERE  `published` = 1
 
 
  ORDER BY i.ordering DESC 
  LIMIT 0, 24

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using filesort
1	SIMPLE	ld	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.i.virtuemart_paymentmethod_id	1

**Profile**

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 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.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.11 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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:892
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:164
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/components/com_virtuemart/views/cart/view.html.php:446
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:322
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:165
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.24 ms** **After last query: 0.08 ms** **Query memory: 0.023 MB Memory before query: 5.821 MB** **Rows returned: 1**

**Duplicate queries**: #41

SELECT FOUND_ROWS()

**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	No tables used

**Profile**

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	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.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:902
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:164
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/components/com_virtuemart/views/cart/view.html.php:446
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:322
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:165
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.39 ms** **After last query: 0.06 ms** **Query memory: 0.023 MB Memory before query: 5.828 MB** **Rows returned: 0**

SELECT `virtuemart_shoppergroup_id` 
  FROM jnew_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "5"

**Explain**

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

**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.05 ms
Preparing	0.03 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.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:184
13	VirtueMartModelPaymentmethod->getPaymentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:170
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/components/com_virtuemart/views/cart/view.html.php:446
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:322
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:165
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.44 ms** **After last query: 0.05 ms** **Query memory: 0.023 MB Memory before query: 5.835 MB** **Rows returned: 2**

SELECT `virtuemart_shoppergroup_id` 
  FROM jnew_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "3"

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jnew_virtuemart_paymentmethod_shoppergroups	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	const	2	Using index

**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.05 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
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:184
13	VirtueMartModelPaymentmethod->getPaymentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:170
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/components/com_virtuemart/views/cart/view.html.php:446
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:322
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:165
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:131
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:133
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.85 ms** **After last query: 13.64 ms** **Query memory: 0.021 MB Memory before query: 5.886 MB** **Rows returned: 3**

SELECT language,id

  FROM `jnew_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

**Explain**

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

**Profile**

Status	Duration
Starting	0.08 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.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.27 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.00 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.07 ms** **After last query: 0.34 ms** **Query memory: 0.024 MB Memory before query: 5.893 MB** **Rows returned: 0**

**Duplicate queries**: #35 #51

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

**Explain**

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

**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.04 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.44 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
15	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
14	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
13	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:805
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.93 ms** **After last query: 6.34 ms** **Query memory: 0.024 MB Memory before query: 5.965 MB** **Rows returned: 8**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jnew_modules AS m

  LEFT JOIN jnew_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN jnew_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 <= '2025-12-08 08:24:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-08 08:24:25') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  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,idx_language	published	5	const,const	42	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	millesimclassicrally-testv16.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	millesimclassicrally-testv16.m.id	3	Using where; Using index

**Profile**

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.07 ms
Statistics	0.18 ms
Preparing	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.93 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.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	*Same as call in the line below.*
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/horme_3_pro/logic.php:180
8	require_once JROOT/templates/horme_3_pro/logic.php	JROOT/templates/horme_3_pro/index.php:11
7	require JROOT/templates/horme_3_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 1.11 ms** **After last query: 26.65 ms** **Query memory: 0.026 MB Memory before query: 6.150 MB** **Rows returned: 0**

**Duplicate queries**: #35 #49

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

**Explain**

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

**Profile**

Status	Duration
Starting	0.08 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.04 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.44 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:2089
19	vmrouterHelper::findCorrectItemidBySQL()	JROOT/components/com_virtuemart/router.php:368
18	vmrouterHelper::preprocess()	JROOT/components/com_virtuemart/router.php:73
17	VirtuemartRouter->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/templates/horme_3_pro/html/mod_virtuemart_cart/default.php:87
11	require JROOT/templates/horme_3_pro/html/mod_virtuemart_cart/default.php	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:65
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Query Time: 0.81 ms** **After last query: 5.32 ms** **Query memory: 0.033 MB Memory before query: 6.278 MB** **Rows returned: 178**

SELECT * 
  FROM jnew_acymailing_config

**Explain**

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

**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.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.28 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.02 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:145
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**4 × SELECT * 
  FROM `jnew_virtuemart_userfields`**

```
**4 × SELECT id 
  FROM `jnew_menu`**
```

**3 × SELECT * 
  FROM jnew_virtuemart_calcs  
  LEFT JOIN jnew_virtuemart_calc_shoppergroups using(virtuemart_calc_id)**

**2 × SELECT `virtuemart_shoppergroup_id` 
  FROM jnew_virtuemart_paymentmethod_shoppergroups**

```
**2 × SELECT FOUND_ROWS(**
```

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `jnew_extensions`**

**1 × SELECT `jnew_virtuemart_vendors`.* ,`jnew_virtuemart_vendors_en_gb`.*  
  FROM `jnew_virtuemart_vendors` 
  INNER JOIN `jnew_virtuemart_vendors_en_gb` 
  ON `jnew_virtuemart_vendors`.`virtuemart_vendor_id` = `jnew_virtuemart_vendors_en_gb`.`virtuemart_vendor_id`**

**1 × SELECT `jnew_virtuemart_vendors`.* ,`jnew_virtuemart_vendors_fr_fr`.*  
  FROM `jnew_virtuemart_vendors` 
  INNER JOIN `jnew_virtuemart_vendors_fr_fr` 
  ON `jnew_virtuemart_vendors`.`virtuemart_vendor_id` = `jnew_virtuemart_vendors_fr_fr`.`virtuemart_vendor_id`**

**1 × SELECT `virtuemart_media_id` 
  FROM `jnew_virtuemart_vendor_medias`**

**1 × SELECT `jnew_virtuemart_medias`.*  
  FROM `jnew_virtuemart_medias`**

**1 × SELECT `data` 
  FROM `jnew_session`**

**1 × SELECT IFNULL(l.slug,ld.slug) as slug  
  FROM `jnew_virtuemart_vendors_fr_fr` as ld   
  LEFT JOIN `jnew_virtuemart_vendors_en_gb` as l 
  ON l.`virtuemart_vendor_id` = ld.`virtuemart_vendor_id`**

**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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , IFNULL(l.payment_name,ld.payment_name) as payment_name, IFNULL(l.payment_desc,ld.payment_desc) as payment_desc 
  FROM jnew_virtuemart_paymentmethods as i   
  LEFT JOIN `jnew_virtuemart_paymentmethods_fr_fr` as ld 
  ON ld.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`   
  LEFT JOIN `jnew_virtuemart_paymentmethods_en_gb` as l 
  ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`   
  LEFT JOIN `jnew_extensions` as j 
  ON j.`extension_id` =  i.`payment_jplugin_id`    
  LEFT 
  OUTER JOIN `jnew_virtuemart_paymentmethod_shoppergroups` AS s 
  ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`**

**1 × SELECT `virtuemart_shoppergroup_id` 
  FROM jnew_virtuemart_shipmentmethod_shoppergroups**

**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.`checked_out`, j.`checked_out_time`, j.`state` , j.`system_data` , s.virtuemart_shoppergroup_id , IFNULL(l.shipment_name,ld.shipment_name) as shipment_name, IFNULL(l.shipment_desc,ld.shipment_desc) as shipment_desc 
  FROM jnew_virtuemart_shipmentmethods as i   
  LEFT JOIN `jnew_virtuemart_shipmentmethods_fr_fr` as ld 
  ON ld.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`   
  LEFT JOIN `jnew_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`   
  LEFT JOIN `jnew_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `jnew_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`**

**1 × SELECT SQL_CALC_FOUND_ROWS i.*, IFNULL(l.payment_name,ld.payment_name) as payment_name, IFNULL(l.payment_desc,ld.payment_desc) as payment_desc  
  FROM `jnew_virtuemart_paymentmethods` as i  
  LEFT JOIN `jnew_virtuemart_paymentmethods_fr_fr` as ld 
  ON ld.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`  
  LEFT JOIN `jnew_virtuemart_paymentmethods_en_gb` as l 
  ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`**

**1 × SELECT language,id 
  FROM `jnew_menu`**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jnew_modules AS m 
  LEFT JOIN jnew_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jnew_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT SQL_CALC_FOUND_ROWS i.*, IFNULL(l.shipment_name,ld.shipment_name) as shipment_name, IFNULL(l.shipment_desc,ld.shipment_desc) as shipment_desc  
  FROM `jnew_virtuemart_shipmentmethods` as i  
  LEFT JOIN `jnew_virtuemart_shipmentmethods_fr_fr` as ld 
  ON ld.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`  
  LEFT JOIN `jnew_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`**

**1 × SELECT `jnew_virtuemart_currencies`.*  
  FROM `jnew_virtuemart_currencies`**

**1 × SELECT c.* 
  FROM jnew_virtuemart_calcs as c  
  LEFT JOIN jnew_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id**

**1 × SELECT `config` 
  FROM `jnew_virtuemart_configs`**

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

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

**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM jnew_extensions**

**1 × SELECT * 
  FROM jnew_languages**

**1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `jnew_extensions`**

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

**1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jnew_assets`**

**1 × SELECT *  
  FROM `jnew_virtuemart_currencies` AS c    
  LEFT JOIN `jnew_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency**

**1 × SELECT id, home, template, s.params 
  FROM jnew_template_styles as s 
  LEFT JOIN jnew_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

```
**1 × SELECT * 
  FROM `jnew_menu`**
```

**1 × SELECT * 
  FROM `jnew_virtuemart_shoppergroups`**

**1 × SELECT `jnew_virtuemart_shoppergroups`.*  
  FROM `jnew_virtuemart_shoppergroups`**

**1 × SELECT COUNT(*) 
  FROM `jnew_extensions`**

**1 × SELECT `fieldtitle`, `fieldvalue` 
  FROM `jnew_virtuemart_userfield_values`**

**1 × SELECT *  
  FROM `jnew_virtuemart_countries`**

**1 × SELECT * 
  FROM jnew_acymailing_confi**

OTHER Tables:

**1 × SHOW TABLES LIKE "jnew_virtuemart_configs**

**1 × UPDATE `jnew_extensions` 
  SET `params` = '{\"mediaversion\":\"aec06337d6e383852ec094c6f02f42db\"}'**

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

Parsing errors in language files

Language Files Loaded

**Loaded** : JROOT/language/en-GB/en-GB.ini
**Loaded** : JROOT/language/en-GB/en-GB.lib_joomla.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_j2xml.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_updatenotification.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_fields.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_logrotation.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_logout.ini
**Loaded** : JROOT/components/com_virtuemart/language/en-GB/en-GB.com_virtuemart.sef.ini
**Loaded** : JROOT/language/en-GB/en-GB.tpl_horme_3_pro.ini
**Loaded** : JROOT/language/en-GB/en-GB.com_virtuemart.ini
**Loaded** : JROOT/components/com_virtuemart/language/en-GB/en-GB.com_virtuemart.ini
**Loaded** : JROOT/components/com_virtuemart/language/en-GB/en-GB.com_virtuemart_shoppers.ini
**Not loaded** : JROOT/administrator/language/en-GB/en-GB.plg_user_spambotcheck.ini
**Not loaded** : JROOT/administrator/language/en-GB/plg_user_spambotcheck.ini
**Loaded** : JROOT/plugins/user/spambotcheck/language/en-GB/en-GB.plg_user_spambotcheck.ini
**Loaded** : JROOT/administrator/components/com_virtuemart/language/en-GB/en-GB.com_virtuemart_countries.ini
**Loaded** : JROOT/plugins/vmcustom/textinput/language/en-GB/en-GB.plg_vmcustom_textinput.ini
**Loaded** : JROOT/plugins/vmcustom/specification/language/en-GB/en-GB.plg_vmcustom_specification.ini
**Loaded** : JROOT/plugins/vmcustom/istraxx_download_simple/language/en-GB/en-GB.plg_vmcustom_istraxx_download_simple.ini
**Loaded** : JROOT/plugins/vmshipment/weight_countries/language/en-GB/en-GB.plg_vmshipment_weight_countries.ini
**Loaded** : JROOT/plugins/vmshipment/rules_shipping_advanced/language/en-GB/en-GB.plg_vmshipment_rules_shipping_advanced.ini
**Loaded** : JROOT/plugins/vmpayment/standard/language/en-GB/en-GB.plg_vmpayment_standard.ini
**Loaded** : JROOT/plugins/vmpayment/paypal/language/en-GB/en-GB.plg_vmpayment_paypal.ini
**Loaded** : JROOT/plugins/vmpayment/alatak_monetico/language/en-GB/en-GB.plg_vmpayment_alatak_monetico.ini
**Not loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_jcemediabox.ini
**Not loaded** : JROOT/administrator/language/en-GB/plg_system_jcemediabox.ini
**Loaded** : JROOT/plugins/system/jcemediabox/language/en-GB/en-GB.plg_system_jcemediabox.ini
**Loaded** : JROOT/language/en-GB/en-GB.mod_menu.ini
**Loaded** : JROOT/language/en-GB/en-GB.mod_custom.ini
**Loaded** : JROOT/language/en-GB/en-GB.mod_languages.ini
**Loaded** : JROOT/language/en-GB/en-GB.mod_virtuemart_cart.ini
**Not loaded** : JROOT/language/en-GB/en-GB.com_acymailing.ini
**Not loaded** : JROOT/language/en-GB/com_acymailing.ini
**Not loaded** : JROOT/language/en-GB/en-GB.com_acymailing_custom.ini
**Not loaded** : JROOT/language/en-GB/com_acymailing_custom.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_debug.ini

Untranslated Strings


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

000_="€"
A_HREF=""" rel"

# JROOT/libraries/src/Language/Text.php

DEFINING_CUSTOM_FUNCTION_CONVERTFROMCURRENCY="custom function convertfromcurrency"
DEFINING_CUSTOM_FUNCTION_CONVERTTOCURRENCY="custom function converttocurrency"
JOOMEXT_NO="NO"
JOOMEXT_YES="YES"

**Cart empty**

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**52 Queries Logged** 49.15 ms

**5 duplicate found!**

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

**SELECT Tables:**

**OTHER Tables:**

**Parsing errors in language files**

**Language Files Loaded**

**Untranslated Strings**

Cart empty

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

52 Queries Logged 49.15 ms

5 duplicate found!

41 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings