{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728665728,
                "last": 1728665728,
                "now": 1728665728
            },
            "token": "3D0R5iotZf9u5vi0QS8Q27ZQ3HbYWJa8"
        },
        "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,
        "vmlastproductordering": "mf_name",
        "vmlastvisitedcategoryid": 115,
        "vmlastvisitedmanuid": -1
    }
}

Time

Memory

38 Queries Logged 13.21 ms

1. Query Time: 0.84 ms Query memory: 0.050 MB Memory before query: 4.562 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]

   ---

2. Query Time: 0.20 ms After last query: 1.25 ms Query memory: 0.027 MB Memory before query: 4.709 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]

   ---

3. Query Time: 0.07 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 4.722 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]

   ---

4. Query Time: 0.62 ms After last query: 1.75 ms Query memory: 0.031 MB Memory before query: 4.894 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]

   ---

5. Query Time: 0.10 ms After last query: 0.67 ms Query memory: 0.026 MB Memory before query: 4.953 MB Rows returned: 0
   Duplicate queries: #7

   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]

   ---

6. Query Time: 0.12 ms After last query: 7.18 ms Query memory: 0.047 MB Memory before query: 5.588 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]

   ---

7. Query Time: 0.12 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 5.657 MB Rows returned: 0
   Duplicate queries: #5

   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
   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]

   ---

8. Query Time: 0.44 ms After last query: 9.30 ms Query memory: 0.028 MB Memory before query: 6.542 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]

   ---

9. Query Time: 0.08 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 6.566 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]

   ---

10. Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 6.565 MB Rows returned: 1
    Duplicate queries: #17

    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]

    ---

11. Query Time: 0.08 ms After last query: 0.59 ms Query memory: 0.027 MB Memory before query: 6.593 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]

    ---

12. Query Time: 0.08 ms After last query: 0.19 ms Query memory: 0.028 MB Memory before query: 6.609 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]

    ---

13. Query Time: 0.62 ms After last query: 1.80 ms Query memory: 0.025 MB Memory before query: 6.902 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]

    ---

14. Query Time: 0.07 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 6.912 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]

    ---

15. Query Time: 0.76 ms After last query: 0.99 ms Query memory: 0.005 MB Memory before query: 6.979 MB

    UPDATE `lws_extensions`
    
      SET `params` = '{\"mediaversion\":\"2fae5ad3631c6870db36714a79402937\"}'
    
      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]

    ---

16. Query Time: 0.10 ms After last query: 16.04 ms Query memory: 0.025 MB Memory before query: 8.899 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
    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:170
    15	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
    14	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
    11	vmAccess::manager()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:86
    10	shopFunctionsF::isFEmanager()	JROOT/components/com_virtuemart/views/category/view.html.php:58
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.10 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 8.911 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
    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:170
    15	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
    11	vmAccess::manager()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:86
    10	shopFunctionsF::isFEmanager()	JROOT/components/com_virtuemart/views/category/view.html.php:58
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.90 ms After last query: 5.63 ms Query memory: 0.025 MB Memory before query: 9.463 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` = "115"

    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
    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:426
    12	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:70
    10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.52 ms After last query: 0.88 ms Query memory: 0.023 MB Memory before query: 9.532 MB Rows returned: 0

    SELECT `virtuemart_media_id` 
      FROM `lws_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "115" 
      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/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.28 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 9.539 MB Rows returned: 0

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

    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/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.45 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 9.546 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` = 115
    			
      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/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.08 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 9.555 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`= 115

    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/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.09 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 9.565 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`= 114

    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/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.08 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 9.574 MB Rows returned: 1

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

    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/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.18 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 9.582 MB Rows returned: 1

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

    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/category/view.html.php:111
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 1.49 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 9.586 MB Rows returned: 0

    SELECT c.* 
      FROM lws_virtuemart_customs  as c 
      INNER JOIN lws_virtuemart_product_customfields as pc 
      on (c.virtuemart_custom_id=pc.virtuemart_custom_id)
    
      INNER JOIN lws_virtuemart_product_categories as cat 
      ON (pc.virtuemart_product_id=cat.virtuemart_product_id) 
      WHERE virtuemart_category_id="115" 
      and searchable="1" 
      and (field_type="S" or field_type="P") 
      GROUP BY c.virtuemart_custom_id

    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
    14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    11	JFalangDatabase->loadObjectList()	JROOT/components/com_virtuemart/views/category/view.html.php:451
    10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:131
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.08 ms After last query: 4.24 ms Query memory: 0.025 MB Memory before query: 10.024 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
    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/administrator/components/com_virtuemart/models/shoppergroup.php:102
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:404
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:196
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.07 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 10.052 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
    24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    18	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
    16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:404
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:196
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 1.87 ms After last query: 1.07 ms Query memory: 0.023 MB Memory before query: 10.108 MB Rows returned: 0
    Duplicate queries: #31

    SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
      FROM `lws_virtuemart_products` as p  
     
      LEFT JOIN `lws_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `lws_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `lws_virtuemart_product_manufacturers` 
      ON p.`virtuemart_product_id` = `lws_virtuemart_product_manufacturers`.`virtuemart_product_id`  
    
      LEFT JOIN `lws_virtuemart_manufacturers_vi_vn` as m 
      ON m.`virtuemart_manufacturer_id` = `lws_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` 
     
      WHERE ( `pc`.`virtuemart_category_id` = 115 
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
     
      group by p.`virtuemart_product_id` 
     
      ORDER BY `mf_name` ASC, `virtuemart_product_id` ASC 
      LIMIT 0, 12

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ps	NULL	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	lws_virtuemart_product_manufacturers	NULL	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	m	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	pc	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	62	10.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	hkecc763_hkec.pc.virtuemart_product_id	1	78.57	Using where

    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/vmmodel.php:838
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:702
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:196
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.16 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 10.116 MB Rows returned: 1

    SELECT FOUND_ROWS()

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

    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/helpers/vmmodel.php:853
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:702
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:196
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.07 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 10.125 MB Rows returned: 0
    Duplicate queries: #29

    SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
      FROM `lws_virtuemart_products` as p  
     
      LEFT JOIN `lws_virtuemart_product_shoppergroups` as ps 
      ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
     
      LEFT JOIN `lws_virtuemart_product_categories` as pc 
      ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
     
      LEFT JOIN `lws_virtuemart_product_manufacturers` 
      ON p.`virtuemart_product_id` = `lws_virtuemart_product_manufacturers`.`virtuemart_product_id`  
    
      LEFT JOIN `lws_virtuemart_manufacturers_vi_vn` as m 
      ON m.`virtuemart_manufacturer_id` = `lws_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` 
     
      WHERE ( `pc`.`virtuemart_category_id` = 115 
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND  p.`published`="1" ) 
     
      group by p.`virtuemart_product_id` 
     
      ORDER BY `mf_name` ASC, `virtuemart_product_id` ASC 
      LIMIT 0, 12

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ps	NULL	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	lws_virtuemart_product_manufacturers	NULL	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	m	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	pc	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	62	10.00	Using where; Using index; Using temporary; Using filesort
    1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	hkecc763_hkec.pc.virtuemart_product_id	1	78.57	Using where

    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/vmmodel.php:866
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:702
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:196
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.11 ms After last query: 3.51 ms Query memory: 0.025 MB Memory before query: 10.367 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
    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/vendor.php:265
    12	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:48
    11	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:97
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:207
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.10 ms After last query: 0.99 ms Query memory: 0.026 MB Memory before query: 10.444 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
    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/helpers/vmmodel.php:907
    11	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:113
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:207
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.10 ms After last query: 1.24 ms Query memory: 0.024 MB Memory before query: 10.482 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` = 115  
      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/category/view.html.php:266
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 1.32 ms After last query: 7.71 ms Query memory: 0.021 MB Memory before query: 11.018 MB Rows returned: 1

    SELECT language,id
    
      FROM `lws_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	18	1.52	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    11	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    9	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.67 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 11.029 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)
       
      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	falangContent	310	const,const,const	1	10.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
    12	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    11	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    9	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.13 ms After last query: 31.13 ms Query memory: 0.024 MB Memory before query: 12.440 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `lws_menu` AS `c`
    
      INNER JOIN `lws_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `lws_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `lws_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 416

    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/libraries/cms/language/associations.php:101
    13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
    12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:62
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---