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

35 Queries Logged 26.93 ms

1. Query Time: 0.77 ms Query memory: 0.050 MB Memory before query: 4.561 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.10 ms After last query: 1.33 ms Query memory: 0.027 MB Memory before query: 4.708 MB Rows returned: 7

   SELECT joomlatablename,tablepkID 
     FROM `lws_falang_tableinfo`

   Explain

   id	select_type	table	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.17 ms After last query: 0.10 ms Query memory: 0.029 MB Memory before query: 4.720 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.52 ms After last query: 1.97 ms Query memory: 0.031 MB Memory before query: 4.892 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.08 ms After last query: 0.70 ms Query memory: 0.026 MB Memory before query: 4.951 MB Rows returned: 0
   Duplicate queries: #7

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

6. Query Time: 0.12 ms After last query: 7.68 ms Query memory: 0.047 MB Memory before query: 5.586 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.07 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 5.656 MB Rows returned: 0
   Duplicate queries: #5

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

   Explain

   id	select_type	table	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.78 ms After last query: 1.79 ms Query memory: 0.005 MB Memory before query: 5.700 MB

   UPDATE `lws_extensions`
   
     SET `params` = '{\"mediaversion\":\"48626d7ad9a4acd269a6f33adf6044f8\"}'
   
     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: 0.56 ms After last query: 79.84 ms Query memory: 0.029 MB Memory before query: 6.654 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
   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/libraries/joomla/database/driver/mysqli.php:440
   23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
   22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
   21	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
   20	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
   19	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
   18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
   17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
   16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
   15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
   14	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
   13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
   12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
   11	ContentViewCategory->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: 0.69 ms After last query: 0.22 ms Query memory: 0.027 MB Memory before query: 6.678 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
    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/plugins/system/falangdriver/falang_database.php:408
    22	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    21	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    20	JFalangDatabase->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    19	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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: 0.09 ms After last query: 0.19 ms Query memory: 0.026 MB Memory before query: 6.677 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
    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:170
    18	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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.11 ms After last query: 0.62 ms Query memory: 0.038 MB Memory before query: 6.707 MB Rows returned: 247

    SELECT a.id, a.parent_id
    
      FROM lws_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	401	20.20	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/libraries/joomla/access/access.php:332
    19	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
    18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

13. Query Time: 0.17 ms After last query: 31.04 ms Query memory: 0.073 MB Memory before query: 6.854 MB Rows returned: 247

    SELECT a.id, a.name, a.rules
    
      FROM lws_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	401	20.20	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:1255
    20	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
    19	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
    18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    16	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

14. Query Time: 1.97 ms After last query: 1.88 ms Query memory: 0.026 MB Memory before query: 7.110 MB Rows returned: 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,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=81
    
      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	23	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
    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/libraries/legacy/categories/categories.php:309
    16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    15	JCategories->get()	JROOT/components/com_content/models/category.php:354
    14	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

15. Query Time: 0.43 ms After last query: 1.57 ms Query memory: 0.029 MB Memory before query: 7.297 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
    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/plugins/system/falangdriver/falang_database.php:170
    23	JFalangDatabase->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    22	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    21	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    20	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    19	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    18	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

16. Query Time: 1.84 ms After last query: 0.26 ms Query memory: 0.029 MB Memory before query: 7.314 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
    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/plugins/system/falangdriver/falang_database.php:451
    23	JFalangDatabase->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    22	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    21	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    20	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    19	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    18	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

17. Query Time: 4.05 ms After last query: 0.93 ms Query memory: 0.070 MB Memory before query: 7.529 MB Rows returned: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM lws_content AS a
    
      LEFT JOIN lws_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN lws_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN lws_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN lws_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN lws_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER 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
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid = 81 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-30 20:33:22') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-30 20:33:22') 
      AND a.language in ('vi-VN','*')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 20

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	a	NULL	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	32	16.00	Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	PRIMARY	v	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using where; Using index
    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
    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/libraries/legacy/model/legacy.php:310
    17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

18. Query Time: 0.78 ms After last query: 0.34 ms Query memory: 0.026 MB Memory before query: 7.613 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(504,413,392,391,390)
       
      AND falang_content.reference_table='content'

    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
    24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
    21	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    20	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    18	JFalangDatabase->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

19. Query Time: 0.49 ms After last query: 1.52 ms Query memory: 0.025 MB Memory before query: 7.757 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `lws_contentitem_tag_map` AS m 
    
      INNER JOIN `lws_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 504 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hkecc763_hkec.m.tag_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
    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/libraries/cms/helper/tags.php:435
    16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

20. Query Time: 1.95 ms After last query: 0.33 ms Query memory: 0.025 MB Memory before query: 7.762 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `lws_contentitem_tag_map` AS m 
    
      INNER JOIN `lws_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 413 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hkecc763_hkec.m.tag_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
    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/libraries/cms/helper/tags.php:435
    16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

21. Query Time: 0.38 ms After last query: 0.34 ms Query memory: 0.025 MB Memory before query: 7.781 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `lws_contentitem_tag_map` AS m 
    
      INNER JOIN `lws_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 392 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hkecc763_hkec.m.tag_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
    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/libraries/cms/helper/tags.php:435
    16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

22. Query Time: 0.46 ms After last query: 0.29 ms Query memory: 0.025 MB Memory before query: 7.800 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `lws_contentitem_tag_map` AS m 
    
      INNER JOIN `lws_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 391 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hkecc763_hkec.m.tag_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
    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/libraries/cms/helper/tags.php:435
    16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

23. Query Time: 1.57 ms After last query: 0.28 ms Query memory: 0.025 MB Memory before query: 7.819 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `lws_contentitem_tag_map` AS m 
    
      INNER JOIN `lws_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 390 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hkecc763_hkec.m.tag_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
    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/libraries/cms/helper/tags.php:435
    16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

24. Query Time: 1.15 ms After last query: 1.14 ms Query memory: 0.026 MB Memory before query: 7.909 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM lws_content AS a
    
      LEFT JOIN lws_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN lws_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN lws_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN lws_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN lws_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER 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
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid = 81 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-30 20:33:22') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-30 20:33:22') 
      AND a.language in ('vi-VN','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	a	NULL	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	32	16.00	Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
    1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	hkecc763_hkec.a.id	1	100.00	Using where; Using index
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using where; Using index
    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
    24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    21	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    20	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    19	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
    18	JFalangDatabase->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
    17	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
    16	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
    15	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
    14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

25. Query Time: 0.38 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 7.911 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `lws_contentitem_tag_map` AS m 
    
      INNER JOIN `lws_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 81 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	hkecc763_hkec.m.tag_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/helper/tags.php:435
    13	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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]

    ---

26. Query Time: 3.05 ms After last query: 56.72 ms Query memory: 0.029 MB Memory before query: 9.844 MB Rows returned: 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 
      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=81
    
      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
    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/libraries/legacy/categories/categories.php:309
    23	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    22	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    21	ContentHelperRoute::getArticleRoute()	JROOT/templates/vina_bubox/html/layouts/joomla/content/intro_image.php:39
    20	include JROOT/templates/vina_bubox/html/layouts/joomla/content/intro_image.php	JROOT/libraries/cms/layout/file.php:121
    19	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
    18	JLayoutHelper::render()	JROOT/templates/vina_bubox/html/com_content/category/blog_item.php:33
    17	include JROOT/templates/vina_bubox/html/com_content/category/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
    16	JViewLegacy->loadTemplate()	JROOT/templates/vina_bubox/html/com_content/category/blog.php:86
    15	include JROOT/templates/vina_bubox/html/com_content/category/blog.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
    12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
    11	ContentViewCategory->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]

    ---

27. Query Time: 0.11 ms After last query: 12.34 ms Query memory: 0.021 MB Memory before query: 9.810 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]

    ---

28. Query Time: 0.08 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 9.820 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]

    ---

29. Query Time: 0.44 ms After last query: 0.85 ms Query memory: 0.021 MB Memory before query: 9.868 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 = 468

    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]

    ---

30. Query Time: 1.36 ms After last query: 1.25 ms Query memory: 0.022 MB Memory before query: 9.895 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 = 81 
      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]

    ---

31. Query Time: 0.67 ms After last query: 21.50 ms Query memory: 0.029 MB Memory before query: 11.677 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]

    ---

32. Query Time: 0.10 ms After last query: 0.13 ms Query memory: 0.028 MB Memory before query: 11.690 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]

    ---

33. Query Time: 1.37 ms After last query: 5.70 ms Query memory: 0.050 MB Memory before query: 12.027 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 <= '2024-04-30 20:33:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-30 20:33:22') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 468 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]

    ---

34. Query Time: 0.08 ms After last query: 0.30 ms Query memory: 0.026 MB Memory before query: 12.097 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]

    ---