{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1561438749,
                "last": 1561438749,
                "now": 1561438749
            },
            "token": "uxc3bfR2NTj8H6t7HuDXcTArvlSkQFJs"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Time

Memory

65 Queries Logged 69.83 ms

1. Query Time: 2.13 ms Query memory: 0.244 MB Memory before query: 1.985 MB Rows returned: 210
   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 ng8kc_menu AS m
   
     LEFT JOIN ng8kc_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	292	8.60	Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.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
   25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
   24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
   22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
   8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.17 ms After last query: 0.94 ms Query memory: 0.031 MB Memory before query: 2.387 MB Rows returned: 12

   SELECT joomlatablename,tablepkID 
     FROM `ng8kc_falang_tableinfo`

   Explain

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

   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:1695
   28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
   27	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:147
   26	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:60
   25	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
   24	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
   23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
   22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
   8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.21 ms After last query: 0.15 ms Query memory: 0.034 MB Memory before query: 2.402 MB Rows returned: 2

   SELECT * 
     FROM ng8kc_languages 
     ORDER BY ordering

   Explain

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

   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:1695
   28	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
   27	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:322
   26	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
   25	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
   24	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
   23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
   22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
   8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.50 ms After last query: 0.37 ms Query memory: 0.037 MB Memory before query: 2.428 MB Rows returned: 14

   SHOW FULL COLUMNS 
     FROM `ng8kc_languages`

   Explain

   EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ng8kc_languages`

   Profile

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

   Call Stack

   #	Caller	File and line number
   34	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
   33	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
   31	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   29	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   28	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:77
   27	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:328
   26	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:66
   25	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:88
   24	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:52
   23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
   22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
   8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.92 ms After last query: 1.29 ms Query memory: 0.030 MB Memory before query: 2.488 MB Rows returned: 0
   Duplicate queries: #7

   SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
   
     FROM ng8kc_falang_content AS falang_content
   
     WHERE falang_content.language_id=1
   	
     AND falang_content.published=1
      
     AND falang_content.reference_id IN(983,984,985,986,999,929,956,1000,457,491,992,994,996,1007,920,219,526,220,221,274,222,225,226,227,695,327,330,331,394,538,443,395,444,445,391,620,1001,332,334,333,598,978,959,918,892,709,682,615,499,335,400,617,401,440,441,402,403,431,432,497,562,932,495,933,456,467,102,103,525,110,111,280,114,295,296,297,108,216,291,292,790,185,260,300,370,619,640,149,302,556,301,151,697,701,703,704,368,371,438,439,372,373,618,105,187,376,377,379,380,188,339,340,341,507,527,381,382,189,384,386,387,388,396,191,104,977,960,919,893,708,681,242,498,116,117,496,561,500,931,494,934,921,997,930,935,998,141,925,991,993,995,922,1006,109,603,210,211,212,213,157,958,215,369,399,404,405,406,408,409,410,411,517,412,413,528,518,516,414,415,416,417,418,419,420,421,422,449,451,452,453,454,455,514,979,515,532,553,604,616,621,622,676,602,916,917,679,749,555,928,981)
      
     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	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
   28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
   27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
   25	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
   24	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
   23	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
   22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
   8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 2.52 ms After last query: 3.12 ms Query memory: 0.234 MB Memory before query: 3.092 MB Rows returned: 210
   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 ng8kc_menu AS m
   
     LEFT JOIN ng8kc_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	292	8.60	Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.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
   21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
   20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
   18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:305
   11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
   10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
   8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
   7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.84 ms After last query: 1.76 ms Query memory: 0.029 MB Memory before query: 3.428 MB Rows returned: 0
   Duplicate queries: #5

   SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
   
     FROM ng8kc_falang_content AS falang_content
   
     WHERE falang_content.language_id=1
   	
     AND falang_content.published=1
      
     AND falang_content.reference_id IN(983,984,985,986,999,929,956,1000,457,491,992,994,996,1007,920,219,526,220,221,274,222,225,226,227,695,327,330,331,394,538,443,395,444,445,391,620,1001,332,334,333,598,978,959,918,892,709,682,615,499,335,400,617,401,440,441,402,403,431,432,497,562,932,495,933,456,467,102,103,525,110,111,280,114,295,296,297,108,216,291,292,790,185,260,300,370,619,640,149,302,556,301,151,697,701,703,704,368,371,438,439,372,373,618,105,187,376,377,379,380,188,339,340,341,507,527,381,382,189,384,386,387,388,396,191,104,977,960,919,893,708,681,242,498,116,117,496,561,500,931,494,934,921,997,930,935,998,141,925,991,993,995,922,1006,109,603,210,211,212,213,157,958,215,369,399,404,405,406,408,409,410,411,517,412,413,528,518,516,414,415,416,417,418,419,420,421,422,449,451,452,453,454,455,514,979,515,532,553,604,616,621,622,676,602,916,917,679,749,555,928,981)
      
     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	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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:1695
   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/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:305
   11	plgSystemFalangdriver->parseRule()	Same as call in the line below.
   10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
   9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
   8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
   7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.29 ms After last query: 1.47 ms Query memory: 0.026 MB Memory before query: 3.132 MB Rows returned: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ng8kc_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ng8kc_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

   Profile

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

   Call Stack

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
   17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
   15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
   14	JFalangDatabase->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
   12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 1.12 ms After last query: 0.24 ms Query memory: 0.005 MB Memory before query: 3.114 MB

   UPDATE `ng8kc_extensions`
   
     SET `params` = '{\"mediaversion\":\"976351b915eaafe488b10dd1dff6b07a\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	ng8kc_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/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.33 ms After last query: 0.51 ms Query memory: 0.022 MB Memory before query: 3.154 MB Rows returned: 1

    SELECT id, home, template, s.params
    
      FROM ng8kc_template_styles as s
    
      LEFT JOIN ng8kc_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	16.67	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	ehc_staging_joomla.s.template,const	1	4.47	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    7	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    5	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.81 ms After last query: 1.49 ms Query memory: 0.031 MB Memory before query: 3.278 MB Rows returned: 40

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ng8kc_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_civicrm','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_falang','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')

    Explain

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

    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:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.20 ms After last query: 0.28 ms Query memory: 0.152 MB Memory before query: 3.330 MB Rows returned: 768

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ng8kc_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ng8kc_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	854	21.29	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:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.58 ms After last query: 1.49 ms Query memory: 0.037 MB Memory before query: 3.945 MB Rows returned: 31

    SHOW FULL COLUMNS 
      FROM `ng8kc_content`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ng8kc_content`

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    15	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.23 ms After last query: 0.75 ms Query memory: 0.038 MB Memory before query: 4.016 MB Rows returned: 1

    SELECT *
    
      FROM ng8kc_content
    
      WHERE `id` = '209'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    11	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.36 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 4.047 MB Rows returned: 0
    Duplicate queries: #18

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(209)
       
      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	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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/plugins/system/falangdriver/falang_database.php:408
    13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:426
    11	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.15 ms After last query: 0.17 ms Query memory: 0.006 MB Memory before query: 4.052 MB

    UPDATE ng8kc_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '209'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	ng8kc_content	NULL	range	PRIMARY	PRIMARY	4	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
    12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    11	JFalangDatabase->execute()	JROOT/libraries/src/Table/Table.php:1245
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.61 ms After last query: 0.68 ms Query memory: 0.039 MB Memory before query: 4.079 MB Rows returned: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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
    
      FROM ng8kc_content AS a
    
      INNER JOIN ng8kc_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN ng8kc_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN ng8kc_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ng8kc_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 209 
      AND c.published > 0 
      AND a.language in ('en-GB','*') 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-25 04:59:09') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-25 04:59:09') 
      AND (a.state = 1 OR a.state =2)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

    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:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    14	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.31 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 4.104 MB Rows returned: 0
    Duplicate queries: #15

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(209)
       
      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	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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/plugins/system/falangdriver/falang_database.php:408
    13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.28 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 4.113 MB Rows returned: 0
    Duplicate queries: #20

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(10)
       
      AND falang_content.reference_table='categories'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	falang_content	NULL	ref	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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/plugins/system/falangdriver/falang_database.php:408
    13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.28 ms After last query: 0.15 ms Query memory: 0.027 MB Memory before query: 4.123 MB Rows returned: 0
    Duplicate queries: #19

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(10)
       
      AND falang_content.reference_table='categories'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	falang_content	NULL	ref	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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/plugins/system/falangdriver/falang_database.php:408
    13	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:151
    12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.31 ms After last query: 1.16 ms Query memory: 0.035 MB Memory before query: 4.230 MB Rows returned: 0

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

    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	ehc_staging_joomla.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
    15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    12	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.96 ms After last query: 1.02 ms Query memory: 0.141 MB Memory before query: 4.263 MB Rows returned: 25

    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 `ng8kc_categories` AS `s`
    
      INNER JOIN `ng8kc_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id = 10
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	78	32.31	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:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.68 ms After last query: 0.39 ms Query memory: 0.030 MB Memory before query: 4.466 MB Rows returned: 0

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(1,10,133,59,58,61,62,117,120,121,122,123,126,127,128,138,139,132,64,140,142,143,68,119,145)
       
      AND falang_content.reference_table='categories'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	falang_content	NULL	ref	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
    23	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    22	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    21	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.53 ms After last query: 0.45 ms Query memory: 0.038 MB Memory before query: 4.504 MB Rows returned: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM ng8kc_fields AS a
    
      LEFT JOIN `ng8kc_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ng8kc_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ng8kc_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ng8kc_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ng8kc_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `ng8kc_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (10,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	ehc_staging_joomla.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.id	1	100.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 2.00 ms After last query: 0.67 ms Query memory: 0.040 MB Memory before query: 4.606 MB Rows returned: 31

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ng8kc_modules AS m
    
      LEFT JOIN ng8kc_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ng8kc_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 <= '2019-06-25 04:59:09') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-06-25 04:59:09') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 514 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ALL	element_clientid,element_folder_clientid	NO INDEX KEY COULD BE USED	NULL	NULL	235	1.00	Using where; Using temporary; Using filesort
    1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	newsfeeds	204	ehc_staging_joomla.e.element,const	2	2.42	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.m.id	4	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
    23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    20	JFalangDatabase->loadObjectList()	Same as call in the line below.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:157
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 1.44 ms After last query: 0.26 ms Query memory: 0.030 MB Memory before query: 4.676 MB Rows returned: 0

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(187,31,30,95,89,159,165,18,87,76,185,49,51,94,39,120,140,20,168)
       
      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	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
    23	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    22	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    21	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    20	JFalangDatabase->loadObjectList()	Same as call in the line below.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:157
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 16.23 ms After last query: 1.29 ms Query memory: 1.959 MB Memory before query: 4.752 MB Rows returned: 312

    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 c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM ng8kc_content AS a
    
      LEFT JOIN ng8kc_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ng8kc_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ng8kc_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ng8kc_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ng8kc_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (133,59,120,121,122,123,126,127,128,138,139,143) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-25 04:59:09') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-25 04:59:09') 
      AND a.language IN ('en-GB','*')
    
      ORDER BY publish_up DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	78	10.00	Using where; Using temporary; Using filesort
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	ehc_staging_joomla.c.id	10	14.59	Using index condition; Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.modified_by	1	100.00	Using where
    1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.c.parent_id	1	100.00	Using where
    1	SIMPLE	v	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; 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
    28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    25	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    22	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
    21	ModArticlesCategoryHelper::getList()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    17	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:163
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 1.41 ms After last query: 4.53 ms Query memory: 0.032 MB Memory before query: 9.000 MB Rows returned: 0

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(1255,1251,1252,1253,1254,1250,1256,1257,1258,1259,1260,1249,1238,1237,1241,1248,1247,885,883,1246,1245,1244,1240,1239,1243,785,784,808,783,805,727,806,726,724,698,701,696,718,717,716,715,714,690,688,719,687,686,720,685,721,684,713,712,711,683,682,710,680,677,709,708,707,674,673,676,671,666,665,705,704,703,663,659,657,656,655,654,653,651,650,649,648,647,645,643,642,641,640,638,639,632,630,628,627,626,625,624,623,622,620,619,617,616,615,614,613,609,608,607,606,602,601,600,599,598,597,596,592,594,593,591,595,590,589,588,587,586,585,584,581,583,582,579,578,576,577,575,574,573,572,571,568,569,570,566,567,565,564,563,562,560,559,558,557,556,555,553,551,550,549,547,546,545,544,548,543,542,538,537,535,534,532,533,530,529,528,527,526,525,524,523,521,520,519,518,512,511,510,508,505,504,500,499,497,494,492,491,488,487,485,483,481,480,479,478,477,475,466,473,472,469,468,467,465,464,463,462,461,457,456,449,448,446,445,441,439,423,434,432,429,426,424,421,420,419,418,411,410,407,408,406,405,404,403,402,401,400,396,395,394,390,388,389,385,380,375,373,371,370,369,367,365,363,362,361,360,359,358,355,354,350,349,348,346,343,342,289,335,334,303,330,328,323,302,305,301,300,299,293,290,285,281,280,279,277,267,275,274,273,272,270,269,266,265,252,249,248,247,331,238,208,239)
       
      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	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
    28	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    27	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    26	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    25	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    22	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
    21	ModArticlesCategoryHelper::getList()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    17	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:163
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.99 ms After last query: 0.45 ms Query memory: 0.032 MB Memory before query: 8.992 MB Rows returned: 0
    Duplicate queries: #30

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(120,133,59,126,138,123,127,122,128,121)
       
      AND falang_content.reference_table='categories'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	falang_content	NULL	ref	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
    28	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    27	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    26	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    25	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    22	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
    21	ModArticlesCategoryHelper::getList()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    17	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:163
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.97 ms After last query: 0.36 ms Query memory: 0.032 MB Memory before query: 9.006 MB Rows returned: 0
    Duplicate queries: #29

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(120,133,59,126,138,123,127,122,128,121)
       
      AND falang_content.reference_table='categories'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	falang_content	NULL	ref	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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
    31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:269
    28	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:252
    27	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:125
    26	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:326
    25	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    22	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
    21	ModArticlesCategoryHelper::getList()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    17	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:163
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 1.14 ms After last query: 15.62 ms Query memory: 0.045 MB Memory before query: 12.701 MB Rows returned: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM ng8kc_fields AS a
    
      LEFT JOIN `ng8kc_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ng8kc_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ng8kc_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ng8kc_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ng8kc_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `ng8kc_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_category.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (10,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	ehc_staging_joomla.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	ehc_staging_joomla.a.id	1	100.00	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    36	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    35	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    34	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    33	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    32	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    31	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    30	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    29	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    28	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    27	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    26	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    25	JHtmlContent::prepare()	Same as call in the line below.
    24	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    23	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    22	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_category/helper.php:304
    21	ModArticlesCategoryHelper::getList()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    18	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    17	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    16	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:163
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.84 ms After last query: 252.15 ms Query memory: 0.027 MB Memory before query: 7.267 MB Rows returned: 1

    SELECT params 
      FROM ng8kc_extensions AS e 
      WHERE e.element='com_widgetkit'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    17	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    16	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:343
    15	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:134
    14	JFalangDatabase->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
    13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
    12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
    11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
    10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
    9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.21 ms After last query: 0.42 ms Query memory: 0.025 MB Memory before query: 7.285 MB Rows returned: 1

    SELECT id,template 
      FROM ng8kc_template_styles 
      WHERE client_id=0 
      AND home=1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ng8kc_template_styles	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	16.67	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:96
    13	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    11	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:408
    10	JFalangDatabase->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
    9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->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.63 ms After last query: 2.74 ms Query memory: 0.023 MB Memory before query: 7.479 MB Rows returned: 1

    SELECT language,id
    
      FROM `ng8kc_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	ng8kc_menu	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	292	0.86	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:1695
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:274
    9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.40 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 7.489 MB Rows returned: 0

    SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
    
      FROM ng8kc_falang_content AS falang_content
    
      WHERE falang_content.language_id=1
    	
      AND falang_content.published=1
       
      AND falang_content.reference_id IN(157)
       
      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	falangContent,falangContentLanguage,reference_id,language_id,reference_table,idxFalang1	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:1695
    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/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.26 ms After last query: 0.58 ms Query memory: 0.023 MB Memory before query: 7.501 MB Rows returned: 0