Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1752685282,
                "last": 1752685282,
                "now": 1752685282
            },
            "token": "x902JPUFtEqdFHER0uYBQ11M8j5l87ek"
        },
        "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
    }
}

Time

Memory

303 Queries Logged 62.23 ms

1. Query Time: 1.76 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	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	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.10 ms After last query: 0.99 ms Query memory: 0.027 MB Memory before query: 4.708 MB Rows returned: 7

   SELECT joomlatablename,tablepkID 
     FROM `lws_falang_tableinfo`

   Explain

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

   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.34 ms After last query: 0.07 ms Query memory: 0.029 MB Memory before query: 4.721 MB Rows returned: 6

   SELECT * 
     FROM lws_languages 
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	lws_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	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.44 ms After last query: 1.31 ms Query memory: 0.031 MB Memory before query: 4.893 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.84 ms After last query: 0.54 ms Query memory: 0.026 MB Memory before query: 4.952 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	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	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.41 ms After last query: 5.47 ms Query memory: 0.047 MB Memory before query: 5.587 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	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	Using index condition; Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	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.85 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 5.656 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	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	falang_content	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	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.45 ms After last query: 6.76 ms Query memory: 0.028 MB Memory before query: 6.541 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.49 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 6.565 MB Rows returned: 1

   SELECT *
   
     FROM lws_assets
   
     WHERE `id` = '1'

   Explain

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

   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.40 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 6.563 MB Rows returned: 1
    Duplicate queries: #19

    SELECT a.rules
    
      FROM lws_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	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: 1.29 ms After last query: 0.44 ms Query memory: 0.027 MB Memory before query: 6.592 MB Rows returned: 37

    SELECT element
    
      FROM lws_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_extensions	ref	extension	extension	82	const	40	Using index condition; 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.83 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 6.607 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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	38	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.38 ms After last query: 1.25 ms Query memory: 0.025 MB Memory before query: 6.901 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.11 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 6.910 MB Rows returned: 1

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

    Explain

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

    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.86 ms After last query: 0.79 ms Query memory: 0.005 MB Memory before query: 6.978 MB

    UPDATE `lws_extensions`
    
      SET `params` = '{\"mediaversion\":\"4274b34eeb0f2b65315b885bd9d6f27c\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    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.96 ms After last query: 10.39 ms Query memory: 0.024 MB Memory before query: 8.655 MB Rows returned: 0

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

    Explain

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

    Profile

    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/vendor.php:86
    10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:39
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.45 ms After last query: 0.88 ms Query memory: 0.024 MB Memory before query: 8.728 MB Rows returned: 0

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

    Explain

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

    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/vendor.php:97
    10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:39
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.44 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 8.735 MB Rows returned: 1

    SELECT id
    
      FROM lws_assets
    
      WHERE parent_id = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_assets	ref	idx_parent_id	idx_parent_id	4	const	1	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/virtuemart/view.html.php:62
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.18 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 8.746 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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	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/virtuemart/view.html.php:62
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.19 ms After last query: 5.41 ms Query memory: 0.025 MB Memory before query: 9.483 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:80
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.13 ms After last query: 0.36 ms Query memory: 0.025 MB Memory before query: 9.505 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:80
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.12 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 9.521 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:80
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.12 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 9.536 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:80
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.13 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 9.552 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:80
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.20 ms After last query: 0.60 ms Query memory: 0.025 MB Memory before query: 9.619 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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	v	system	PRIMARY,vendor_currency	NO INDEX KEY COULD BE USED	NULL	NULL	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    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/virtuemart/view.html.php:85
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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: 0.13 ms After last query: 0.73 ms Query memory: 0.025 MB Memory before query: 9.691 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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_currencies	const	PRIMARY	PRIMARY	4	const	1

    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/virtuemart/view.html.php:85
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.19 ms After last query: 1.86 ms Query memory: 0.025 MB Memory before query: 9.991 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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:170
    11	CurrencyDisplay->setPriceArray()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:131
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:85
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.11 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 10.020 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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    21	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    20	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    19	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
    17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:170
    11	CurrencyDisplay->setPriceArray()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:131
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:85
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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: 4.53 ms After last query: 5.78 ms Query memory: 0.024 MB Memory before query: 10.447 MB Rows returned: 15

    SELECT  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_prices` as pp 
      ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` 
     
      WHERE ( ((p.`product_parent_id` = "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0")  
      AND  ((p.`product_parent_id` > "0" 
      AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0")  
      AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
      AND p.`product_special`="1"  
      AND  p.`published`="1" ) 
    
      group by p.`virtuemart_product_id` 
    
      ORDER BY RAND() 
      LIMIT 0, 15

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ps	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found; Using temporary; Using filesort
    1	SIMPLE	pp	system	product_price,virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	p	ALL	product_parent_id,product_special,published	NO INDEX KEY COULD BE USED	NULL	NULL	56	Using where
    1	SIMPLE	pc	ref	virtuemart_product_id	virtuemart_product_id	4	hkecc763_hkec.p.virtuemart_product_id	1	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
    13	JFalangDatabase->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:838
    12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:702
    11	VirtueMartModelProduct->sortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:1512
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.86 ms After last query: 0.38 ms Query memory: 0.026 MB Memory before query: 10.466 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.67 ms After last query: 0.58 ms Query memory: 0.025 MB Memory before query: 10.495 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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: 0.35 ms Query memory: 0.025 MB Memory before query: 10.521 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.21 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 10.536 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "255"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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.66 ms After last query: 0.36 ms Query memory: 0.025 MB Memory before query: 10.559 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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: 0.15 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 10.568 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

36. Query Time: 0.28 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 10.584 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` = "97"

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

37. Query Time: 0.47 ms After last query: 0.33 ms Query memory: 0.065 MB Memory before query: 10.613 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

38. Query Time: 0.18 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 10.649 MB Rows returned: 4

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	4	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

39. Query Time: 0.10 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 10.662 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

40. Query Time: 0.19 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 10.668 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "226"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

41. Query Time: 0.10 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.678 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

42. Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 10.687 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

43. Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 10.702 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` = "93"

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

44. Query Time: 0.32 ms After last query: 0.31 ms Query memory: 0.042 MB Memory before query: 10.730 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

45. Query Time: 0.19 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 10.749 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

46. Query Time: 0.11 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 10.763 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

47. Query Time: 0.19 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 10.769 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "240"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

48. Query Time: 0.10 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.779 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

49. Query Time: 0.15 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 10.788 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

50. Query Time: 0.22 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 10.803 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` = "108"

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

51. Query Time: 0.24 ms After last query: 0.29 ms Query memory: 0.026 MB Memory before query: 10.831 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

52. Query Time: 0.13 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 10.847 MB Rows returned: 6

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	6	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

53. Query Time: 0.08 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 10.861 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

54. Query Time: 0.13 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 10.867 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "248"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

55. Query Time: 0.09 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 10.877 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

56. Query Time: 0.10 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 10.885 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

57. Query Time: 0.15 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 10.901 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` = "110"

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

58. Query Time: 0.28 ms After last query: 0.18 ms Query memory: 0.065 MB Memory before query: 10.929 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

59. Query Time: 0.12 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 10.962 MB Rows returned: 2

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

    Explain

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

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

60. Query Time: 0.11 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 10.975 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

61. Query Time: 0.12 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 10.981 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "222"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

62. Query Time: 0.07 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 10.991 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

63. Query Time: 0.11 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 11.000 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

64. Query Time: 0.14 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 11.015 MB Rows returned: 1

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

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

65. Query Time: 0.19 ms After last query: 0.20 ms Query memory: 0.031 MB Memory before query: 11.053 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

66. Query Time: 0.12 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 11.075 MB Rows returned: 2

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

    Explain

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

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

67. Query Time: 0.07 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.089 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

68. Query Time: 0.12 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 11.095 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "263"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

69. Query Time: 0.08 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 11.105 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

70. Query Time: 0.10 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 11.114 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

71. Query Time: 0.25 ms After last query: 0.17 ms Query memory: 0.042 MB Memory before query: 11.146 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

72. Query Time: 0.14 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 11.173 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

73. Query Time: 0.07 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 11.186 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

74. Query Time: 0.12 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 11.193 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "245"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

75. Query Time: 0.06 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 11.202 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

76. Query Time: 0.09 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 11.211 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

77. Query Time: 0.24 ms After last query: 0.17 ms Query memory: 0.042 MB Memory before query: 11.243 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

78. Query Time: 0.10 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 11.275 MB Rows returned: 2

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

    Explain

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

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

79. Query Time: 0.07 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.288 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

80. Query Time: 0.10 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 11.294 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "262"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

81. Query Time: 0.06 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 11.304 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

82. Query Time: 0.09 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 11.313 MB Rows returned: 4

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

83. Query Time: 0.15 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 11.330 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` = "107"

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

84. Query Time: 0.13 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 11.347 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` = "109"

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

85. Query Time: 0.17 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 11.376 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

86. Query Time: 0.15 ms After last query: 0.32 ms Query memory: 0.025 MB Memory before query: 11.392 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

87. Query Time: 0.06 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 11.406 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

88. Query Time: 0.11 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 11.412 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "250"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

89. Query Time: 0.07 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 11.422 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

90. Query Time: 0.09 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 11.431 MB Rows returned: 2

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

91. Query Time: 0.14 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 11.450 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` = "118"

    Explain

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

    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/plugins/system/falangdriver/falang_database.php:408
    18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    16	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

92. Query Time: 0.20 ms After last query: 0.22 ms Query memory: 0.042 MB Memory before query: 11.478 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

93. Query Time: 0.11 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 11.502 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

94. Query Time: 0.06 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 11.516 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

95. Query Time: 0.11 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.522 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "237"  
      AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
      AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-07-16 17:01:22" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-07-16 17:01:22" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

    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:451
    16	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
    15	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
    14	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

96. Query Time: 0.06 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 11.532 MB Rows returned: 0

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

    Explain

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

    Profile

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

97. Query Time: 0.09 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 11.540 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    15	JFalangDatabase->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
    14	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

98. Query Time: 0.16 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 11.572 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    17	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    16	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    15	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

99. Query Time: 0.14 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 11.588 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	lws_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	Using where; Using filesort

    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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
    13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
    12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
    11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
    10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
    9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
    8	VirtueMartControllerVirtuemart->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]

    ---

100. Query Time: 0.06 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 11.601 MB Rows returned: 0

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

     Explain

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

     Profile

     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/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
     14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
     13	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
     12	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1589
     11	VirtueMartModelProduct->getProducts()	JROOT/administrator/components/com_virtuemart/models/product.php:1520
     10	VirtueMartModelProduct->getProductListing()	JROOT/components/com_virtuemart/views/virtuemart/view.html.php:93
     9	VirtueMartViewVirtueMart->display()	JROOT/components/com_virtuemart/controllers/virtuemart.php:52
     8	VirtueMartControllerVirtuemart->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]

     ---

101. Query Time: 0.12 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 11.609 MB Rows returned: 0