Bill To

Ship To

Use for the shipto same as billto address

Name	Tax	Total

Product prices result
Selected shipment Free Shipping or change the selected shipment method Free Shipping

Total:	$0.00	$0.00

Notes and special requests

I Agree To The Terms of Service

Terms of service

The privacy of your personally identifiable information is important to us. As part of our commitment to the privacy of your personally identifiable information, we provide this notice explaining our online information practices and the choices you can make about the way your information is collected and used at this site. To make this notice easy to find, we make it available on our homepage and at every point where personally identifiable information is requested.

The privacy practices set forth in this Privacy Policy are for this site only.

The Information We Collect

In general, when you visit our site you remain anonymous, but on some pages, you need to provide personally identifiable information to register, order products and contact Argo Networks. The types of personally identifiable
information collected at these pages may include:

Name, Company, Address, E-mail Address, Phone Number, Fax Number, and Credit/Debit Card Information

The Way We Use Information

We use the information you provide when placing an order or accessing this Web site to complete that order and to provide a more personalized shopping experience.

We maintain credit/debit card information only until payment for your order is processed unless you authorize the information to be stored for future visits. If you later decide that you do not want us to store such information, you may contact us at sales@argo-networks.com or at 502.635.6963 and ask us to delete such information. We also use your information to communicate with you, for example, to answer the e-mail and correspondence we receive, to confirm your order, to send more information about a question, and to notify you of important changes in the functionality of the Web site.

We may use your information to make recommendations for additional products or special offers, and to provide you with updates on new products that we believe may be of interest to you. If you do not want to receive this information in the future, please contact us at sales@argo-networks.com. We may disclose personally identifiable information in response to legal process or when we believe in good faith that the law requires it, for example, in response to a court order, subpoena or a law enforcement agency's request.

We will not use or share the personally identifiable information provided to us online in ways unrelated to the ones described above without first providing you an opportunity to opt out or otherwise prohibit such unrelated uses.

Customization and Aggregate data

We use non-identifying and aggregate information to better design our Web site and gather information for product management and development at Argo Networks. For example, we may tell our sales and marketing staff that X number of individuals visited a certain area on our Website, or that Y number of products were ordered during a particular time period, but we would not disclose anything that could be used to identify those individuals.

Our Commitment to Data Security

We have put in place physical, electronic, and managerial procedures to safeguard and secure the information we collect online. When you place orders or access your account information, we offer the use of a secure server. The secure server software receives encrypted information through the Secure Sockets Layer (SSL) of your internet browser which encrypts the information you input before it is sent to us and prevents anyone else from reading it as the information travels from your computer to ours.

Cookies

Argo Networks uses cookies on this Web site for the purpose of maintaining a shoppers id allowing us to keep track of items in your shopping cart. "Cookies" are small pieces of information that are stored by your browser on your computer's hard drive.

Children's Privacy

Argo Networks has no intention of collecting personal information from children at this site.

Changes to the Policy

Our privacy practices, like the online medium itself, are subject to change. If we make any substantial changes, we will notify you by posting a prominent announcement at our site.

How to Contact Us

Should you have other questions or concerns about these privacy policies or wish to have your personally identifiable information deleted from our records, please send an email to sales@argo-networks.com or mail correspondence to Argo Networks.

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 1.27 ms / 1.27 ms Memory: 0.064 MB / 0.40 MB Application: afterLoad

Time: 19.12 ms / 20.40 ms Memory: 1.087 MB / 1.48 MB Application: afterInitialise

Time: 1.86 ms / 22.26 ms Memory: 0.148 MB / 1.63 MB Application: afterRoute

Time: 4.39 ms / 26.65 ms Memory: 0.055 MB / 1.69 MB Application: beforeRenderComponent com_virtuemart

Time: 2.71 ms / 29.36 ms Memory: 0.240 MB / 1.93 MB Application: Before JAccess::preloadComponents (all components)

Time: 1.14 ms / 30.50 ms Memory: 0.061 MB / 1.99 MB Application: After JAccess::preloadComponents (all components)

Time: 0.03 ms / 30.53 ms Memory: 0.000 MB / 1.99 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Time: 0.18 ms / 30.71 ms Memory: 0.009 MB / 2.00 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Time: 0.04 ms / 30.75 ms Memory: 0.001 MB / 2.00 MB Application: Before JAccess::getAssetRules (id:66 name:com_virtuemart)

Time: 0.02 ms / 30.78 ms Memory: 0.002 MB / 2.00 MB Application: After JAccess::getAssetRules (id:66 name:com_virtuemart)

Time: 88.73 ms / 119.50 ms Memory: 3.070 MB / 5.07 MB Application: afterRenderComponent com_virtuemart

Time: 5.33 ms / 124.84 ms Memory: 0.273 MB / 5.34 MB Application: afterDispatch

Time: 5.04 ms / 129.88 ms Memory: 0.217 MB / 5.56 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.64 ms / 130.53 ms Memory: 0.006 MB / 5.56 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.32 ms / 130.85 ms Memory: 0.000 MB / 5.56 MB Application: beforeRenderModule mod_custom (Toolbar)

Time: 0.12 ms / 130.96 ms Memory: 0.002 MB / 5.57 MB Application: afterRenderModule mod_custom (Toolbar)

Time: 0.19 ms / 131.15 ms Memory: 0.002 MB / 5.57 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 1.98 ms / 133.13 ms Memory: 0.056 MB / 5.62 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 3.08 ms / 136.21 ms Memory: 0.014 MB / 5.64 MB Application: beforeRenderModule mod_custom (Menu Icons)

Time: 0.15 ms / 136.36 ms Memory: 0.002 MB / 5.64 MB Application: afterRenderModule mod_custom (Menu Icons)

Time: 0.37 ms / 136.73 ms Memory: 0.000 MB / 5.64 MB Application: beforeRenderModule mod_custom (Footer)

Time: 0.10 ms / 136.83 ms Memory: 0.002 MB / 5.64 MB Application: afterRenderModule mod_custom (Footer)

Time: 2.20 ms / 139.02 ms Memory: 0.119 MB / 5.76 MB Application: afterRender

Database queries total: 43.34 ms

Memory Usage

Database Queries

63 Queries Logged 43.34 ms

13 duplicate found!

2 duplicates: #2 #37

2 duplicates: #23 #61

2 duplicates: #30 #45

3 duplicates: #31 #46 #50

2 duplicates: #32 #47

2 duplicates: #33 #34

Query Time: 3.47 ms Query memory: 0.004 MB Memory before query: 0.721 MB

DELETE 

  FROM `vlhvt_session`

  WHERE `time` < '1550265491'

Explain

EXPLAIN not possible on query: DELETE FROM `vlhvt_session` WHERE `time` < '1550265491'

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.09 ms
updating	0.51 ms
end	0.01 ms
query end	2.64 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.41 ms After last query: 0.33 ms Query memory: 0.027 MB Memory before query: 0.731 MB Rows returned: 0

Duplicate queries: #37

SELECT `data`

  FROM `vlhvt_session`

  WHERE `session_id` = '63fbor9s8fb74do8h1m2gnlrn2'

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.04 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:45

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

Query Time: 0.43 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 0.750 MB Rows returned: 0

SELECT `session_id`

  FROM `vlhvt_session`

  WHERE `session_id` = '63fbor9s8fb74do8h1m2gnlrn2' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.16 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 0.756 MB

INSERT INTO `vlhvt_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('63fbor9s8fb74do8h1m2gnlrn2', 1, '1550266391', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `vlhvt_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('63fbor9s8fb74do8h1m2gnlrn2', 1, '1550266391', 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
update	0.06 ms
end	0.01 ms
query end	0.89 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.67 ms After last query: 0.41 ms Query memory: 0.031 MB Memory before query: 0.782 MB Rows returned: 38

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

  FROM `vlhvt_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vlhvt_extensions	ref	extension	extension	82	const	38	Using index condition

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.32 ms After last query: 0.44 ms Query memory: 0.024 MB Memory before query: 0.814 MB Rows returned: 3

SELECT id, rules

  FROM `vlhvt_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.42 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 0.827 MB Rows returned: 1

SELECT b.id

  FROM vlhvt_usergroups AS a

  LEFT JOIN vlhvt_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.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 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.02 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 1.06 ms After last query: 0.20 ms Query memory: 0.032 MB Memory before query: 0.913 MB Rows returned: 67

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

  FROM vlhvt_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	vlhvt_extensions	ref	extension	extension	82	const	106	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 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.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.88 ms After last query: 3.24 ms Query memory: 0.053 MB Memory before query: 1.304 MB Rows returned: 30

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM vlhvt_menu AS m

  LEFT JOIN vlhvt_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	31	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	argo-networks.m.component_id	1	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.41 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
17	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
15	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
14	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
13	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
12	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
11	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
10	JApplicationSite->getMenu()	JROOT/plugins/system/directalias/directalias.php:63
9	plgSystemDirectalias->updateDirectRoutes()	JROOT/plugins/system/directalias/directalias.php:57
8	plgSystemDirectalias->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.51 ms After last query: 3.87 ms Query memory: 0.027 MB Memory before query: 1.651 MB Rows returned: 1

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

  FROM `vlhvt_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 1.60 ms After last query: 0.30 ms Query memory: 0.007 MB Memory before query: 1.644 MB

UPDATE `vlhvt_extensions`

  SET `params` = '{\"mediaversion\":\"06300c901703bc0b678d3689febc8c48\"}'

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.07 ms
updating	0.07 ms
end	0.01 ms
query end	1.24 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.56 ms After last query: 0.30 ms Query memory: 0.026 MB Memory before query: 1.670 MB Rows returned: 1

SELECT *

  FROM vlhvt_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.04 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

[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.19 ms Query memory: 0.022 MB Memory before query: 1.681 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM vlhvt_template_styles as s

  LEFT JOIN vlhvt_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	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	argo-networks.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.73 ms After last query: 1.37 ms Query memory: 0.025 MB Memory before query: 1.864 MB Rows returned: 1

SHOW TABLES LIKE "vlhvt_virtuemart_configs"

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.46 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.29 ms After last query: 0.09 ms Query memory: 0.030 MB Memory before query: 1.872 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.91 ms After last query: 0.48 ms Query memory: 0.033 MB Memory before query: 1.935 MB Rows returned: 38

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

  FROM `vlhvt_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_widgetkit','com_wrapper','com_xmap')

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.34 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
14	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
13	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
12	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
11	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
10	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1342
9	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
8	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1003
7	VmConfig::loadConfig()	JROOT/components/com_virtuemart/virtuemart.php:24
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.44 ms After last query: 3.46 ms Query memory: 0.033 MB Memory before query: 2.276 MB Rows returned: 1

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
13	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
12	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
11	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
10	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:132
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:83
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.25 ms After last query: 0.17 ms Query memory: 0.035 MB Memory before query: 2.309 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
14	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
13	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
12	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
11	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
10	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:132
9	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/controllers/cart.php:83
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.38 ms After last query: 1.26 ms Query memory: 0.042 MB Memory before query: 2.480 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v	system	PRIMARY,vendor_currency	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 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.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
15	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
14	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
13	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.27 ms After last query: 0.29 ms Query memory: 0.036 MB Memory before query: 2.528 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
14	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
13	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

[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.48 ms Query memory: 0.044 MB Memory before query: 2.573 MB Rows returned: 31

SHOW FULL COLUMNS  
  FROM `vlhvt_virtuemart_userfields`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.40 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.11 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
23	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:662
22	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
21	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:219
20	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434
19	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396
18	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602
17	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:52
16	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554
15	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:251
14	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
13	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.63 ms After last query: 0.23 ms Query memory: 0.051 MB Memory before query: 2.638 MB Rows returned: 15

SELECT * 
  FROM `vlhvt_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	vlhvt_virtuemart_userfields	ref	published,account	published	1	const	23	Using where; Using filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.24 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
16	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:503
15	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
14	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
13	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.28 ms After last query: 0.24 ms Query memory: 0.030 MB Memory before query: 2.709 MB Rows returned: 2

Duplicate queries: #61

SELECT `fieldtitle`, `fieldvalue` 
  FROM `vlhvt_virtuemart_userfield_values` 
  WHERE `virtuemart_userfield_id` = 10 
  ORDER BY `ordering`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
16	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1037
15	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:266
14	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
13	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.36 ms After last query: 0.40 ms Query memory: 0.035 MB Memory before query: 2.751 MB Rows returned: 2

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

 
  ORDER BY country_name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vlhvt_virtuemart_countries	ref	published	published	1	const	1	Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
18	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
17	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
16	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:848
15	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:266
14	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
13	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.60 ms After last query: 0.67 ms Query memory: 0.051 MB Memory before query: 2.800 MB Rows returned: 13

SELECT * 
  FROM `vlhvt_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	vlhvt_virtuemart_userfields	ref	published,shipment	shipment	1	const	14	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.16 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
16	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:509
15	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
14	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
13	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.41 ms After last query: 0.49 ms Query memory: 0.034 MB Memory before query: 2.958 MB Rows returned: 1

SELECT c.* 
  FROM vlhvt_virtuemart_calcs as c 
  LEFT JOIN vlhvt_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id 
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-02-15 21:33:11" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-02-15 21:33:11" )
 
  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	c	system	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	cs	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 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.05 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184
13	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.37 ms After last query: 0.11 ms Query memory: 0.034 MB Memory before query: 2.975 MB Rows returned: 0

SELECT * 
  FROM vlhvt_virtuemart_calcs  
  LEFT JOIN vlhvt_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-02-15 21:33:11" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-02-15 21:33:11" )
 
  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	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:726
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.36 ms After last query: 0.10 ms Query memory: 0.034 MB Memory before query: 2.985 MB Rows returned: 0

SELECT * 
  FROM vlhvt_virtuemart_calcs  
  LEFT JOIN vlhvt_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-02-15 21:33:11" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-02-15 21:33:11" )
 
  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	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:727
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.034 MB Memory before query: 2.995 MB Rows returned: 0

SELECT * 
  FROM vlhvt_virtuemart_calcs  
  LEFT JOIN vlhvt_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-02-15 21:33:11" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-02-15 21:33:11" )
 
  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	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:728
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:87
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.52 ms After last query: 43.12 ms Query memory: 0.031 MB Memory before query: 4.386 MB Rows returned: 1

Duplicate queries: #45

SELECT SQL_CALC_FOUND_ROWS i.*, l.shipment_name, l.shipment_desc 
  FROM `vlhvt_virtuemart_shipmentmethods` as i  
  LEFT JOIN `vlhvt_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`

 
 
  ORDER BY i.ordering DESC 
  LIMIT 0, 20

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 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.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
10	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:142
9	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/controllers/cart.php:92
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.15 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 4.399 MB Rows returned: 1

Duplicate queries: #46 #50

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.00 ms
Opening tables	0.00 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
10	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:142
9	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/controllers/cart.php:92
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.20 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 4.406 MB Rows returned: 0

Duplicate queries: #47

SELECT `virtuemart_shoppergroup_id` 
  FROM vlhvt_virtuemart_shipmentmethod_shoppergroups 
  WHERE `virtuemart_shipmentmethod_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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:151
9	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/controllers/cart.php:92
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.56 ms After last query: 0.12 ms Query memory: 0.033 MB Memory before query: 4.421 MB Rows returned: 1

Duplicate queries: #34

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vm	system	PRIMARY,shipment_jplugin_id	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	j	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 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.10 ms
preparing	0.01 ms
Unlocking tables	0.17 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:294
14	vmPlugin->selectedThisByMethodId()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:99
13	vmPSPlugin->onSelectCheck()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:495
12	plgVmShipmentWeight_countries->plgVmOnSelectCheckShipment()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:838
9	VirtueMartCart->setShipmentMethod()	JROOT/components/com_virtuemart/controllers/cart.php:98
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.47 ms After last query: 0.22 ms Query memory: 0.034 MB Memory before query: 4.434 MB Rows returned: 1

Duplicate queries: #33

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	vm	system	PRIMARY,shipment_jplugin_id	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	j	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.15 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:294
16	vmPlugin->selectedThisByMethodId()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:174
15	vmPSPlugin->onSelectedCalculatePrice()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:523
14	plgVmShipmentWeight_countries->plgVmOnSelectedCalculatePriceShipment()	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/calculationh.php:1457
11	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:908
10	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
9	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/controllers/cart.php:99
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.32 ms After last query: 0.14 ms Query memory: 0.036 MB Memory before query: 4.465 MB Rows returned: 1

SELECT `vlhvt_virtuemart_shipmentmethods`.* ,`vlhvt_virtuemart_shipmentmethods_en_gb`.*  
  FROM `vlhvt_virtuemart_shipmentmethods` 
  INNER JOIN `vlhvt_virtuemart_shipmentmethods_en_gb` using (`virtuemart_shipmentmethod_id`) 
  WHERE `vlhvt_virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` = "1"

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:591
16	vmPlugin->getVmPluginMethod()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:177
15	vmPSPlugin->onSelectedCalculatePrice()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:523
14	plgVmShipmentWeight_countries->plgVmOnSelectedCalculatePriceShipment()	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/calculationh.php:1457
11	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:908
10	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
9	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/controllers/cart.php:99
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 1.57 ms After last query: 0.41 ms Query memory: 0.008 MB Memory before query: 4.477 MB

UPDATE `vlhvt_session`

  SET `data` = ''
	, `time` = '1550266391'

  WHERE `session_id` = '63fbor9s8fb74do8h1m2gnlrn2'

Explain

EXPLAIN not possible on query: UPDATE `vlhvt_session` SET `data` = '' , `time` = '1550266391' WHERE `session_id` = '63fbor9s8fb74do8h1m2gnlrn2'

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.05 ms
updating	0.08 ms
end	0.01 ms
query end	1.26 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/session/storage/database.php:84
12	JSessionStorageDatabase->write()	Same as call in the line below.
11	session_write_close()	JROOT/components/com_virtuemart/helpers/cart.php:376
10	VirtueMartCart->setCartIntoSession()	JROOT/components/com_virtuemart/helpers/cart.php:955
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:130
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.33 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 4.486 MB Rows returned: 1

Duplicate queries: #2

SELECT `data`

  FROM `vlhvt_session`

  WHERE `session_id` = '63fbor9s8fb74do8h1m2gnlrn2'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.09 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/components/com_virtuemart/helpers/cart.php:377
10	VirtueMartCart->setCartIntoSession()	JROOT/components/com_virtuemart/helpers/cart.php:955
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:130
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.48 ms After last query: 0.20 ms Query memory: 0.040 MB Memory before query: 4.511 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 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.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:86
12	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1548
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1132
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:958
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:130
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

[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.56 ms Query memory: 0.027 MB Memory before query: 4.563 MB Rows returned: 2

SELECT `virtuemart_media_id` 
  FROM `vlhvt_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	vlhvt_virtuemart_vendor_medias	ref	virtuemart_vendor_id	virtuemart_vendor_id	4	const	1	Using where; Using filesort

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.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:97
12	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1548
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1132
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:958
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:130
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.29 ms After last query: 0.30 ms Query memory: 0.036 MB Memory before query: 4.656 MB Rows returned: 1

SELECT `vlhvt_virtuemart_medias`.*  
  FROM `vlhvt_virtuemart_medias`  
  WHERE `vlhvt_virtuemart_medias`.`virtuemart_media_id` = "34"

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
14	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:421
13	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1187
12	VmModel->addImages()	JROOT/components/com_virtuemart/helpers/cart.php:1549
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1132
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:958
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:130
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.72 ms After last query: 0.35 ms Query memory: 0.044 MB Memory before query: 4.670 MB Rows returned: 8

SELECT * 
  FROM `vlhvt_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	vlhvt_virtuemart_userfields	ref	published,account	published	1	const	23	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.05 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
13	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
12	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/user.php:786
11	VirtueMartModelUser->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:1157
10	VirtueMartCart->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:963
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:130
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

[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.68 ms Query memory: 0.039 MB Memory before query: 4.721 MB Rows returned: 2

SELECT * 
  FROM `vlhvt_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	vlhvt_virtuemart_userfields	ref	published,cart	cart	1	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.05 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
11	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
10	VirtueMartModelUserfields->getUserFields()	JROOT/components/com_virtuemart/views/cart/view.html.php:104
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 1.31 ms After last query: 0.68 ms Query memory: 0.040 MB Memory before query: 4.767 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 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.11 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
Creating tmp table	0.12 ms
Sorting result	0.03 ms
executing	0.01 ms
Sending data	0.38 ms
Creating sort index	0.04 ms
removing tmp table	0.08 ms
Creating sort index	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/paypal/paypal.php:311
13	plgVmPaymentPaypal->plgVmOnCheckoutAdvertise()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1653
10	VirtueMartCart->getCheckoutAdvertise()	JROOT/components/com_virtuemart/views/cart/view.html.php:124
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 1.10 ms After last query: 0.22 ms Query memory: 0.040 MB Memory before query: 4.781 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 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.03 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
Creating tmp table	0.08 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.03 ms
removing tmp table	0.06 ms
Creating sort index	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/klarna/klarna.php:1830
13	plgVmPaymentKlarna->plgVmOnCheckoutAdvertise()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1653
10	VirtueMartCart->getCheckoutAdvertise()	JROOT/components/com_virtuemart/views/cart/view.html.php:124
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.32 ms After last query: 0.26 ms Query memory: 0.032 MB Memory before query: 4.791 MB Rows returned: 1

Duplicate queries: #30

SELECT SQL_CALC_FOUND_ROWS i.*, l.shipment_name, l.shipment_desc 
  FROM `vlhvt_virtuemart_shipmentmethods` as i  
  LEFT JOIN `vlhvt_virtuemart_shipmentmethods_en_gb` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`

 
 
  ORDER BY i.ordering DESC 
  LIMIT 0, 20

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:142
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/views/cart/view.html.php:406
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:256
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:156
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 4.805 MB Rows returned: 1

Duplicate queries: #31 #50

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.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
init	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:142
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/views/cart/view.html.php:406
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:256
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:156
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.19 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 4.815 MB Rows returned: 0

Duplicate queries: #32

SELECT `virtuemart_shoppergroup_id` 
  FROM vlhvt_virtuemart_shipmentmethod_shoppergroups 
  WHERE `virtuemart_shipmentmethod_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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:151
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/components/com_virtuemart/views/cart/view.html.php:406
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:256
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:156
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.67 ms After last query: 0.19 ms Query memory: 0.041 MB Memory before query: 4.828 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	system	shipment_jplugin_id	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	s	system	virtuemart_shipmentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	SIMPLE	l	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	j	const	PRIMARY,element_clientid,element_folder_clientid	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.12 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526
15	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:119
14	vmPSPlugin->displayListFE()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:512
13	plgVmShipmentWeight_countries->plgVmDisplayListFEShipment()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/cart/view.html.php:272
10	VirtueMartViewCart->lSelectShipment()	JROOT/components/com_virtuemart/views/cart/view.html.php:156
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.38 ms After last query: 0.58 ms Query memory: 0.032 MB Memory before query: 4.859 MB Rows returned: 1

SELECT SQL_CALC_FOUND_ROWS i.*, l.payment_name, l.payment_desc 
  FROM `vlhvt_virtuemart_paymentmethods` as i  
  LEFT JOIN `vlhvt_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, 20

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	2	Using where; Using filesort
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	argo-networks.i.virtuemart_paymentmethod_id	1

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 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.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:134
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/components/com_virtuemart/views/cart/view.html.php:386
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:317
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:157
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 4.873 MB Rows returned: 1

Duplicate queries: #31 #46

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.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
init	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:134
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/components/com_virtuemart/views/cart/view.html.php:386
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:317
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:157
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

[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.09 ms Query memory: 0.027 MB Memory before query: 4.883 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:144
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/components/com_virtuemart/views/cart/view.html.php:386
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/components/com_virtuemart/views/cart/view.html.php:317
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:157
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 1.08 ms After last query: 0.13 ms Query memory: 0.040 MB Memory before query: 4.896 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 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.08 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.03 ms
removing tmp table	0.07 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:526
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/sofort/sofort.php:688
13	plgVmPaymentSofort->plgVmDisplayListFEPayment()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/cart/view.html.php:328
10	VirtueMartViewCart->lSelectPayment()	JROOT/components/com_virtuemart/views/cart/view.html.php:157
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:135
8	VirtueMartControllerCart->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:48

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

Query Time: 1.09 ms After last query: 0.14 ms Query memory: 0.040 MB Memory before query: 4.908 MB Rows returned: 0

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

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
Creating tmp table	0.08 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.03 ms
removing tmp table	0.06 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.22 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plug

Cart

Selected shipment

or change the selected shipment method

Terms of service

The Information We Collect

The Way We Use Information

Customization and Aggregate data

Our Commitment to Data Security

Cookies

Children's Privacy

Changes to the Policy

How to Contact Us

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

63 Queries Logged 43.34 ms

13 duplicate found!