Joomla! Debug Console

Name: Cách điện thủy tinh 160kN
Brand: Cách điện thủy tinh,
Availability: InStock

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728673125,
                "last": 1728673125,
                "now": 1728673125
            },
            "token": "jIKGZe9IeLs45eHKLBxcGXTuZOYqpB0o"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 416,
        "vmlastvisitedcategoryid": 92,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"en-GB\",\"pricesCurrency\":\"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}",
        "vmlastvisitedproductids": [
            222
        ]
    }
}

Profile Information

Time

Memory

Time: 7.56 ms / 7.56 ms Memory: 0.541 MB / 0.93 MB Application: afterLoad

Time: 56.76 ms / 64.32 ms Memory: 4.233 MB / 5.16 MB Application: afterInitialise

Time: 20.02 ms / 84.34 ms Memory: 1.632 MB / 6.79 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.75 ms / 85.09 ms Memory: 0.033 MB / 6.83 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.08 ms / 85.17 ms Memory: 0.000 MB / 6.82 MB Application: Start JAccess::preload(components)

Time: 1.37 ms / 86.54 ms Memory: 0.222 MB / 7.04 MB Application: Finish JAccess::preload(components)

Time: 2.76 ms / 89.31 ms Memory: 0.142 MB / 7.19 MB Application: afterRoute

Time: 12.48 ms / 101.79 ms Memory: 0.300 MB / 7.49 MB Application: beforeRenderComponent com_virtuemart

Time: 39.18 ms / 140.97 ms Memory: 3.535 MB / 11.02 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.28 ms / 141.26 ms Memory: 0.019 MB / 11.04 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 61.24 ms / 202.50 ms Memory: 3.854 MB / 14.89 MB Application: beforeRenderModule mod_virtuemart_product (Related products)

Time: 4.98 ms / 207.48 ms Memory: 0.246 MB / 15.14 MB Application: afterRenderModule mod_virtuemart_product (Related products)

Time: 0.88 ms / 208.37 ms Memory: 0.000 MB / 15.12 MB Application: afterRenderComponent com_virtuemart

Time: 3.10 ms / 211.47 ms Memory: 0.169 MB / 15.29 MB Application: afterDispatch

Time: 22.99 ms / 234.46 ms Memory: 1.684 MB / 16.97 MB Application: beforeRenderModule mod_vina_treeview_menus (Menus trên Mobile)

Time: 3.76 ms / 238.22 ms Memory: 0.060 MB / 17.03 MB Application: afterRenderModule mod_vina_treeview_menus (Menus trên Mobile)

Time: 2.96 ms / 241.18 ms Memory: 0.037 MB / 17.07 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.83 ms / 242.01 ms Memory: 0.026 MB / 17.09 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.36 ms / 243.37 ms Memory: 0.009 MB / 17.10 MB Application: beforeRenderModule mod_menu (MENU TOP)

Time: 2.64 ms / 246.02 ms Memory: 0.040 MB / 17.14 MB Application: afterRenderModule mod_menu (MENU TOP)

Time: 0.40 ms / 246.42 ms Memory: 0.000 MB / 17.12 MB Application: beforeRenderModule mod_languages (Chuyển ngôn ngữ)

Time: 2.19 ms / 248.61 ms Memory: 0.078 MB / 17.20 MB Application: afterRenderModule mod_languages (Chuyển ngôn ngữ)

Time: 4.33 ms / 252.94 ms Memory: 0.350 MB / 17.55 MB Application: afterRender

Database queries total: 34.92 ms

Database Queries

66 Queries Logged 34.92 ms

6 duplicate found!

2 duplicates: #1 #6

2 duplicates: #10 #32

2 duplicates: #48 #52

Query Time: 1.66 ms Query memory: 0.050 MB Memory before query: 4.578 MB Rows returned: 15

Duplicate queries: #6

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

  LEFT JOIN lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 1.52 ms Query memory: 0.027 MB Memory before query: 4.725 MB Rows returned: 7

SELECT joomlatablename,tablepkID 
  FROM `lws_falang_tableinfo`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
24	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:142
23	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:60
22	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
21	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 4.737 MB Rows returned: 6

SELECT * 
  FROM lws_languages 
  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
24	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:317
23	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
22	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
21	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 1.99 ms Query memory: 0.031 MB Memory before query: 4.909 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `lws_languages`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
28	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
25	JTable->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:77
24	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:323
23	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
22	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
21	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.23 ms After last query: 0.71 ms Query memory: 0.026 MB Memory before query: 4.969 MB Rows returned: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=6
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(491,427,416,501,504,502,158,468,478,426,154,506,479,507,508)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
22	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
21	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
19	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 9.18 ms Query memory: 0.047 MB Memory before query: 5.817 MB Rows returned: 15

Duplicate queries: #1

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

  FROM lws_menu AS m

  LEFT JOIN lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:305
10	plgSystemFalangdriver->parseRule()	JROOT/libraries/cms/router/router.php:596
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:561
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:570
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:224
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.31 ms Query memory: 0.045 MB Memory before query: 5.887 MB Rows returned: 60

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM lws_falang_content AS falang_content

  WHERE falang_content.language_id=1
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(491,427,416,501,504,502,158,468,478,426,154,506,479,507,508)
   
  AND falang_content.reference_table='menu'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_table	302	const	64	5.16	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
14	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:305
10	plgSystemFalangdriver->parseRule()	JROOT/libraries/cms/router/router.php:596
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:561
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:570
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:224
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 10.46 ms Query memory: 0.028 MB Memory before query: 6.772 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `lws_assets`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
23	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.28 ms Query memory: 0.027 MB Memory before query: 6.796 MB Rows returned: 1

SELECT *

  FROM lws_assets

  WHERE `id` = '1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
21	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
20	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
19	JFalangDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Duplicate queries: #32

SELECT a.rules

  FROM lws_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
17	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 0.71 ms Query memory: 0.027 MB Memory before query: 6.823 MB Rows returned: 37

SELECT element

  FROM lws_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_extensions	NULL	ref	extension	extension	82	const	40	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
19	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:413
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.21 ms Query memory: 0.028 MB Memory before query: 6.838 MB Rows returned: 37

SELECT a.name, a.rules

  FROM lws_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_customfilters','com_easyjoomlabackup','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_multicategories','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	idx_asset_name	idx_asset_name	202	NULL	38	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
19	JFalangDatabase->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 2.06 ms Query memory: 0.025 MB Memory before query: 7.132 MB Rows returned: 1

SHOW TABLES LIKE "lws_virtuemart_configs"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
14	JFalangDatabase->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:511
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:810
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 7.142 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
15	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
14	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
13	JFalangDatabase->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:862
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.18 ms After last query: 2.18 ms Query memory: 0.023 MB Memory before query: 7.224 MB Rows returned: 1

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

  FROM `lws_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

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

Call Stack

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

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

Query Time: 4.72 ms After last query: 0.70 ms Query memory: 0.005 MB Memory before query: 7.216 MB

UPDATE `lws_extensions`

  SET `params` = '{\"mediaversion\":\"6503013b8d5b229ec0caa44b6014acfd\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	lws_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

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

Call Stack

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

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

Query Time: 1.62 ms After last query: 21.43 ms Query memory: 0.026 MB Memory before query: 9.486 MB Rows returned: 1

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	1	50.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
16	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1190
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
21	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
20	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
19	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1190
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 1.11 ms Query memory: 0.064 MB Memory before query: 9.661 MB Rows returned: 1

SELECT `lws_virtuemart_products`.* ,`lws_virtuemart_products_vi_vn`.*  
  FROM `lws_virtuemart_products` 
  INNER JOIN `lws_virtuemart_products_vi_vn` using (`virtuemart_product_id`) 
  WHERE `lws_virtuemart_products`.`virtuemart_product_id` = "222"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
15	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
14	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
13	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.87 ms Query memory: 0.024 MB Memory before query: 9.746 MB Rows returned: 2

SELECT `virtuemart_media_id` 
  FROM `lws_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "222" 
  ORDER BY `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	2	100.00	Using index condition; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
13	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.27 ms Query memory: 0.024 MB Memory before query: 9.772 MB Rows returned: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `lws_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "222"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
13	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 9.779 MB Rows returned: 0

SELECT * 
  FROM `lws_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "222"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-10-11 18:58:45" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-10-11 18:58:45" ) ) 
  ORDER BY `product_price` DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
14	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 9.801 MB Rows returned: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `lws_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "222"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
13	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `lws_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 222

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_product_categories	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
13	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.47 ms Query memory: 0.025 MB Memory before query: 9.924 MB Rows returned: 1

SELECT `lws_virtuemart_categories`.* ,`lws_virtuemart_categories_vi_vn`.*  
  FROM `lws_virtuemart_categories` 
  INNER JOIN `lws_virtuemart_categories_vi_vn` using (`virtuemart_category_id`) 
  WHERE `lws_virtuemart_categories`.`virtuemart_category_id` = "92"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 2.26 ms Query memory: 0.023 MB Memory before query: 10.111 MB Rows returned: 0

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
13	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2318
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 4.12 ms Query memory: 0.026 MB Memory before query: 10.468 MB Rows returned: 1

SELECT *  
  FROM `lws_virtuemart_currencies` AS c
			, `lws_virtuemart_vendors` AS v
			
  WHERE v.virtuemart_vendor_id = 1
			
  AND   v.vendor_currency = c.virtuemart_currency_id

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
17	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:265
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:48
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:97
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.94 ms Query memory: 0.026 MB Memory before query: 10.541 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
20	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
19	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
18	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
17	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:113
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 4.19 ms Query memory: 0.036 MB Memory before query: 10.918 MB Rows returned: 31

SHOW FULL COLUMNS  
  FROM `lws_virtuemart_userfields`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
25	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
24	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:647
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:204
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545
16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:248
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.17 ms After last query: 0.26 ms Query memory: 0.038 MB Memory before query: 10.957 MB Rows returned: 21

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_userfields	NULL	ref	published,account	account	1	const	22	89.29	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
19	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:598
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:489
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.33 ms Query memory: 0.027 MB Memory before query: 11.010 MB Rows returned: 1

SELECT id

  FROM lws_assets

  WHERE parent_id = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
21	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
20	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
17	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:763
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 11.022 MB Rows returned: 1

Duplicate queries: #10

SELECT a.rules

  FROM lws_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
21	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:652
20	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
17	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:763
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 0.23 ms Query memory: 0.027 MB Memory before query: 11.052 MB Rows returned: 2

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_userfield_values	NULL	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	100.00	Using index condition; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
18	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:995
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 1.50 ms Query memory: 0.096 MB Memory before query: 11.241 MB Rows returned: 246

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

 
  ORDER BY country_name ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
20	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:145
17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:824
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 2.81 ms Query memory: 0.034 MB Memory before query: 11.596 MB Rows returned: 14

SELECT * 
  FROM `lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	14	89.29	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
19	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:598
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:495
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.99 ms After last query: 2.04 ms Query memory: 0.028 MB Memory before query: 11.720 MB Rows returned: 7

SELECT * 
  FROM lws_virtuemart_calcs  
  LEFT JOIN lws_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-10-11 18:58:45" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-11 18:58:45" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_calc_shoppergroups	NULL	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	lws_virtuemart_calcs	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	6	26.53	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:179
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `lws_virtuemart_medias`.*  
  FROM `lws_virtuemart_medias`  
  WHERE `lws_virtuemart_medias`.`virtuemart_media_id` = "392"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:137
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.12 ms After last query: 0.50 ms Query memory: 0.025 MB Memory before query: 11.866 MB Rows returned: 1

SELECT `lws_virtuemart_medias`.*  
  FROM `lws_virtuemart_medias`  
  WHERE `lws_virtuemart_medias`.`virtuemart_media_id` = "393"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:137
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.11 ms After last query: 1.56 ms Query memory: 0.023 MB Memory before query: 12.005 MB Rows returned: 1

SELECT `virtuemart_media_id` 
  FROM `lws_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "92" 
  ORDER BY `ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_category_medias	NULL	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using index condition; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
12	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:73
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 12.012 MB Rows returned: 0

SELECT `category_child_id`
			
  FROM `lws_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 92

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_category_categories	NULL	ref	category_parent_id	category_parent_id	4	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
12	JFalangDatabase->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:667
11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:87
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.71 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 12.019 MB Rows returned: 1

SELECT count(lws_virtuemart_products.virtuemart_product_id) AS total
			
  FROM `lws_virtuemart_products`, `lws_virtuemart_product_categories`
			
  WHERE `lws_virtuemart_products`.`virtuemart_vendor_id` = "1"
			
  AND `lws_virtuemart_product_categories`.`virtuemart_category_id` = 92
			
  AND `lws_virtuemart_products`.`virtuemart_product_id` = `lws_virtuemart_product_categories`.`virtuemart_product_id`
			
  AND `lws_virtuemart_products`.`published` = "1"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_product_categories	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	62	10.00	Using where; Using index
1	SIMPLE	lws_virtuemart_products	NULL	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	hkecc763_hkec.lws_virtuemart_product_categories.virtuemart_product_id	1	77.17	Using where

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
14	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
13	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
12	JFalangDatabase->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:392
11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:94
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 12.028 MB Rows returned: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  lws_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 92

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
13	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:761
12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:696
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:97
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 12.038 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
14	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:761
13	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:768
12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:696
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:97
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 12.047 MB Rows returned: 1

SELECT `virtuemart_category_id`, `category_name`  
  FROM `lws_virtuemart_categories_vi_vn` as l 
  WHERE `virtuemart_category_id`= 91

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
12	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:732
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:97
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 12.055 MB Rows returned: 1

SELECT `virtuemart_category_id`, `category_name`  
  FROM `lws_virtuemart_categories_vi_vn` as l 
  WHERE `virtuemart_category_id`= 92

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
12	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:732
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:97
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 12.062 MB Rows returned: 1

SELECT `lws_virtuemart_medias`.*  
  FROM `lws_virtuemart_medias`  
  WHERE `lws_virtuemart_medias`.`virtuemart_media_id` = "237"

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 1.66 ms Query memory: 0.024 MB Memory before query: 12.108 MB Rows returned: 0

SELECT l.*
					
  FROM `lws_virtuemart_categories_vi_vn` as l
					
  INNER JOIN `lws_virtuemart_categories` as c using (`virtuemart_category_id`) 
  LEFT JOIN `lws_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 92  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY c.ordering,category_name ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cx	NULL	ref	category_parent_id,category_child_id	category_parent_id	4	const	1	100.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.cx.category_child_id	1	100.00	NULL
1	SIMPLE	c	NULL	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	hkecc763_hkec.cx.category_child_id	1	81.36	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:237
13	VirtueMartModelCategory::getChildCategoryListObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_virtuemart/models/category.php:161
10	VirtueMartModelCategory->getChildCategoryList()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:199
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.82 ms After last query: 23.83 ms Query memory: 0.025 MB Memory before query: 13.991 MB Rows returned: 2

Duplicate queries: #52

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.*  
  FROM   `lws_virtuemart_shipmentmethods` as i  
  LEFT JOIN `lws_virtuemart_shipmentmethods_vi_vn` as l using (`virtuemart_shipmentmethod_id`) 
 
  LEFT JOIN `lws_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	s	NULL	system	virtuemart_shipmentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	j	NULL	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	i	NULL	ref	PRIMARY,shipment_jplugin_id	shipment_jplugin_id	4	hkecc763_hkec.j.extension_id	2	50.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:528
13	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:425
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.41 ms After last query: 0.45 ms Query memory: 0.025 MB Memory before query: 14.016 MB Rows returned: 0

SELECT * 
  FROM lws_virtuemart_calcs  
  LEFT JOIN lws_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-10-11 18:58:45" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-11 18:58:45" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_calc_shoppergroups	NULL	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	lws_virtuemart_calcs	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	22.74	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
17	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1315
16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:710
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 14.027 MB Rows returned: 0

SELECT * 
  FROM lws_virtuemart_calcs  
  LEFT JOIN lws_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-10-11 18:58:45" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-11 18:58:45" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_calc_shoppergroups	NULL	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	lws_virtuemart_calcs	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	22.74	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
17	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1315
16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:711
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 14.037 MB Rows returned: 0

SELECT * 
  FROM lws_virtuemart_calcs  
  LEFT JOIN lws_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-10-11 18:58:45" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-11 18:58:45" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	lws_virtuemart_calc_shoppergroups	NULL	system	virtuemart_calc_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	lws_virtuemart_calcs	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	22.74	Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
17	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1315
16	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:712
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.19 ms Query memory: 0.029 MB Memory before query: 14.051 MB Rows returned: 2

Duplicate queries: #48

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.*  
  FROM   `lws_virtuemart_shipmentmethods` as i  
  LEFT JOIN `lws_virtuemart_shipmentmethods_vi_vn` as l using (`virtuemart_shipmentmethod_id`) 
 
  LEFT JOIN `lws_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	s	NULL	system	virtuemart_shipmentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	j	NULL	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	i	NULL	ref	PRIMARY,shipment_jplugin_id	shipment_jplugin_id	4	hkecc763_hkec.j.extension_id	2	50.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
24	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:528
23	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:848
22	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:203
21	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:539
20	plgVmShipmentWeight_countries->plgVmOnCheckAutomaticSelectedShipment()	JROOT/libraries/joomla/event/event.php:69
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
18	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1464
17	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1431
16	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:891
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.08 ms After last query: 0.33 ms Query memory: 0.028 MB Memory before query: 14.065 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.*  
  FROM   `lws_virtuemart_paymentmethods` as i  
  LEFT JOIN `lws_virtuemart_paymentmethods_vi_vn` as l using (`virtuemart_paymentmethod_id`) 
 
  LEFT JOIN `lws_extensions` as j 
  ON j.`extension_id` =  i.`payment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `lws_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	s	NULL	system	virtuemart_paymentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	j	NULL	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	i	NULL	ref	PRIMARY,payment_jplugin_id,virtuemart_vendor_id	payment_jplugin_id	4	hkecc763_hkec.j.extension_id	1	50.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
24	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:528
23	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:848
22	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:203
21	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmpayment/paypal/paypal.php:1489
20	plgVmPaymentPaypal->plgVmOnCheckAutomaticSelectedPayment()	JROOT/libraries/joomla/event/event.php:69
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
18	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1464
17	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1473
16	calculationHelper->calculatePaymentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:893
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 14.091 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.*  
  FROM   `lws_virtuemart_paymentmethods` as i  
  LEFT JOIN `lws_virtuemart_paymentmethods_vi_vn` as l using (`virtuemart_paymentmethod_id`) 
 
  LEFT JOIN `lws_extensions` as j 
  ON j.`extension_id` =  i.`payment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `lws_virtuemart_paymentmethod_shoppergroups` AS s 
  ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
  WHERE i.`published` = "1" 
  AND j.`element` = "standard"
	    						
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_paymentmethod_id` 
  ORDER BY i.`ordering`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	s	NULL	system	virtuemart_paymentmethod_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
1	SIMPLE	j	NULL	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	i	NULL	ref	PRIMARY,payment_jplugin_id,virtuemart_vendor_id	payment_jplugin_id	4	hkecc763_hkec.j.extension_id	1	50.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
26	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
24	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:528
23	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:848
22	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:203
21	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmpayment/standard/standard.php:377
20	plgVmPaymentStandard->plgVmOnCheckAutomaticSelectedPayment()	JROOT/libraries/joomla/event/event.php:69
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
18	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1464
17	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1473
16	calculationHelper->calculatePaymentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:893
15	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
14	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
13	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
12	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.47 ms After last query: 7.26 ms Query memory: 0.050 MB Memory before query: 14.860 MB Rows returned: 50

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

  FROM lws_modules AS m

VỀ CHÚNG TÔI:
1. Được thành lập từ năm 1999, qua hơn mười năm hoạt động Công ty Cổ phần Đầu tư và Thương mại - HK đã trở thành một đơn vị hàng đầu trong cung cấp vật tư thiết bị điện cho các công trình truyền tải điện, hệ thống đường dây và trạm biến áp đến cấp điện áp 500KV.
2. Sản phẩm vât tư, thiết bị
được Công ty lưa chọn đánh giá và cung cấp với chất lượng cao nhất của các công ty và các hãng uy tín trên thế giới như: Sứ cách điện thuỷ tinh, chuỗi cách điện polymer, Cáp quang OPGW (12 hoặc 24 sợi), phụ kiện đường dây và thiết bị đấu nối đến 500 Kv, Tủ trung thế, máy cắt Recloser, Cầu chì tự rơi, Chống sét van....
3. Đặc biệt Công ty có đội ngũ cán bộ chuyên gia, công nhân lành nghề, Đã tiến hành nghiên cứu và sản xuất ra một loạt sản phẩm dùng cho lưới điện hạ thế như: ghíp nhựa, kẹp xiết, kẹp treo, kẹp cực …. đạt chất lượng cao tương đương hàng các nước công nghiệp giá thành hợp lý, được các cơ quan có thẩm quyền cấp chứng chỉ, chứng nhận tiêu chuẩn chất lượng.

HOTLINE HỖ TRỢ:
1. Điện thoại: 04.3993.4411 / 0979.256699
2. Bản đồ đường đi:

Xem bản đồ phóng to tại đây

ABOUT US:
1. Established in 1999 but it took us more than one year to establish and retrain cadres, HK – Investment and Trade Joint Stock Company officially operated in 2001. Through more than 16 years of operation and development, our company has become a leading organization in the provision of supplies and equipment for public electric power transmission line system and substations up to 500kV voltage level.
2. Products and equipment
the company chooses to evaluate and supply the highest quality of the companies and reputable companies in the world such as glass insulators, polymer insulated chains, OPGW optical fiber (12 or 24 fibers), Line accessories and connectors to 500 Kv, Medium voltage switchgear, Recloser, Self-powered fuse, Lightning arresters.
3. Especially our company has a team of experienced professional staff, skilled workers have researched and produced products for low voltage grid such as plastic hinges, lock types. These are relatively high quality industrial products that are affordable and certified by state authorities.

SUPPORT HOTLINE:
1. Phone: 04.3993.4411 / 0979.256699
2. Map:

View zoom here

EQUIPMENT LINES

Accessories Line

Telecommunications equipment

APTOMAT

EQUIPMENT MANUFACTURER

DANH MỤC SẢN PHẨM

Cách điện thủy tinh 160kN

Related Products

Support online

Company Headquarters

Representative office in Ho Chi Minh City

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

66 Queries Logged 34.92 ms

6 duplicate found!

Mã hiệu	U160BS	U160BL	U160BSP	U160BLP
Tải trọng phá hủy cơ – điện nhỏ nhất (KN)	160	160	160	160
Đường kính bát sứ (mm)	280	280	320	320
Chiều cao bát sứ (mm)	146	170	146	170
Chiều dài dòng rò (mm)	385	385	545	545
Kích thước ty sứ (theo tiêu chuẩn IEC 60120) (mm)	20	20	20	20
Điện áp đánh thủng cách điện (kV)	130	130	130	130
Điện áp phóng điện khô 1 phút (kV)	75	75	90	90
Điện áp phóng điện ướt 1 phút (kV)	45	45	55	55
Điện áp phóng điện xung sét (kV)	110	110	140	140
Khối lượng (kg)	6.13	6.13	8.28	8.28