Joomla! Debug Console

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

Time

Memory

25 Queries Logged 21.19 ms

1. Query Time: 0.85 ms Query memory: 0.050 MB Memory before query: 4.564 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.14 ms After last query: 1.53 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.09 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 4.723 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.63 ms After last query: 2.10 ms Query memory: 0.031 MB Memory before query: 4.895 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.14 ms After last query: 0.80 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.16 ms After last query: 8.54 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.28 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: 2.14 ms After last query: 2.04 ms Query memory: 0.005 MB Memory before query: 5.703 MB

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

   ---

9. Query Time: 4.05 ms After last query: 72.32 ms Query memory: 0.027 MB Memory before query: 6.428 MB Rows returned: 4

   SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
   			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
   			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
   			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
   
     FROM lws_categories as c
   
     LEFT JOIN  (SELECT cat.id as id 
     FROM lws_categories AS cat JOIN lws_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt 
     WHERE parent.extension = 'com_content' 
     AND parent.published != 1 
     GROUP BY cat.id) AS badcats 
     ON badcats.id = c.id
   
     LEFT JOIN lws_categories AS s 
     ON (s.lft < c.lft 
     AND s.rgt > c.rgt 
     AND c.language in ('vi-VN','*')) OR (s.lft >= c.lft 
     AND s.rgt <= c.rgt)
   
     LEFT JOIN `lws_content` AS i 
     ON i.`catid` = c.id 
     AND i.state = 1 
     AND (i.language = '*' OR i.language = 'vi-VN')
   
     WHERE (c.extension='com_content' OR c.extension='system') 
     AND c.access IN (1,1,5) 
     AND c.published = 1 
     AND badcats.id is null 
     AND s.id=86
   
     GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
   			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
   			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
   			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
   
     ORDER BY c.lft

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
   1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	26	29.06	Using where
   1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Not exists; Using join buffer (Block Nested Loop)
   1	PRIMARY	i	NULL	ref	idx_state,idx_catid,idx_language	idx_catid	4	hkecc763_hkec.c.id	22	100.00	Using where
   2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
   2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	26	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

   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/libraries/legacy/categories/categories.php:309
   15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
   14	JCategories->get()	JROOT/components/com_content/models/categories.php:115
   13	ContentModelCategories->getItems()	JROOT/libraries/legacy/view/legacy.php:408
   12	JViewLegacy->get()	JROOT/libraries/legacy/view/categories.php:55
   11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
   10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
   9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
   7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
   6	require_once JROOT/components/com_content/content.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]

   ---

10. Query Time: 2.62 ms After last query: 30.90 ms Query memory: 0.028 MB Memory before query: 7.041 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM lws_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM lws_categories AS cat JOIN lws_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN lws_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('vi-VN','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=87
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	26	29.06	Using where
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Not exists; Using join buffer (Block Nested Loop)
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	26	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    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/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/components/com_content/views/categories/tmpl/default_items.php:30
    16	include JROOT/components/com_content/views/categories/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    15	JViewLegacy->loadTemplate()	JROOT/components/com_content/views/categories/tmpl/default.php:29
    14	include JROOT/components/com_content/views/categories/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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]

    ---

11. Query Time: 1.93 ms After last query: 1.29 ms Query memory: 0.028 MB Memory before query: 7.099 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM lws_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM lws_categories AS cat JOIN lws_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN lws_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('vi-VN','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=88
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	26	29.06	Using where
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	11.11	Using where; Not exists; Using join buffer (Block Nested Loop)
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	26	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    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/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/components/com_content/views/categories/tmpl/default_items.php:30
    16	include JROOT/components/com_content/views/categories/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
    15	JViewLegacy->loadTemplate()	JROOT/components/com_content/views/categories/tmpl/default.php:29
    14	include JROOT/components/com_content/views/categories/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.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]

    ---

12. Query Time: 0.16 ms After last query: 1.53 ms Query memory: 0.021 MB Memory before query: 7.053 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

13. Query Time: 0.10 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 7.063 MB Rows returned: 0

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM lws_falang_content AS falang_content
    
      WHERE falang_content.language_id=6
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(491)
       
      AND falang_content.reference_table='menu'

    Explain

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

    Profile

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

    Call Stack

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

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

    ---

14. Query Time: 0.47 ms After last query: 1.03 ms Query memory: 0.021 MB Memory before query: 7.110 MB Rows returned: 0

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

    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
    13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    10	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.46 ms After last query: 0.97 ms Query memory: 0.022 MB Memory before query: 7.138 MB Rows returned: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `lws_categories` AS `c`
    
      INNER JOIN `lws_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_categories.item'
    
      INNER JOIN `lws_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `lws_categories` AS `c2` 
      ON a2.id = c2.`id` 
      AND c2.extension = 'com_content'
    
      WHERE c.id = 86 
      AND c.extension = 'com_content'

    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
    15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    12	JFalangDatabase->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    11	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:102
    10	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:43
    9	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:58
    8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:729
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.94 ms After last query: 31.07 ms Query memory: 0.033 MB Memory before query: 9.238 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
    36	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    35	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    34	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    33	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    31	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    30	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    29	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    28	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    27	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    26	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    25	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
    24	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
    23	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
    22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
    21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
    13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
    12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
    11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
    10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
    9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.12 ms After last query: 0.38 ms Query memory: 0.032 MB Memory before query: 9.268 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
    35	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    34	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    33	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    32	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    31	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    30	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    29	JFalangDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    28	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    27	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    26	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    25	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
    24	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
    23	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
    22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
    21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
    13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
    12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
    11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
    10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
    9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.10 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 9.284 MB Rows returned: 1

    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
    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/plugins/system/falangdriver/falang_database.php:170
    27	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    26	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    25	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
    24	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
    23	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
    22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
    21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
    13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
    12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
    11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
    10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
    9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.58 ms After last query: 1.11 ms Query memory: 0.032 MB Memory before query: 9.317 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
    33	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    32	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    31	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    30	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:170
    29	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    28	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    27	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    26	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    25	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
    24	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
    23	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
    22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
    21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
    13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
    12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
    11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
    10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
    9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.84 ms After last query: 0.37 ms Query memory: 0.033 MB Memory before query: 9.338 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
    33	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    32	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    31	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    30	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:451
    29	JFalangDatabase->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    28	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    27	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    26	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    25	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
    24	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
    23	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
    22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
    21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
    13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
    12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
    11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
    10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
    9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.81 ms After last query: 2.89 ms Query memory: 0.029 MB Memory before query: 9.636 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
    30	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    29	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    27	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    26	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    25	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
    24	JFalangDatabase->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:511
    23	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:810
    22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
    21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
    13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
    12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
    11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
    10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
    9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.09 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 9.650 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
    29	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    28	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    27	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    26	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    25	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    24	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
    23	JFalangDatabase->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:862
    22	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
    21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
    20	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
    13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
    12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
    11	Helix3::loadMegaMenu()	JROOT/templates/vina_bubox/features/menu.php:34
    10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
    9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 3.51 ms After last query: 5.09 ms Query memory: 0.049 MB Memory before query: 9.982 MB Rows returned: 50

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM lws_modules AS m
    
      LEFT JOIN lws_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN lws_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-01-17 11:32:49') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-17 11:32:49') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 501 OR mm.menuid <= 0) 
      AND m.language IN ('vi-VN','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	30	1.55	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	hkecc763_hkec.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	hkecc763_hkec.m.id	3	40.00	Using where; 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/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:507
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:454
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:263
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.10 ms After last query: 0.39 ms Query memory: 0.026 MB Memory before query: 10.050 MB Rows returned: 0

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM lws_falang_content AS falang_content
    
      WHERE falang_content.language_id=6
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(193,99,17,198,205,206,238,207,230,187,112,201,243,200,115,209,222,109,242)
       
      AND falang_content.reference_table='modules'

    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
    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:269
    19	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    18	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    17	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    16	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:507
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:454
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:263
    8	Helix3::generatelayout()	JROOT/templates/vina_bubox/index.php:131
    7	require JROOT/templates/vina_bubox/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 4 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
     FROM lws_falang_content AS falang_content

2. 2 × 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

3. 2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM lws_categories as c 
     LEFT JOIN  (SELECT cat.id as id 
     FROM lws_categories AS cat JOIN lws_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

4. 1 × SELECT joomlatablename,tablepkID 
     FROM `lws_falang_tableinfo

5. 1 × SELECT * 
     FROM lws_languages

6. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
     FROM lws_categories as c 
     LEFT JOIN  (SELECT cat.id as id 
     FROM lws_categories AS cat JOIN lws_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

7. 1 × SELECT language,id 
     FROM `lws_menu`

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

9. 1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` 
     FROM `lws_categories` AS `c` 
     INNER JOIN `lws_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_categories.item' 
     INNER JOIN `lws_associations` AS `a2` 
     ON a.key = a2.key 
     INNER JOIN `lws_categories` AS `c2` 
     ON a2.id = c2.`id` 
     AND c2.extension = 'com_content'

10. 1 × SELECT * 
      FROM lws_assets

11. 1 × SELECT a.rules 
      FROM lws_assets AS a

12. 1 × SELECT element 
      FROM lws_extensions

13. 1 × SELECT a.name, a.rules 
      FROM lws_assets AS a

14. 1 × SELECT `config` 
      FROM `lws_virtuemart_configs`

15. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM lws_modules AS m 
      LEFT JOIN lws_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN lws_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

OTHER Tables:

1. 1 × SHOW FULL COLUMNS 
     FROM `lws_languages

2. 1 × UPDATE `lws_extensions` 
     SET `params` = '{\"mediaversion\":\"3e5fc23f494e900bfe52695ec71c431c\"}'

3. 1 × SHOW FULL COLUMNS 
     FROM `lws_assets

4. 1 × SHOW TABLES LIKE "lws_virtuemart_configs