Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1745582847,
                "last": 1745582847,
                "now": 1745582847
            },
            "token": "4Zp6oWZCpqqyizfWEpLfQOylLvBAwkZR"
        },
        "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 78.22 ms

1. Query Time: 1.03 ms Query memory: 0.050 MB Memory before query: 4.565 MB Rows returned: 15
   Duplicate queries: #6

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM lws_menu AS m
   
     LEFT JOIN lws_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	100.00	Using where

   Profile

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

   Call Stack

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

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

   ---

2. Query Time: 0.16 ms After last query: 1.64 ms Query memory: 0.027 MB Memory before query: 4.711 MB Rows returned: 7

   SELECT joomlatablename,tablepkID 
     FROM `lws_falang_tableinfo`

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

3. Query Time: 0.11 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 4.724 MB Rows returned: 6

   SELECT * 
     FROM lws_languages 
     ORDER BY ordering

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

4. Query Time: 0.69 ms After last query: 2.27 ms Query memory: 0.031 MB Memory before query: 4.896 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.12 ms After last query: 0.78 ms Query memory: 0.026 MB Memory before query: 4.955 MB Rows returned: 0
   Duplicate queries: #7

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

6. Query Time: 0.19 ms After last query: 8.70 ms Query memory: 0.047 MB Memory before query: 5.590 MB Rows returned: 15
   Duplicate queries: #1

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM lws_menu AS m
   
     LEFT JOIN lws_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.component_id	1	100.00	Using where

   Profile

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

   Call Stack

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

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

   ---

7. Query Time: 0.14 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 5.659 MB Rows returned: 0
   Duplicate queries: #5

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

8. Query Time: 0.88 ms After last query: 11.52 ms Query memory: 0.028 MB Memory before query: 6.543 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.13 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 6.567 MB Rows returned: 1

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

10. Query Time: 0.12 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 6.566 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profile

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

    Call Stack

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

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

    ---

11. Query Time: 0.15 ms After last query: 0.69 ms Query memory: 0.027 MB Memory before query: 6.594 MB Rows returned: 37

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

12. Query Time: 0.14 ms After last query: 0.20 ms Query memory: 0.028 MB Memory before query: 6.610 MB Rows returned: 37

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

13. Query Time: 1.22 ms After last query: 2.05 ms Query memory: 0.025 MB Memory before query: 6.904 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.14 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 6.913 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

15. Query Time: 1.30 ms After last query: 1.11 ms Query memory: 0.005 MB Memory before query: 6.981 MB

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

16. Query Time: 0.14 ms After last query: 33.22 ms Query memory: 0.024 MB Memory before query: 8.658 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php: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.14 ms After last query: 5.97 ms Query memory: 0.024 MB Memory before query: 8.731 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    13	JFalangDatabase->loadObjectList()	JROOT/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.10 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 8.738 MB Rows returned: 1

    SELECT id
    
      FROM lws_assets
    
      WHERE parent_id = 0

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
    15	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
    14	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
    11	vmAccess::manager()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:86
    10	shopFunctionsF::isFEmanager()	JROOT/components/com_virtuemart/views/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.09 ms After last query: 0.24 ms Query memory: 0.025 MB Memory before query: 8.749 MB Rows returned: 1
    Duplicate queries: #10

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
    15	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
    11	vmAccess::manager()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:86
    10	shopFunctionsF::isFEmanager()	JROOT/components/com_virtuemart/views/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.21 ms After last query: 23.61 ms Query memory: 0.025 MB Memory before query: 9.486 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_medias	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/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.14 ms After last query: 0.59 ms Query memory: 0.025 MB Memory before query: 9.508 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_medias	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/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.14 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 9.524 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_medias	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/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.14 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 9.539 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_medias	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    14	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
    12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
    11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
    10	VmModel->addImages()	JROOT/components/com_virtuemart/views/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.27 ms Query memory: 0.025 MB Memory before query: 9.554 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_medias	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

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

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    13	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:265
    12	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:48
    11	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:97
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/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.17 ms After last query: 1.20 ms Query memory: 0.025 MB Memory before query: 9.693 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    15	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    14	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    13	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    12	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
    11	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:113
    10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/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.16 ms After last query: 3.26 ms Query memory: 0.025 MB Memory before query: 9.994 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/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.15 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 10.023 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    22	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    21	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    20	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    19	JFalangDatabase->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
    18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
    17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
    15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/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: 1.12 ms After last query: 32.32 ms Query memory: 0.024 MB Memory before query: 10.450 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ps	NULL	system	virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	pp	NULL	system	product_price,virtuemart_product_id	NO INDEX KEY COULD BE USED	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	p	NULL	ref	PRIMARY,product_parent_id,product_special,published	product_special	2	const	16	78.57	Using index condition; Using where; Using temporary; Using filesort
    1	SIMPLE	pc	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	hkecc763_hkec.p.virtuemart_product_id	1	100.00	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.23 ms After last query: 0.27 ms Query memory: 0.065 MB Memory before query: 10.469 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.11 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 10.517 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	4	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.31 ms Query memory: 0.025 MB Memory before query: 10.543 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.42 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 10.558 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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.25 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 10.581 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.09 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 10.590 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.10 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 10.606 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_categories_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.13 ms After last query: 0.31 ms Query memory: 0.026 MB Memory before query: 10.635 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.12 ms After last query: 0.30 ms Query memory: 0.025 MB Memory before query: 10.651 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.09 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 10.664 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.53 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 10.671 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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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: 1.74 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 10.680 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.08 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 10.689 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.09 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 10.705 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_categories_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.15 ms After last query: 0.28 ms Query memory: 0.042 MB Memory before query: 10.733 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.10 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 10.761 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.08 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 10.774 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.91 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 10.780 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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.18 ms Query memory: 0.025 MB Memory before query: 10.790 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.12 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 10.799 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.12 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 10.815 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_categories_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.16 ms After last query: 0.34 ms Query memory: 0.042 MB Memory before query: 10.843 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.10 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 10.867 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.13 ms Query memory: 0.025 MB Memory before query: 10.880 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.35 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 10.886 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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.15 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 10.896 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.12 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 10.905 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.40 ms After last query: 0.23 ms Query memory: 0.026 MB Memory before query: 10.937 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

58. Query Time: 0.08 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 10.953 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

59. Query Time: 0.08 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 10.966 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

60. Query Time: 0.30 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 10.972 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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

61. Query Time: 0.67 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.982 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

62. Query Time: 0.09 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 10.991 MB Rows returned: 2

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php: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]

    ---

63. Query Time: 0.09 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 11.010 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_categories_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

64. Query Time: 0.15 ms After last query: 0.28 ms Query memory: 0.042 MB Memory before query: 11.038 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

65. Query Time: 0.12 ms After last query: 0.29 ms Query memory: 0.030 MB Memory before query: 11.066 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

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

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

67. Query Time: 0.87 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 11.091 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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

68. Query Time: 0.09 ms After last query: 0.16 ms Query memory: 0.025 MB Memory before query: 11.101 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

69. Query Time: 0.09 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.110 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

70. Query Time: 0.11 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 11.142 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` = "265"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

71. Query Time: 0.08 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 11.158 MB Rows returned: 3

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

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

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

73. Query Time: 1.22 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 11.178 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "265"  
      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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

74. Query Time: 0.11 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 11.187 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

75. Query Time: 0.11 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 11.196 MB Rows returned: 2

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    16	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php: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]

    ---

76. Query Time: 0.13 ms After last query: 0.28 ms Query memory: 0.026 MB Memory before query: 11.215 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_categories_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

77. Query Time: 0.15 ms After last query: 0.35 ms Query memory: 0.026 MB Memory before query: 11.242 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.11 ms After last query: 0.41 ms Query memory: 0.025 MB Memory before query: 11.259 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	2	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.09 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 11.273 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.34 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.279 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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.31 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 11.289 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.08 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 11.298 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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.13 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 11.330 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_products	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_products_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

84. Query Time: 0.08 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 11.346 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	3	100.00	Using index condition; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

85. Query Time: 0.08 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 11.359 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

86. Query Time: 1.19 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 11.365 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "234"  
      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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

87. Query Time: 0.10 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 11.375 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

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

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

89. Query Time: 0.15 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 11.417 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` = "260"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

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

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

91. Query Time: 0.09 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 11.447 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

92. Query Time: 0.31 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.453 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "260"  
      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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

93. Query Time: 0.11 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 11.463 MB Rows returned: 0

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

94. Query Time: 0.08 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.472 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

95. Query Time: 0.10 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 11.487 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	lws_virtuemart_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	lws_virtuemart_categories_vi_vn	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

96. Query Time: 0.11 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 11.515 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` = "261"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

97. Query Time: 0.11 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 11.533 MB Rows returned: 3

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

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

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

99. Query Time: 0.28 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 11.553 MB Rows returned: 0

    SELECT * 
      FROM `lws_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "261"  
      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-04-25 12:07:27" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-25 12:07:27" ) ) 
      ORDER BY `product_price` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    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]

    ---

100. Query Time: 0.10 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 11.563 MB Rows returned: 0